in reply to Re^2: Errors while parsing a specific type of Excel File.
in thread Errors while parsing a specific type of Excel File.
Your file has 28 different worksheets according to the version of OpenOffice (2.2.1) that I'm running. There's a side-by-side display set up for two of the worksheets (or two worksheet sections at least) in the default view that opens. There's a lot of formatting in pretty much every sheet. I was prompted upon opening it about whether or not I wanted to allow macros to run. In short, it's a quite complex file. I'm not shocked that a free third-party library doesn't quite read it properly, even though the one in question does really well on most Excel files.
You might need to export some data before working with it. If you can offer, this file might be a good stress test for further work with whatever Excel-reading libraries (such as but not limited to Spreadsheet::ParseExcel) are available. As I said before, it would be good to get clearance for sharing it if you must.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^4: Errors while parsing a specific type of Excel File.
by pankaj_it09 (Scribe) on Dec 16, 2008 at 05:31 UTC | |
| A reply falls below the community's threshold of quality. You may see it by logging in. |