Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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.

--marmot


Comment on Re^4: XLSX read and dump
Select or Download Code
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://948613]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (5)
As of 2014-09-23 01:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (210 votes), past polls