Information générale
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Network:
Windows Server 2012
Virtual environment:
Hyper-V
He could deploy a virtualbox with Prof on the server, but that would be overkill unless other WS tasks need to run there ;-)
>The total data is 800 rows. I've done another test on my pc with an export for 500 rows and got the same behaviour so not a server function.
>The customer in question has a network with server 2012 and zero clients so no choice but to run excel on server environment.
>
>~M
>
>>No clear indication on the amount of data you transfer, but as soon as 2 dozen rows are exceed, it is usually better to
>>pipe he data to a xls or csv file and
>>read that file in Excel
>>do small modifications / special row handling via Excel macro using perhaps 2 sheets.
>>
>>unless you are able to transfer the whole sorted cursor via clipboard
>>
>>If you HAVE to use automation, create vfp local variables of repeated elements on the right of Excel object access path to speed up processing
>>
>>>Hi all,
>>>I have a program that export date to excel, I use OLE automation. It does a select and a sort then open's excel and starts to populat the sheet. It's simple and just for 1 customer. I had to add a column to the report and when testing I noticed that it ran very slowely, 1 row per second (no calculation or formatting done when running), but I put this down to the server. I then clicked on the scroll bar and the program sped up, doing 4-5 rows per second. I am able to reproduce the behaviour, and would love to be able to have that speed in normal operation, but no idea why this is happening or how to achieve it in the normal running of the program, any idea?
>>>~M
Précédent
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