Update existing xlsx file using Excel-Writer-XLSX

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

Hi,

I am trying to update an existing xlsx (Microsoft 2007 document) with Excel-Writer-XLSX-0.46 module.

I am not getting any option to open an existing file and select the required sheet.

Is there any better alternative modules other than Win32:OLE module to update xlsx files.

I would appreciate any input on this query

Thanks,

Sunil

Comment on Update existing xlsx file using Excel-Writer-XLSX

Replies are listed 'Best First'.
Re: Update existing xlsx file using Excel-Writer-XLSX by Limbic~Region (Chancellor) on Mar 21, 2012 at 13:45 UTC
sunilmh, There are two portions of the docs worth noting. The first is the entire section on "Reading Excel Files". The other is the "To Do" section (see the 3rd item on the list). Excel::Reader::XLSX and Excel::Rewriter::XLSX. Hopefully. Cheers - L~R	[reply]
Re: Update existing xlsx file using Excel-Writer-XLSX by Ralesk (Pilgrim) on Mar 21, 2012 at 11:45 UTC
I believe the only way you have with the `Spreadsheet::` and `Excel::` modules is to slurp up the entire spreadsheet with a parser module, modify the data, and then write a new file with a writer module.	[reply]