How to retrieve data from excel sheet and export in browser Fire fox

gunjan

hi,
can u plz help me
How to retrieve data from excel sheet and export in browser Fire fox
my excel sheet data is given below

Firstname Lastname DaytimePhoneP1 DaytimePhoneP2 Email Year Make


Model Color

Year, make model and color drop down values are selected
Year= 2001,2002 etc
Make=Audi,BMW etc
Model= A4, 3 series etc
Color=blue,Black etc
DaytimePhoneP1 consider only 3 digits
DaytimePhoneP2 consider 7 digits

Can u plz tell me what the script should i write for above situation
My os windows 7, Sahi V3.5, Browser Fire fox Version 5.0



Thanks,
Gunjan

Theeran

Hi gunjan,

Please,Post the forum in the single Thread.

Try the following script,

function contactInfo($fname,$lname,$daytimephone1,$daytimephone2,$email,$year,$make,$model,$color)
{

_setValue(_textbox("FirstName"), $fname);
_setValue(_textbox("LastName"), $lname);
_setValue(_textbox("idCellPhone1"), $daytimephone1);
_setValue(_textbox("idCellPhone2"), $daytimephone2);
_setValue(_textbox("idMail"), $email);
_setSelected(_select("YearID"), $year);
_setSelected(_select("MakeID"), $make);
_setSelected(_select("ModelID"), $model);
_setSelected(_select("idcolors"), $color);
}

// Get the DB instance
var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:\\Documents and Settings\\Sumitra\\Desktop\\Book3.xlsx;readOnly=false", "", "");
$rs = db.select("select * from [Sheet1$]");
contactInfo($rs[1]["FirstName"], $rs[1]["LastName"], $rs[1]["idCellPhone1"], $rs[1]["idCellPhone2"], $rs[1]["idMail"], 
""+parseInt($rs[1]["YearID"]), $rs[1]["MakeID"],$rs[1]["ModelID"],$rs[1]["idcolors"]);

change the row index appropriately to fetch the required data.

let us know if the problem persists.

Regards
Theeran.