General information
Category:
Third party products
Environment versions
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only