How to Import data from a ".xls" file to Data table
during Runtime.
- 1 Answers
- 4892 Views
- I also Faced
- E-Mail Answers
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
Why qtp the best testing tool?
What are private functions in QTP? How they can be called from the function library?
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
How to use setroproperty?
What are the features and benefits of quick test pro (qtp 8.0)?
Hi this is chandra if any one have Navigation of LAB QTP, I want Navigation of those tools, if any one have the and know the Navigation each and every part of the QTP, plz send me my mail naruboinac@yahoo. com,naruboinas@ gmail.com
Hi friends I need to know about jubula automation tool. Is anybody know in bangalore where jubula tanning class is going on do let me know. Its urgent for me to learn that tool please help.
Explain the qtp test phases.
What are the different types of functions available in qtp and explain ?
What is different command used in command Prompt while using QTP?
Describe synchronization point.
Whats the realtime QTP testing process
How to get the particular property value?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.
What is the difference between call to existing action and copy of an action?
