in reply to Read and Edit XLSX files

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.

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

In Section Seekers of Perl Wisdom