in reply to Spreadsheet-WriteExcel open existing XLS file

For the most part, Spreadsheet::ParseExcel will read those files. There is a known caveat about formulas, but that's well-documented.
My criteria for good software:
  1. Does it work?
  2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
  • Comment on Re: Spreadsheet-WriteExcel open existing XLS file

Replies are listed 'Best First'.
Re^2: Spreadsheet-WriteExcel open existing XLS file
by Anonymous Monk on Nov 03, 2007 at 01:41 UTC
    Will Spreadsheet::ParseExcel allow me to add data to the XLS file and then save? Here is my story so far: I wrote a Perl program to create and add data to a XLS spreadsheet using WIN32OLE. My company, now, will not let me install Excel on the server. So I now need to recreate the script so as not to use the actual Excel application. So I need to find a way to open, add data, and then save the XLS spreadsheet using Perl.
[reply]
      There is currently no one-stop solution that provides reading and writing of Excel files without Win32::OLE. Putting one together with both WriteExcel and ParseExcel shouldn't be too hard. If you want some help, I'd be glad to give some advice. A solution using tie and DBM::Deep for the data structures might be kinda cool.
      My criteria for good software:
      1. Does it work?
      2. Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
[reply]
[reply]

      Spreadsheet::ParseExcel contains a sub-module called SaveParser that is a combination of ParseExcel and WriteExcel and which allows you to add data to an existing Excel file.

      It is far from perfect but it might work for you.

      Here is an example.

      --
      John.

[reply]

In Section Seekers of Perl Wisdom