Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel XLS/XLSX to CSV
Message
De
17/05/2016 18:25:43
 
 
À
17/05/2016 10:55:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
01636368
Message ID:
01636542
Vues:
49
>
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform