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
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?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);
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Adding new workbook to existing excel
by LanX (Saint) on Jan 29, 2013 at 10:55 UTC | |
by Corion (Patriarch) on Jan 29, 2013 at 11:02 UTC | |
by LanX (Saint) on Jan 29, 2013 at 11:30 UTC | |
Re: Adding new worksheet to existing Excel workbook
by Ratazong (Monsignor) on Jan 29, 2013 at 11:35 UTC | |
by sundialsvc4 (Abbot) on Jan 29, 2013 at 13:30 UTC | |
Re: Adding new workbook to existing excel
by vinoth.ree (Monsignor) on Jan 29, 2013 at 12:28 UTC |
Back to
Seekers of Perl Wisdom