Share
Go down
hbngoc
Posts : 3
Join date : 2013-03-02

Read value from an excel file with selenium

on Wed Apr 03, 2013 3:22 pm
I try to read value from an excel file with the source below

function readData(x,y)
{
var excel = new ActiveXObject("Excel.Application");
var excel_file = excel.Workbooks.Open("C:/Users/ADMIN/Desktop/aaa.xls");
Excel.Visible = true;
var excel_sheet = excel_file.Worksheets("aaa");
var data = excel_sheet.Cells(x,y).Value;
return data;
//return (x+y)
}
Selenium.prototype.getData=function(locator){
var strCheck = locator
var arrCheck = locator.split(',')
var numb1 = parseInt(arrCheck[0])
var numb2 = parseInt(arrCheck[1])

return readData(numb1,numb2);
}

this source write on JS file and i had import its into SELENIUM IDE; But when i run its, an error message display "var excel = new ActiveXObject("Excel.Application");" Wrong
I don't understand why is wrong, please explain for me.
Back to top
Permissions in this forum:
You cannot reply to topics in this forum