18 January 2026:
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
Accessing data through excel have problems
Hi all
I am trying to access data from excel and want to put in application . i am getting error message
_setValue(_textbox("txtLogin", undefined);
_setValue(_textbox("txtLogin", undefined);
I have downloaded excel drivers with name Excel_JDBC30.jar and my sahi.bat file is
>
SET EXT_CLASS_PATH=C:\sahi\lib\Excel_JDBC30.jar
#SET EXT_CLASS_PATH=%EXT_CLASS_PATH%;..\extlib\db\mysql-connector-java-5.0.4-bin.jar
SET SAHI_CLASS_PATH=..\lib\sahi.jar;..\lib\Excel_JDBC30.jar;..\extlib\rhino\js.jar;..\extlib\apc\commons-codec-1.3.jar
SET MOZ_NO_REMOTE=1
java -classpath %EXT_CLASS_PATH%;%SAHI_CLASS_PATH% net.sf.sahi.Proxy
my script file for excel is
>
var $drvr = "sun.jdbc.odbc.JdbcOdbcDriver";
var $dt = "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\\data.xls";
var $db = _getDB($drvr,$dt, "", "");
var $rs = [];
$rs = $db.select("select * from [Sheet1$]");
_setValue(_textbox("txtLogin", $rs[0]["A"]);
And my script file to access from MSAcess database is
>
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/db1.mdb","","");
var $rs = null;
_set($rs, db.select("select username from table"));
_setValue(_textbox("txtLogin"), rs);
Waiting for early reply
Regards
Jaspreet
I am trying to access data from excel and want to put in application . i am getting error message
_setValue(_textbox("txtLogin", undefined);
_setValue(_textbox("txtLogin", undefined);
I have downloaded excel drivers with name Excel_JDBC30.jar and my sahi.bat file is
>
SET EXT_CLASS_PATH=C:\sahi\lib\Excel_JDBC30.jar
#SET EXT_CLASS_PATH=%EXT_CLASS_PATH%;..\extlib\db\mysql-connector-java-5.0.4-bin.jar
SET SAHI_CLASS_PATH=..\lib\sahi.jar;..\lib\Excel_JDBC30.jar;..\extlib\rhino\js.jar;..\extlib\apc\commons-codec-1.3.jar
SET MOZ_NO_REMOTE=1
java -classpath %EXT_CLASS_PATH%;%SAHI_CLASS_PATH% net.sf.sahi.Proxy
my script file for excel is
>
var $drvr = "sun.jdbc.odbc.JdbcOdbcDriver";
var $dt = "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\\data.xls";
var $db = _getDB($drvr,$dt, "", "");
var $rs = [];
$rs = $db.select("select * from [Sheet1$]");
_setValue(_textbox("txtLogin", $rs[0]["A"]);
And my script file to access from MSAcess database is
>
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/db1.mdb","","");
var $rs = null;
_set($rs, db.select("select username from table"));
_setValue(_textbox("txtLogin"), rs);
Waiting for early reply
Regards
Jaspreet