I am working on a project and the task wants me to sort through 10,000 lines from an .xlsx file. I got it working with apache.org.poi jars but it is going extremely slow to just read the line and put it in an array. Is there any other way to read excel .xlsx files (that is quicker) that does not involve apache? Thank you
Asked
Active
Viewed 103 times
0
-
yes, you can check my answer http://stackoverflow.com/a/16890299/2381006 – dev2d Apr 05 '14 at 20:55
-
I tried and got 'Unable to recognize OLE stream' error, looked it up and it only works with excel files created before 2000 – rdadkins Apr 05 '14 at 21:07
-
If you're really brave, you can unzip the file and process the resulting to XML files yourself – MadProgrammer Apr 05 '14 at 21:13
-
Not that mad of a programmer like yourself – rdadkins Apr 05 '14 at 21:14