I am using QTP 9.5 on XP service pack 3. I am loading external file using datatable.importsheet method.
QTP is taking long time(15 mins.) to load the data table in to global sheet.
Please post what is reason for this and solution for the same.
Appreciated earliest reply.
Are you sure this what you have tried???
Datatable.ImportSheet "C:\Documents and Settings\testking\Desktop\abc.xls",1,1
Are you sure that your internal server is not slow
How many data you are importing, I mean how may rows of data you are importing.
The issue what you have listed does not exist, works fine in my machine- stupid comment from the developer
Yes, exactly I am following the same as mentioned in your post.
The file contains 20 rows and 15 sheets.
I appreciate earliest reply.
No one replying back. I appreciate any replies on this.
Thanks & Regards
yes, you need an expert advise here because so far I didn't face this issue. I hope what I have mentioned will be the reply from newbies like me.
try this.. maybe it works... copy the contents of all the sheets (yes contents and not the sheet) to a new excel file. Save this new file. Import the required sheet from this new file and check the performance.