Front page | perl.beginners |
Postings from June 2012
Hi,
I'm using perl module Spreadsheet::ParseExcel here
http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel-0.59/lib/Spreadsheet/ParseExcel.pm.
I have a Excel spreadsheet which has 8 worksheets in and I would like
to parse just worksheets 3 and 4.
I've tried amending this line in my script every which way but with no
joy.
for my $worksheet ( $workbook->worksheets() ) {
The documentation says that the worksheets() method returns an array
of worksheets but I cant seem to reference any of these in the usual
way in order to syphon out the worksheets that I don't need either.
When I print out $worksheet I get
Spreadsheet::ParseExcel::Worksheet=HASH(0x61e3d0)
Spreadsheet::ParseExcel::Worksheet=HASH(0xf9b9b0)
Spreadsheet::ParseExcel::Worksheet=HASH(0xf9ba60)
Spreadsheet::ParseExcel::Worksheet=HASH(0xf9cab0)
Spreadsheet::ParseExcel::Worksheet=HASH(0xf9cb40)
Spreadsheet::ParseExcel::Worksheet=HASH(0xf9cbd0)
Spreadsheet::ParseExcel::Worksheet=HASH(0xf9cc60)
Spreadsheet::ParseExcel::Worksheet=HASH(0xf9ccf0)
It may be that this module doesn't allow for this but I'd really
appreciate any help.
Thank you.
Thread Next