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

In reply to Scan cells in Excel active worksheet by gauss76

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.