QTP and Excel - Performance

[Vandembergue]

Hi Folks,

I have built an automatical test with QTP that retrieves values in a excel file (on one line), checks those values in a web application and reports the results (OK/KO) into the processed excel line. The excel file is processed line by line.

I can see how fast the programm is running by observing how fast the excel line are fulfilled from top to bottom.

The strange thing is that i've observed that when as I was clicking the horizontal scroll bar of the excel window and maintaining the click on it (not releasing the left button), QTP would update the Excel file twice as fast (at least).

Am I clear ?

Is there anybody who could explain me why clicking on the scroll bar makes QTP perform better ? Do you have any idea of how I could improve my program so that it runs as fast as if I was clicking the Excel window ? If turn my excel application to Set ...Visible=No, would it change something ?

Notes :

- in QTP script my excel file is opened that way :
-----------------------------------------------

Code:

Nom_Xls = "C:\...\TESTS QTP\INPUT\Extract_OpenCat_Offres.xls"
Set ObjExcel = CreateObject("Excel.Application")
Set Classeur = ObjExcel.WorkBooks.open (Nom_Xls)
Set Onglet = Classeur.Worksheets("Extraction")
ObjExcel.Visible = TRUE

- The QTP script is launched by a vbs file :
-----------------------------------------

Code:

qtApp.Launch
qtApp.Visible = True
qtApp.Options.Run.RunMode = "Fast"
qtApp.Options.Run.ViewResults = True
qtApp.Open Test_path, True
Set qtTest = qtApp.Tt
qtTest.Run ' Run the test

[Saket]

I have never seen such behavior of QTP, but I would like to see, can you explain more what exactly is being done in your excel file. if possible please attach a sample excel file/screenshot for better idea.

[Vandembergue]

Hi Saket,

Thanks for trying. I'll give you a sample of the excel processed file and a copy of the main QTP script.
The Excel file usually contains about 40.000 lines. The script is launch by a .vbs programm. In fact, it is launched about a hundred times because I had to stop and restart QTP frequently to avoid memory problems. Each time it runs, the script opens the excel file, restarts at the line where it stopped and processes the next lines before saving the excel file and stopping again.

If you have any question about the script, please ask.

I'm using Windows XP Professional 2002 SP2 + IE6

[Saket]

Hi Vandembergue,
I tried this and found you are right, thanks for letting us know this interesting behavior .
Not 100% sure but what I think is, in slow mode QTP uses more resources and excute step by step depending on the response from excel. when we click on excel window title/scroll bars, Windows response time increases, however when we dont click it, the response time from excel is bit lesser.
Running script in fast mode should solve your issue.

[Vandembergue]

Hi,

The problem is that I'm already using the Fast mode. I'll go on trying and will let you know if I ever find something interesting.
However, thank you for answering so quickly and for wasting time on those problems of mine.

++