Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Excel how to open existing worksheet

by poj (Abbot)
on Jan 27, 2015 at 14:49 UTC ( #1114638=note: print w/replies, xml ) Need Help??


in reply to Excel how to open existing worksheet

#!perl use strict; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'sample.xlsx' ); $workbook->add_worksheet("new"); $workbook->add_worksheet("old"); # select the sheet my $worksheet = $workbook->sheets(0); $worksheet->write(2, 2, 'This is Sheet 1'); # or directly $workbook->sheets(1)->write(2, 2, 'This is Sheet 2');;
poj

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1114638]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2023-02-06 10:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I prefer not to run the latest version of Perl because:







    Results (33 votes). Check out past polls.

    Notices?