Read and Edit XLSX files

tosaiju has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Read and Edit XLSX files by Tux (Canon) on Apr 12, 2012 at 11:36 UTC
John McNamara is working on these tools. Keep checking for updates on his CPAN space. Enjoy, Have FUN! H.Merijn	[reply]
Re^2: Read and Edit XLSX files by tosaiju (Acolyte) on Apr 20, 2012 at 07:22 UTC
Thats great...sure..I'll follow that.....	[reply]
Re: Read and Edit XLSX files by dasgar (Priest) on Apr 12, 2012 at 16:16 UTC
When I use Perl to manipulate Excel files, I'm usually on a Windows system that has Excel installed. As such, I primarily use Win32::OLE to control Excel directly to make the changes. In your case, I believe that you'll need to use Spreadsheet::XLSX to read in the contents of the Excel spreadsheet and use Excel::Writer::XLSX to do the writing/modifying.	[reply]
Re^2: Read and Edit XLSX files by tosaiju (Acolyte) on Apr 20, 2012 at 07:31 UTC
Spreadsheet::XLSX works fine for reading xlsx files. I think Excel::Writer::XLSX is to create new .xlsx files? I would like to edit existing .xlsx file. Also Excel::Writer:XLSX is not listed in PPM. May be required to download - but if it was there in PPM - it would have been easier.	[reply]
Re: Read and Edit XLSX files by temporal (Pilgrim) on Apr 12, 2012 at 15:29 UTC
Adding to the previous comment, I have successfully used Spreadsheet::ParseExcel and Spreadsheet::WriteExcel on a Windows platform to do what you're describing. Haven't tried it on Linux, but the docs claim that it should work.	[reply]
Re^2: Read and Edit XLSX files by Tux (Canon) on Apr 12, 2012 at 15:37 UTC
They do. I use them on Linux, HP-UX and AIX. But these are for .xls, not for .xlsx Enjoy, Have FUN! H.Merijn	[reply]
Re^3: Read and Edit XLSX files by temporal (Pilgrim) on Apr 12, 2012 at 16:16 UTC
Oh! Right, missed that.	[reply]
Re^2: Read and Edit XLSX files by chilledham (Friar) on Apr 12, 2012 at 16:16 UTC
While both Spreadsheet::ParseExcel and Spreadsheet::WriteExcel work on Windows and Linux, neither will read or write xlsx files. I've taken the non-Perl approach of saving an xlsx file in the older xls format and then using the former to parse the document. It's a little busy work, but gets the job done. One common gotcha with this approach is that the two Excel formats have different row limits. xls has a limit of 65k rows, while xlsx has a 1 million row limit. There are other incompatibilities but I find this one to be more common.	[reply]