18 January 2026:


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.

excel issue

edited November -1 in Sahi - Open Source
Access database engine is downloading in my system it is showing some error......

AccessDatabaseEngine_x64


script:--

function contact_info($name,$emailid,$cellphone,$landline)
{
_setValue(_textbox("name[1]"), $name);
_setValue(_textbox("email"), $emailid);
_setValue(_textbox("cellno"), $cellphone);
_setValue(_textbox("landline"), $landline);
_setValue(_textbox("address-first"),"1627");
_setValue(_textbox("address-second"), "rama");
_setValue(_textbox("address-landmark"), "central");
_setValue(_textbox("address-area"), "bangalore");
_click(_checkbox("asap"));
_setValue(_textbox("date"), "2012-03-24");
_click(_listItem("Bring me food as soon as possible"));
_click(_listItem("Bring me food as soon as possible"));
_click(_checkbox("asap"));
_setSelected(_select("hours"), "9");
_setSelected(_select("ampm"), "PM");
_setValue(_textarea("instructions"), "bring the food soon");
_click(_button("Send This Order"));
_click(_checkbox("1"));
_click(_button("Send"));
_click(_link("Close[1]"));
}
try
{
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\Documents and Settings\jetech\Desktop\\sandhi.xlsx;readOnly=false", "", "");
$$arr1 = db.select("select * from [Sheet1$]");
for(var $i=0;$i<$arr1.length;$i++){
contact_info($arr1[$i]["name[1]"], $arr1[$i]["email"], $arr1[$i]["Cellno"], $arr1[$i]["landline"]);
_wait(15000,_exists(element));
}
catch(e)
{
_logException(e);
}
Sign In or Register to comment.