Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

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.


Comment on Re^4: XLSX read and dump
Select or Download Code
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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (15)
As of 2015-10-09 13:21 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (242 votes), past polls