Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re^4: XLSX read and dump

by furry_marmot (Pilgrim)
on Jan 18, 2012 at 20:05 UTC ( #948613=note: print w/replies, xml ) Need Help??

in reply to Re^3: XLSX read and dump
in thread XLSX read and dump

FYI, XLSX files ARE zipped. If you look at it in an editor or hex viewer, the first two characters are PK, which indicates it's a ZIP file (from PKZIP, the forerunner of modern ZIP, where PK stands for Phil Katz, who invented it).

If you run unzip (or pkunzip, etc.) on the file, it creates some directories that are full of XML files and RELS files (MS Office 2007+ relationship files). Any module working with an XLSX file would need to include something from the Archive::ZIP family.

That said, I don't work on a Mac, but I would have assumed Spreadsheet::XLSX would have installed Archive::Zip::Archive as a dependency. Maybe the OP should try installing it manually.


Replies are listed 'Best First'.
Re^5: XLSX read and dump
by runrig (Abbot) on Jan 18, 2012 at 20:37 UTC
    I believe the library is installed, but the file either does not exist, or is not a zip archive (i.e. not a valid xlsx file).

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://948613]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (8)
As of 2018-06-18 16:05 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (110 votes). Check out past polls.