XLSX files are actually a zip file containing various xml files. If you disregard Corion's wise suggestion to use a module available on CPAN, you will need to make your script deal with that. You may be able to learn more about how the file structure works by unzipping the file and looking at the various files and directories/folders contained therein (if you are running windows this can be as simple as changing the file extension to .zip and using the included shell extension to extract the files). This format is not nearly as simple and straightforward to parse as the old XLS format, so unless you plan on using one of the modules on CPAN you should expect to spend some time figuring out how the whole XLSX structure works.

In reply to Re: Read XLSX Files by steve
in thread Read XLSX Files by thorvid_461

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.