How to Import data from a ".xls" file to Data table
during Runtime.
Answer Posted / sreeprasad
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
I want two test two agents login for the flight website. Here is the scenario: I want to go through 1-3 rows for one user login and other user login I want to go though 3-5 rows. How would you set this up in qtp. Thank You
What are the benefits of quick test pro(qtp)?
Dis advantages of XML checkpoint ?
desribe a situation where u faced a stressful situation and how did u cope with it
How smart identification works in qtp ?
Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........
How can I use Call dlls in QTP ?
How to use actions in qtp ?
What is post recovery scenario?
What is clean sweep?
How many types of object repository in qtp?
Who uses qtp tool?
Differences between quicktest professional (qtp) and winrunner?
What is the qtp testing process?
What is expert view and keyword view?