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
What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?
Where you are storing your script?
descriptive program for a yahoo mail that is in yahoo mail suppose check box mailid subject assume it is like this format all things are in webtable the question is suppose some mail ids are there in that mailids i want to select the check box wich is before a@gmail.com and after that i want to click on delete button
How to use debug tools?
Hi there, I've installed a trial version of QTP to see if it works with my product but I cant automate selecting windows from a tree view? Can anyone give me any pointers? Many Thanks
what is ODC and GDC?
Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?
Difference between copy to action and call to action?
Explain about the test fusion report of quicktest professional (qtp)?
What is object spy in quicktest professional (qtp)?
How to use transactions in qtp?
What is text/text area checkpoint?
What are the ordinal identifiers in web page?
what is run action?
Approach for Installation,comaptibility,system testing