phpoffice/phpspreadsheet 1.16.0 requires ext-zip * -> it is missing from your system. Install or enable PHP's zip extension.

Problem 1
- Root composer.json requires phpoffice/phpspreadsheet ^1.16 -> satisfiable by phpoffice/phpspreadsheet[1.16.0].
- phpoffice/phpspreadsheet 1.16.0 requires ext-zip * -> it is missing from your system. Install or enable PHP's zip extension.

Solution

This solution assumes you are building from source PHP. If not, just install the extension php7.3-zip with apt-get.

Step 1 - Install libraries before configuring PHP

$ apt-get install libzip-dev

Step 2 - Edit install_php.sh to have --with-zip in it next to the other configure options

Step 2 - Reconfigure & compile PHP from source

$ ./install_php.sh 7.4.12

Troubleshooting

configure: error: Package requirements (libzip >= 0.11 libzip != 1.3.1 libzip != 1.7.0) were not met:

No package 'libzip' found
No package 'libzip' found
No package 'libzip' found

You likely did not run Step 1 before configuring & building PHP.