General information
Category:
COM/DCOM and OLE Automation
Environment versions
Network:
Windows 2008 Server
Hi Gregory,
Thanks a lot for this GREAT input.
Will make the currently unoptimized import routines fly.
Most upload test cases are 3 times as fast as the original
cell-by-cell ones:)
François
PS: Thanks for the alternative contributions.
I understand you can use a lot alternative tricks to speed Excel automation up.
However I am trying to avoid tricks here, any natue Robustness is essential here.
Looking for generic upload routines that will pass the test of time and complexity.
Replacing the cell-by-cell look-up with a one download per reasonably size data
block is more than enough here...
Previous
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