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
I am getting the "test object property" Description properties "toolkit class" value By using "gettoproperty" in run time But my problem is how to get Ordinal Identyfier's type and value Type is index, value is 0 How can i keep this values in to required place How can i get these values in runtime I have to insert these "index" and "value" into another area Is there any script for this like "gettoproperties","Getroproperties" If anybody knows,please help me .
How smart identification works in qtp ?
How does quicktest professional (qtp) identifies the object in the application?
Explain different types of checkpoints?
How can you close the second opened browser?
Which recording modes need more memory?
What are the views available in quicktest professional?
what is the advantages and disadvantages of using functions instead of re usable actions
How can i test an application like Google Earth.In my application data will be fetched from a oracle database based upon which graphs are generated..so these all are dynamic..how can i use qtp here..alongwith that how can i test the map generated by a satellite just like google earth..
Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?
what is meant by function library?Public and private functions in function library? if private functions are applicable for only for the particular test means then y we have to add those to function library?
How to find the path of folder in which the test is saved in qtp?
What is QTP’s model for test creation?
what is key word driven frame work ? why it is called like that ? what is the diference between keyword driven and data driven frame work ?
how do u plan test automation?