http://www.perlmonks.org?node_id=1015844

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

Hi, I have created an excel sheet using perl and i am writing the data into that excel file like this
use Spreadsheet::WriteExcel; my $FileName = "/home/Desktop/ABC/report.xls"; my $workbook = Spreadsheet::WriteExcel->new($FileName); my $worksheet1 = $workbook->add_worksheet('report1'); $worksheet1->write($i, 0, $url); $worksheet1->write($i, 1, $title);
Now in the second run i want to create a new worksheet 'report2' to the existing file report.xls. but every time i do that my earlier worksheet is deleted. How can i do that?