Re: How to open existing Worksheet(xls) in Perl

Replies are listed 'Best First'.
Re^2: How to open existing Worksheet(xls) in Perl by Tux (Canon) on Nov 14, 2011 at 12:20 UTC
I'm sure that is a typo. Writing an XLS is done with Spreadsheet::WriteExcel (old format) or Spreadsheet::WriteExcelXML (new format). You can also read spreadsheets with Spreadsheet::Read which is just a wrapper around the available parsers, giving you a unified API for all type of spreadsheet formats. That will support the not-yet-existing Spreadsheet::ParseExcelXML soon after it is available. Enjoy, Have FUN! H.Merijn	[reply]
Re^3: How to open existing Worksheet(xls) in Perl by marto (Cardinal) on Nov 14, 2011 at 12:23 UTC
Thanks for pointing out the typo (fixed) and for letting me know about Spreadsheet::Read.	[reply]
Re^2: How to open existing Worksheet(xls) in Perl by locked_user satishkambam (Initiate) on Nov 14, 2011 at 13:00 UTC
Hi , By using this module we cannot get the proper output. graphs and some other features in the original Excel file will be lost Also, formulas aren't rewritten, only the result of a formula is written. can you help me on this ..
Re^3: How to open existing Worksheet(xls) in Perl by marto (Cardinal) on Nov 14, 2011 at 13:10 UTC
The documentation states: "However, you can only rewrite the features that Spreadsheet::WriteExcel supports so macros, graphs and some other features in the original Excel file will be lost. Also, formulas aren't rewritten, only the result of a formula is written." And later: "If there is some feature of an Excel file that you really, really need then you should use Win32::OLE with Excel on Windows. If you are on Unix you could consider connecting to a Windows server via Docserver or SOAP, see Writing Excel Files."	[reply]