Re: Adding new workbook to existing excel

[LanX]

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

[Corion]

I haven't used it, but I think Spreadsheet::ParseExcel::SaveParser claims to do just that.

[LanX]

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.