dhoerl / DHlibxls

Framework to read Excel xls spreadsheets
271 stars 86 forks source link

Can't parse large .xls files when saved from Windows #27

Closed jokeruger closed 6 years ago

jokeruger commented 6 years ago

When trying to open large files (the 'dividing line' seems to be around 23,400 KB) that have been saved from Excel on Windows (the same file saved from Excel on OSX works fine), I get a crash on [DHxlsReader xlsReaderWithPath:]

ghost commented 6 years ago

You didn't attach your file. Please provide the file and I can look at it.

jokeruger commented 6 years ago

Sorry for the delay. I have a spreadsheet that's demonstrating the issue but unfortunately it has some confidential data in it. So I've been removing that, but as I do I'm noticing the issue isn't directly tied to filesize. That was simply a coincidence of adding/removing columns in one specific tab of the spreadsheet, and that's the size it happened to be when those columns were modified. I'm doing some more investigation and will let you know if I learn anything else or get a copy of the spreadsheet I can share

ghost commented 6 years ago

Suggest you build with the latest SVN source (NOT the 1.4 release, the latest SVN trunk code). We fixed a few bugs in the past few months.

On Dec 13, 2017, at 9:57 AM, Joe Kruger notifications@github.com wrote:

Sorry for the delay. I have a spreadsheet that's demonstrating the issue but unfortunately it has some confidential data in it. So I've been removing that, but as I do I'm noticing the issue isn't directly tied to filesize. That was simply a coincidence of adding/removing columns in one specific tab of the spreadsheet, and that's the size it happened to be when those columns were modified. I'm doing some more investigation and will let you know if I learn anything else or get a copy of the spreadsheet I can share

— You are receiving this because you commented. Reply to this email directly, view it on GitHub, or mute the thread.

jokeruger commented 6 years ago

Thanks, I'll try that also

jokeruger commented 6 years ago

Was unable to get the latest code running properly (have run out of budget to look into this further), but we've avoided the issue by not calling for the workbook's summary