How to add a sheet to an existing excel file?

[Ashcraft]

Tried googling and got maybe some older examples of how to solve this problem. But when I tried they didn't seem to work.
I'm able to create and write to a new file but not sure how to edit an existing one.

## open excel ##
if (! -e "$name"){
# Create a new workbook if file doesn't exist.  
my $workbook  = Spreadsheet::WriteExcel->new("$name");
my $worksheet1 = $workbook->add_worksheet('WW01');
$worksheet1->write(0, 0,  'Hi Excel!');
}
else{
#edit existing one
 
 
 }
 

[Rabbit]

I don't know if this will work but if you are able to do ->new() to create a new workbook. Couldn't you use a ->open() to open a workbook?

[RonB]

Have you read the documentation for the module?

This module cannot be used to write to an existing Excel file (See "MODIFYING AND REWRITING EXCEL FILES").

http://search.cpan.org/~jmcnamara/Sp...NG_EXCEL_FILES

[chorny]

use Spreadsheet::ParseExcel

[miller]

As the guys here have already said, you can't use Spreadsheet::WriteExcel to write to an already existing spreadsheet. Instead you must use Spreadsheet::ParseExcel to read in the file and create a new on using Spreadsheet::WriteExcel. After you've done that you can move the newly created file over the old file.

- Miller