Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
comment on |
( [id://3333]=superdoc: 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. gauss76In reply to Re^2: Scan cells in Excel active worksheet
by gauss76
|
|