Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel XLS/XLSX to CSV
Message
From
17/05/2016 18:25:43
 
 
To
17/05/2016 10:55:55
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
01636368
Message ID:
01636542
Views:
48
>
>I have tried the XLSXWorkbook class. It opens a small XLSX file quickly. But one with 20,000 rows takes a very long time but perhaps I do something wrong (although I only change the filename ...?) Anyway, I found another tool which seems very powerful - https://www.coolutils.com/TotalExcelConverter - very fast conversion.

Just made an experiment with a 10MB/160k rows XLSX file. It is ingested by an XLSX reader class of mine that rely heavily on the XML parser to hold and process data (there is only a cursor for shared strings, that is, the strings that are used in the spreadsheet) in 14 seconds. The same file, imported by LibreOffice Calc, takes 12 seconds to load (of course, LO Calc has to transform the file into ODF format, in the process).

Although these are not actual figures for XLSXWorkbook, I believe theirs should not be too far away. In perspective, such timings seem acceptable to me.
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform