Re: Excel how to open existing worksheet

in reply to Excel how to open existing worksheet

I've never used it, but I would try something like:

use Excel::Writer::XLSX;

my $workbook = Excel::Writer::XLSX->new( 'sample.xlsx' );

$worksheet1 = $workbook->add_worksheet("new");
$worksheet1->write(2,    2, 'Name');

$worksheet2 = $workbook->add_worksheet("old");
$worksheet2->write(2,    2, 'Name');

$worksheet3 = $workbook->add_worksheet("latest");
$worksheet3->write(2,    2, 'Name');

$worksheet1->write(3,    3, 'Something else');
[download]

In Section Seekers of Perl Wisdom