Perl reading XLSX attached documents

First post here, if I am doing something stupid please let me know.

CentOS 7 (3.10.0-123.6.3.el7.x86_64), perl5 (version 5 version 16 subversion 3), spreadsheet :: ParseXLSX v0.16

I have a .xlsx that has .pdfs embedded and another xlsx embedded in it. I am trying to read them and paste them into csv along with the original xlsx. After some googl'ing to no avail, my thought was to unzip the original xlsx and read the files from the xl / embeddings directory, but alas, there is something with the file that prevents Adobe Reader from being able to read the oleObject (X) .bin in this directory. I was able to successfully read all worksheets where the dio does not contain inline documents using Spreadsheet :: ParseXLSX, works fine. I have googled for a solution, but either I am not using the correct search strollers, or ... If you know how to do this, can you point me to some instructions?

TIA, JohnM

+3


source to share





All Articles