No such thing as a small change | |
PerlMonks |
Scan cells in Excel active worksheetby gauss76 (Scribe) |
on Apr 03, 2017 at 14:21 UTC ( [id://1186831]=perlquestion: print w/replies, xml ) | Need Help?? |
gauss76 has asked for the wisdom of the Perl Monks concerning the following question: Hi, I have been learning Perl over the last few weeks with specific interest in being able to read Excel files on a non-windows server. I use the two packages: use Spreadsheet::ParseExcel; use Spreadsheet::ParseXLSX;for reading Excel .xls and .xlsx files respectively. Recently I came across a problem that I cannot find any answer to: Is it possible to read just the cells of the active worksheet of an opened Excel file? I know it is possible to loop over all the worksheets in the workbook and also possible to select any given worksheet by its name or number. However, in my application I only want to scan the rows and columns of the active worksheet but cannot find anyway of doing so. Any help on this would be much appreciated. Many thanks gauss76
Back to
Seekers of Perl Wisdom
|
|