Re: Adding new workbook to existing excel

according to Spreadsheet::WriteExcel new() creates a new file, quote: "The following example creates a new Excel file based on a filename:"

And I can't find how to append to an existing file.

2 possible workarounds:

hold the data separately until you finalize he hole sheet at once.

use Spreadsheet::ParseExcel to read the old data and to rebuild the new spreadsheet

Cheers Rolf

Comment on Re: Adding new workbook to existing excel

Replies are listed 'Best First'.
Re^2: Adding new workbook to existing excel by Corion (Patriarch) on Jan 29, 2013 at 11:02 UTC
I haven't used it, but I think Spreadsheet::ParseExcel::SaveParser claims to do just that.	[reply]
Re^3: Adding new workbook to existing excel by LanX (Saint) on Jan 29, 2013 at 11:30 UTC
yep! =) Just googling for perl append spreadsheet directly led me to this SO discussion --> how-can-i-modify-an-existing-excel-workbook-with-perl, saying the same. It also mentions a Win32::OLE approach. Cheers Rolf	[reply]