How to import the Test Results in QTP to an Excel sheet
Answers were Sorted based on User's Feedback
Answer / mahi
if we want import complete sheet then go for
Datatable.Export "path of the excel file"
if we want import a perticular sheet then go for,
Datatable.ExportSheet "path of the excell file",SheetId to be exported
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sudeepthz
could you explain with an example.. that would be greatful to me
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / venkat reddy
we can import testresults to excel sheet by using datatable
methods
Ex:-datatable.exportsheet "path where you want to
save.xls",sheetid
if i am wrong please correct me...
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / ravindra
DataTable.ExportSheet Relativepath &"path of that
excelsheet","Sheetname"
| Is This Answer Correct ? | 0 Yes | 5 No |
I am Using QTP 9.1 version. I have created a Shared Object Repository. The size of Shared Object REpository is 9 MB. In my system i am able to execute the script very flexibly and it is very fast. But if i copy the same code into other system with the same configuration, it is executing very slowly(i.e dam slow). It is not happening in all machines it is in only some machines. Can please any one give th esolution. It is high priority to me as i need to give demo to client on their machines.
How did you resolve conflicts present in Object Repository?
How you are developing the script? Using record and play back or manual?
In QTP how to interact tool and application build?
how to pass parameters from one action to another using output parameters I am not calling action 2 from action 1, they are being called individually I need syntax please .. Requirement: Action 1 customer = Browser(" ").Page(" ").Link(" ").GetROProperty("value") I want to use the value stored in customer in Action 2 I do not want to use any of these actions as re-usable actions
What is Modular framework and Keyword drive framework? Explain
i have an array CAPGEMINI .....Here i need to check whether G is there or not ..how to do that and friends i have one big doubt that is whether it is array or string ,how we come to know that and where we consider that it's array ,where we consider that it's an string because when i want to find the length i have big doubt whether we need to use len function or ubound ... ans me for this TWO Questions any one please
Write test cases for copy and past password in password field ?
Is it possible to change the values of analog recording?
7. Given scenario is like this: One Web table is there and you have to search and retrieve a cell data which is equal to the given number say:123. Assume you have given with the column name/id of the table where the number may exist. So now you have to go to the given column and search for the number 123 and retrieve it along with the row number of it.
How do u write script in qtp? where do u write?
What's Checkpoints for QTP?