in reply to Re: Spreadsheet-WriteExcel open existing XLS file
in thread Spreadsheet-WriteExcel open existing XLS file

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.
  • Comment on Re^2: Spreadsheet-WriteExcel open existing XLS file

Replies are listed 'Best First'.
Re^3: Spreadsheet-WriteExcel open existing XLS file
by dragonchild (Archbishop) on Nov 03, 2007 at 02:10 UTC
    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?
Re^3: Spreadsheet-WriteExcel open existing XLS file
by marto (Cardinal) on Nov 03, 2007 at 09:21 UTC
Re^3: Spreadsheet-WriteExcel open existing XLS file
by jmcnamara (Monsignor) on Nov 03, 2007 at 16:49 UTC

    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.