I need to use Excel::Writer::XLSX for writer and Spreadsheet::XLSX for reader, but I didn't know how to use it

Start by reading the documentation for that modules.

I tried with the below script, but this one uses the old xls application, my files are xlsx.

Quick and dirty way: Convert XLSX to XLS, then use the old script, finally convert XLS back to XLSX.

I can feel that you will ask how to convert between XLS and XLSX. Well, let me give you a hint: Modern Excel can read and write old excel formats.

I appreciate your help.

I think you misspelled that. Did you mean "Write code for me"?

Perlmonks is not a code writing service. Use the quick and dirty hack, or start using your own brain. Yes, learning Perl takes time, like learning any other language.

You have an old script that uses the "wrong" modules. I know that at least some of the Spreadsheet::* modules intentionally have very similar, if not identical, APIs for handling XLS and XLSX. So start by simply replacing the XLS module names with the XLSX module names in the script. Start the script, look at the errors it gives you and try to fix them. You will very likely need the documentation for the XLS and XLSX modules, and you have to read the documentation.

When you reach the point where you can no longer find a way to fix an error, post the modified code and the error messages in this thread.

Alexander