Originally Posted by
raghav.kamal
Hi,
Check the below example for validating data in excel where we did in our project
dim excelobj,counter
counter = 1
set excelobj = createobject("excel.application")
set wbo = excelobj.workbooks.open("c:\kpi japan jhq combine report")
set wbs = excelobj.activeworkbook.worksheets("kpi japan jhq combine report")
if excelobj.cells(1,1)="kpi japan jhq combine report" then
reporter.reportevent 0,"hq cumulative report validation","hq cumulative report validation success"
else r
eporter.reportevent 1,"hq cumulative report validation","hq cumulative report validation fail"
end if
if excelobj.cells(3,4)="yesterday's" then
reporter.reportevent 0,"excel sheet data validation","excel sheet data validation success"
else
reporter.reportevent 1,"excel sheet data validation","excel sheet data validation fail"
end if