How to Import data from a ".xls" file to Data table during
Runtime.
- 10 Answers
- 25580 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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
Can any one tell me how to write a script for selecting open option in File menu of A word document.here you have to add objects to OR.try like that and give me the ans.i asked this question to so many but no one knows.if any one know the answer plz let me know
what is the diffrence bw qtp architectute and qtp framework?
I recorded a Web App with a Oracle backend using QTP 9.5 and for some reason the scripts don't play back> What am I missing at this point. I recorded the same Apps under Sybase and they work great. This is Oracle 10g. Why won't my scripts play back.
How to run an integrated test scenario using Multiple Actions? How to use the QTP Step Generator?
Hoe can we do retesting using functions please give the code for it using login page
By using QTP can we record any log files written by the application which is in execution?
Define Canvas view of UFT?
How to release all resources file from the QTP?
How can I open a EXCEL file from QTP Resultviewer with reporter.ReportEvent function call. Example: Test files for details click "here". And clicking "Here" in the resultviewer will open a local EXCEL FILE.
what r the main attributes of test automation?
What is the difference in the global and action sheet in qtp?
what are the issues we will get when there is migration from QTP 8.2 to QTP 10.0? Is there any problem in executing scripts of 8.2 on 10.0?
What is synchronization point in QTP?
What are the check points can be inserted without recording?
How can we use the "CreateObject("Shell.Application")" in QTP and what is the definition and purpose of it?
