Perl Monk, Perl Meditation | |
PerlMonks |
Re^2: Scan cells in Excel active worksheetby gauss76 (Scribe) |
on Apr 03, 2017 at 15:19 UTC ( [id://1186841]=note: print w/replies, xml ) | Need Help?? |
OK, I explained badly! The Excel file is saved to disk on the linux server. I use the following commands to get acces to the Excel file $parser = Spreadsheet::ParseExcel->new(); $parser = Spreadsheet::ParseXLSX->new();I use one of the above depending on whether the file is .xls or .xlsx. Then I use: my $workbook = $parser->parse($FileName);It's the next part that is causing the problem. currently I loop through all worksheets with for my $worksheet ( $workbook->worksheets() )But I really only want to work with the active worksheet. gauss76
In Section
Seekers of Perl Wisdom
|
|