Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

Read value from an excel file with selenium

View previous topic View next topic Go down

Read value from an excel file with selenium

Post by hbngoc 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.

hbngoc

Posts : 3
Join date : 2013-03-02

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum