Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel XLS/XLSX to CSV
Message
De
18/05/2016 03:24:40
 
 
À
18/05/2016 03:21:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
01636368
Message ID:
01636555
Vues:
54
>>>>
>>>>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.
>>
>>I tried XLSXWorkbook - takes far, far longer than that. In fact, I just killed VFP - I could see this was not going to be a realistic solution for my needs. Total Excel Converter from CoolUtils converts in 2 seconds or less (20k rows x 7 cols).
>
>Just for closure: stripped down the XLSX I used for testing to 20k rows x 23 cols and it loads in 3 seconds (no other processing than loading).
>
>Anyway, the available XSLX libraries (Greg's and Vihlelm's, the ones that I know of) offer much more than conversion services so probably will deserve your revisit in case you'll need something more from the XLSX files you have to process.

Yes, absolutely. The XLSXWorkbook is awesome and I'm sure I can use it. Greg did a great job there, it is very cool! I will check my XLSX file again - perhaps there is something wrong with it but I did re-save it (twice) using Excel 2010 to a new filename and got the same result? Anyway, thanks for your feedback!
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform