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
Explain how qtp identifies objects?
Difference between test object and run time object?
Please help me by providing the License key for QTP 9.2, at guru_aarya@yahoo.co.in Best Regards Gururaj.B
Is any limitation to xml checkpoints?
Hi I have exp in manual testing and planning to move in automation testing qtp(9.2).So can help me how to automate customer relationship management tool using qtp and vb script this tool already developed so how can I test it whatever maintaining by development team like documents,various options just give the whole life cycle thanks in advance
What is the basic concept of qtp?
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object.. (give a filter condition only WEbelement- not easy need to use some more property while giving filter condtions- use google for your help...))
Explain different recording modes?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?
I have qtp 9.5 demo ver,I am not able to record the yahoo broeser.so anyone can tell me what setting i have to do in QTP for yahoo brower recording. why its not recognise the object of yahoo browser????
How will you test a stapler?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
How can you exit from an action?
give me the code to save all messages of inbox of gmail into a folder and notepad