Re: Read and Edit XLSX files

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.

Comment on Re: Read and Edit XLSX files

Replies are listed 'Best First'.
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]