How to Import data from a ".xls" file to Data table during
Runtime.
Answer Posted / chinna
Hi,
Datatable.Importsheet("Path of the sheet",Source sheetid,
Destination sheetid)
Ex.Datatable.importsheet("C:\Book1.xls",1,1)
z=datatable.getrowcount
For i = 1 to z
datatable.setcurrentrow(i)
A=datatable.value(1,1)
b=datatable.value(2,1)
c=a+b
datatable(3,1)=c
Next
msgbox c
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
if numbers are always changing write a script for that
Explain the new feature of UFT regarding the export of test results?
What is the difference between local and shared object repository in qtp?
Functions call by reference and call by value. i want the diff b/n these 2 and how will be the script for this?in which situation we use these 2..?pls explain me clearly
What is output value? How many types of output values are there in qtp?
How will you compare keyword and expert view?
Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?
How can I import environment from a file on disk?
how we connect 1. qtp9.2 to the quality center9.0? 2. Load runner8.0 to the quality center9.0
What are the technics follow in writing VB script?
How to create runtime property for an object?
what are the critical test cases in crm? tell me atleast 5 critical test cases? what are the critical bug u find out while testing crm domain?
What is an expert view and keyword view?
What do you to script when objects are removed from application?