How to read the xlsheet cell values
using VBSCRIPT? if any one has the code
for that please explain
u can use the following piece of code which uses createobject
Set strAppPath = CreateObject("Excel.Application")
Set strExcelWorkbook = strAppPath.ActiveWorkbook
Set strExcelsheet = strExcelWorkbook.Worksheets(wrkSheetIndex)
variable = strExcelsheet.Cells(1,1)
Set strExcelsheet = Nothing
Set strExcelWorkbook = Nothing
Set strAppPath = Nothing
You can also use the Datatable.import command while using QTP to do the same job.
I wonder whether you are unaware of this command.
Navneet Sharma http://navneetsharmasblog.blogspot.com
mrartist, I see you have another post concerning comparison in excel. I agree with Navneet. Things would be easier if you import the sheet to your runtime DT and then do the comparisons.
(I'm hiring Software Development Engineers in Test in Seattle, WA)