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
Call to copy of an action and call to existing action… i know the diff but in real project how to use..? i want live scenario.pls help me..
What is the differences between image check point and bit map check point?
What is the difference between the keyword view and expert view?
How to start recording using quicktest professional (qtp)?
wht type of User defined functions or Java Releated functions do we write in VB scripting
what is keyword driven testing in qtp?n how is it useful?
How to import a test case present in ".xls" file to TD under a Test set?
When to use descriptive programming?
What are private functions in QTP? How they can be called from the function library?
How many types of recording facility are available in quicktest professional (qtp)?
how do i know how to use tools
Can we create a qtp test from qc?
What is the difference between shared and local object repository?
Why do we use breakpoints in QTP?
Can any one say what exact diff between test->parameters, action properties-> parameters. after defining the parameters in test->settings, how can we access those parameters.(i know how to use action prop parameters)