Read the file using Spreadsheet::ParseExcel, write the updated file using Spreadsheet::WriteExcel. See Modifying and rewriting Excel files.

Update: Fixed typo thanks Tux.

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

Thanks for pointing out the typo (fixed) and for letting me know about Spreadsheet::Read.

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

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