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.
parametrization for Log in page using Excel
Nagaraj
Members
Hi all,
Here is a simple log in page parametrization with excel example
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\\Documents and Settings\\Vinoth\\Desktop\\login.xls","","");
var $rs = [];
$rs[0] = [];
$rs = db.select("select * from [Sheet1$]");
var $data1 =($rs[0]["username"]);
var $data1 =($rs[0]["password"]);
var $len=4;
for(var $i=0;$i<$len;$i++)
{
_setValue(_textbox("j_username"), $rs[$i]["username"]);
_setValue(_password("j_password"), $rs[$i]["password"]);
_click(_span("Login[1]"));
}
Regards
Nagaraj
Here is a simple log in page parametrization with excel example
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\\Documents and Settings\\Vinoth\\Desktop\\login.xls","","");
var $rs = [];
$rs[0] = [];
$rs = db.select("select * from [Sheet1$]");
var $data1 =($rs[0]["username"]);
var $data1 =($rs[0]["password"]);
var $len=4;
for(var $i=0;$i<$len;$i++)
{
_setValue(_textbox("j_username"), $rs[$i]["username"]);
_setValue(_password("j_password"), $rs[$i]["password"]);
_click(_span("Login[1]"));
}
Regards
Nagaraj