( Excel::Writer::XLSX->new) question: how to open single sheet by name
Hello,
I went through cpan page of (Excel::Writer::XLSX) It only say one method which is open document, and all the sheets will be read into an array, then you loop array to do some thing with sheets. In my case I only have one sheet, I did datadump on object Code:
my $workbook = Excel::Writer::XLSX->new( 'B.xlsx' ) ; So how do address one sheet with out looping into array. |
Please clarify. Are you trying to use Libreoffice to handle this document?
"It only say one method" to what does 'it' refer? |
xlsx is a Microsoft format for a spreadsheet. Are you trying to convert that to an .ods format, which is an opendocument format for a spreadsheet?
jdk |
This perl module cannot be used to write to an existing excel file. It can create new files only.
Quote:
something like for my $worksheet ( $workbook->worksheets() ) { } my @sheets = $workbook->worksheets(); $sheets[0] will contain the first element. So what's the problem with that? |
All times are GMT -5. The time now is 09:56 PM. |