How to get data from excel sheet to the script? write the
script.
Answer Posted / jyothi
Set a= Createobject("Excel.Application
Set b = a.workbooks.open"D:\Keyword\Test Data\data.xls"
Set c = b.Worksheets("sheet name")
Then retrieve the data like
set x= c.cells(1,1).value
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Connect to QC using AOM.
whow much strong on VB and C?
Where can I find and view run-time data table?
What do you to script when objects are removed from application?
tell me exact differenceb bw qtp and selenium?(could not tell open soure and licennce? difference in usage and technical difference?
What is checkpoints for quicktest professional?
Define Error Pane of UFT?
How many types of recording modes in qtp?
Hi, I am working on microsoft infopath forms..It is standalone form..(not dotnet or web.) . I am not able to indentify any objects in it.. I am currently using active accessibility in the macro for the same but its execution is too slow.. Kindly help in case you have better solution.
How to attach a file to TD?
What are the five challenges you faced in QTP?
What is the difference between local and shared object repository in qtp?
What are the technics follow in writing VB script?
How to find operating system information using the qtp script?
What is recovery scenario in qtp?