Append to current file using perl Spreadsheet::SimpleExcel

bobdole has asked for the wisdom of the Perl Monks concerning the following question:

Is it possible to open an excel spread sheet that already exists using Spreadsheet::SimpleExcel and append new data after the last row of current data? Or do I need to use something different like Win32::OLE with Excel? My current script writes data to an excel file using SimpleExcel so I would prefer not to have to rewrite using a different module.

Also if I use OLE excel has to be installed on the machine correct? I would like to avoid that.

Comment on Append to current file using perl Spreadsheet::SimpleExcel

Replies are listed 'Best First'.
Re: Append to current file using perl Spreadsheet::SimpleExcel by aquarium (Curate) on Oct 31, 2007 at 21:10 UTC
"normally" you'd write out a whole new file whenever handling anything other than text file. There should be some kind of "tie" implementation for SimpleExcel though. there's a little writeup on writing excel files here the hardest line to type correctly is: stty erase ^H	[reply]
Re^2: Append to current file using perl Spreadsheet::SimpleExcel by bobdole (Beadle) on Oct 31, 2007 at 22:13 UTC
Thanks, I will take a look at it.	[reply]