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 want to capture data(using keyword) from msdos application using QTP?... Below is little work i could do on it... /* Set app=CreateObject("Wscript.shell") SystemUtil.run ("C:\Users\Agent\Desktop\pumpsim\PUMPSIM.EXE") Window(“PUMPSIM.EXE”).Activate wait(3) app.sendkeys "N" */ Thanks in advance...!!!
How you create new action in qtp?
HOw to add the recovery file at runtime to the test file .
How can you handle exceptions in qtp?
What is checkpoints for quicktest professional (qtp)?
Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...
Hi,Sudhanandareddy plz forword framework and ppts for QTP to me. This is my mail id: ranjith_99reddy@yahoo.co.in (your contact number also)
how to write xml output check point bu useing descriptive programing .means without useing output check point
Explain the views in the QTP GUI?
You will receive the mail in your outlook from client at night time to go ahead for the execution. Based on the mail you need to trigger the batch run. What is the QTP Code for this?
What are the different types of recovery operation?
How to export quicktest professional results to an .xls file?
Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?
How does you test a weblink which is changing dynamically?
What is quick test pro? What is a quick test professional?