Re: Xlxs Parsing Issue

rahul_lfo:

Since .xlsx (I assume that's what you mean) is a set of zipped XML files, you can use XML::LibXML to parse the original file, and then use Spreadsheet::WriteExcel to generate the older style format. If you only care about the data, and you're not picky about the format, it can be pretty easy to go this route. Unfortunately, the more special features in your original that you want to retain, the more work you'll have to do digging out the relevant information.

I'm assuming that you're not needing any of the unsupported features in Spreadsheet::WriteExcel, though. I didn't bother to look at your image link. Generally it's advised to put all the information here on PerlMonks because the information on other sites may go stale, and then this node will become less useful to others searching the site in the future.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

Comment on Re: Xlxs Parsing Issue

Replies are listed 'Best First'.
Re^2: Xlxs Parsing Issue by Corion (Patriarch) on Nov 07, 2013 at 11:36 UTC
There already is Spreadsheet::XLSX, which conveniently reads `.xlsx` files.	[reply] [d/l]
Re^3: Xlxs Parsing Issue by roboticus (Chancellor) on Nov 07, 2013 at 12:58 UTC
Corion: Yes, I should have mentioned that package. I tried using it a few times, but each time it was for such an overly-large excel file that I always ran out of RAM when parsing it. (Not the module's fault--more the fault of people trying to use Excel as a mass data-transport mechanism.) ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply]
Re^2: Xlxs Parsing Issue by rahul_lfo (Initiate) on Nov 07, 2013 at 11:42 UTC
By .xlxs I mean excel files.	[reply]
Re^3: Xlxs Parsing Issue by soonix (Chancellor) on Nov 08, 2013 at 08:58 UTC
We humans can cope with it. For the computer, you should put the X in the end, not the S :-)	[reply]
Re^4: Xlsx Parsing Issue by rahul_lfo (Initiate) on Nov 08, 2013 at 09:38 UTC
Sorry that was by mistake.	[reply]