How to Import data from a ".xls" file to Data table during
Runtime.
Answer Posted / deeps
Hi,
DataTable.Import("path of the file")
DataTable.ImportSheet("filepath","sheetsource","sheetDest")
Sheetsource:index or name of the sheet in the file which u
want to import. index begins vth 1.
SheetDest: index or name of the sheet in the datatable
which u want to replace vth Sheetsource.Index begins vth 1.
ex:
Datatable.importsheet("c:\name.xls",1,"name")
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
How to recognise the webelement and verifying that webelement is enabled?
what is run-time data?
How to release all resources file from the QTP?
How you can make an action as re-usable action?
What is the parameterization? Give one example?
can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process
Describe the differences between functions and actions in UFT?
1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?
Did the scripts need lot of maintenance? If yes, why?
How you will rate urself in QTP in the range of 0 to 5
If I give some thousand tests to execute in two days what do you do?
What is the use of text output value in quicktest professional (qtp)?
What is the default object synchronization timeout in qtp?
In Remote acess server how u run a test?