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

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 ..

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

Replies are listed 'Best First'.

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]