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

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

How to write to existing worksheet?

use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'sample.xlsx' ); $worksheet = $workbook->add_worksheet("new"); $worksheet->write(2, 2, 'Name'); $worksheet = $workbook->add_worksheet("old"); $worksheet->write(2, 2, 'Name'); $worksheet = $workbook->add_worksheet("latest"); $worksheet->write(2, 2, 'Name');

How to open worksheet "new" for write again?