Information générale
Catégorie:
Produits tierce partie
Versions des environnements
Network:
Windows 2008 Server
Hi Dragan,
>If you allow for automation but hate the slowness... consider selecting all in excel, .selection.copy(), strtofile(_cliptext, "my.csv", but the actual format is tab delimited) and >see how you like the result. Then of course, instead of reading that file back, just nRows=alines(al, _cliptexT) and take it from there. This should be very fast.
That looks like a nice trick:)
I am using the "range" function to fetch Excel blocks of cells into VFP arrays. That is certainly faster as well than moving through Excel sheets on a cell per cell basis.
I still find the effort of the developer to make and sell a broad alternative to MS-Excel tinkering via COM worth a look and will possibly - should money permit and the product be reasonably robust - re-implement my current set VFP-based Excel automation routines with this product in the coming months. Why? I dislike the "latency" of Excel-automation and, architecture-wise, the idea that a third-party interactive application software delivers a critical part of the functionality you offer...
Thanks
Daniel
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement