Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Who has used xlsgen as a replacement Excel COM?
Message
De
26/01/2015 16:42:56
 
 
À
26/01/2015 14:43:20
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01614068
Message ID:
01614347
Vues:
55
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
Fil
Voir

Click here to load this message in the networking platform