Selenium Forum: Functional And Regression Testing Tool.
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Search
Display results as :
Advanced Search
Latest topics
AEM Training | Free Online DemoWed Apr 21, 2021 5:45 pmazharuddin
c# PageFactory - issue initializing elementsFri Nov 01, 2019 8:40 pmthegoatboy
Selenium making automatic connection to random urlsMon Jul 08, 2019 12:58 pmrepairtechsolutions1
How can we design the custom framework in Selenium RCMon Jun 24, 2019 2:26 pmrandybonnettes
What are the new features in Selenium 3.0Tue Jun 18, 2019 5:37 pmpappyvicky
What are you using Selenium for? Fri Apr 12, 2019 3:52 amzhl
LIMITATIONS OF SELENIUMWed Apr 10, 2019 11:23 amswara
Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

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

Read value from an excel file with selenium Empty Read value from an excel file with selenium

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