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


Please Help Members By Posting Answers For Below Questions

Connect to QC using AOM.

1232


whow much strong on VB and C?

1479


Where can I find and view run-time data table?

517


What do you to script when objects are removed from application?

609


tell me exact differenceb bw qtp and selenium?(could not tell open soure and licennce? difference in usage and technical difference?

1523






What is checkpoints for quicktest professional?

544


Define Error Pane of UFT?

686


How many types of recording modes in qtp?

582


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.

2404


How to attach a file to TD?

648


What are the five challenges you faced in QTP?

2749


What is the difference between local and shared object repository in qtp?

558


What are the technics follow in writing VB script?

1527


How to find operating system information using the qtp script?

581


What is recovery scenario in qtp?

580