- hbngoc
- Posts : 3
Join date : 2013-03-02
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.
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.
- how to read excel file in rc using java program?
- Trying to read from excel file with JUnit but get error message "The constructor SpreadsheetData(InputStream) refers to the missing type InvalidFormatException"
- Is it possible to write/read values from a .txt file using Selenium IDE?
- Selenium RC with NUnit throwing error - File does not exist. File 'c:\Projects\WebDriver\trunk\src\Selenium.Core\HttpCommandProcessor.cs'
- How to genenrate excel file for test pass/fail
Permissions in this forum:
You cannot reply to topics in this forum