Sahi doesn't work when Sun JDBC ODBC for MS-Excel is used

sumeet

I have a script which creates some entries and the created entry gets displayed to a table in the application. And when I try to select the new entry from the table it does not find the table object and throws below error

_click(_row(_table("null"), "ND0099001")); TypeError: 'rows' is null or not an object
No trace available

I have statement in my sahi script as below -

_click(_row(_table($funcrs[$i]["Element"]), $funcrs[$i]["Value"]));

Note in above statement the "Element" and "Value" are nothing but the object and the data to find in the table, which I have kept in the Excel file

And this only happens when I use driver - "sun.jdbc.odbc.JdbcOdbcDriver"

But if I use driver - "com.hxtt.sql.excel.ExcelDriver" then it works fine.

Can someone help me to get the solution.

narayan

Sumeet,

It is surprising that the driver found $funcrs[$i]["Value"] (=ND0099001) but not $funcrs[$i]["Element"]. Do you think there could be some other mistake?

sumeet

So do you mean to say that driver is not able to pick the value correctly. As my table id is numeric identifier and it returns the null when i debug. But the other driver works with same set of data in excel, so am not sure whether its sahi problem or driver problem.

sumeet

I think its limitation of driver that it returns the null when there is numeric data available in Excel cell. Workaround is to format the excel with type as "Text".

thakurpravin

Hi Sumeet,

I am able to read/write from/To an excel file which is having several row/column data. Here is the sample of script what I used. Hope you can get some help from this.

var db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=D:/sahi/scripts/test2.xls","","");
var $rs = db.select("select * from [Sheet1$]");
var $data1 =($rs[$i]["data1"]);
var $data2 =($rs[$i]["data2"]);
var $data3 =($rs[$i]["data3"]);
var $data4 =($rs[$i]["data4"]);
var $data5 =($rs[$i]["data5"]);
//var $data6 =($rs[$i]["data6"]);
var $data7 =($rs[$i]["data7"]);
//var $data8 =($rs[$i]["data8"]);
//var $data9 =($rs[$i]["data9"]);
len=100
for(var $i=0;$i<=1;$i++)
{
_popup("12")._setValue(_textbox("eventCode"), $data1);
_popup("12")._setValue(_textbox("externalEventCode"), $data2);
_popup("12")._setValue(_textarea("eventDesc"), $data3);
_popup("12")._setValue(_textbox("billingCode"), $data4);
_popup("12")._setSelected(_select("category"), "WALLPAPER");
_popup("12")._setValue(_textbox("billingSubCode"), $data5);
_popup("12")._click(_radio("billingFlag"));
_popup("12")._click(_radio("billingEventsFlag"));
_popup("12")._setValue(_textbox("price"), $data7);
_popup("12")._setValue(_textbox("noOfUnits"),"9");
_popup("12")._setSelected(_select("eventTypeCode"), "Download");
_wait(6000);
_popup("12")._click(_button("Add"));
_wait(6000);
_debugToFile(($rs[$i]["data1"])++($rs[$i]["data2"])++($rs[$i]["data3"])++($rs[$i]["data4"])++($rs[$i]["data5"])++($rs[$i]["data6"])++($rs[$i]["data7"])++($rs[$i]["data8"]), "D:\\utpal.csv");
_alert("script is successful");

thakurpravin

sorry i forgot to check on "Never show smilies as icons for this post" option. Please conside lines as given below for the portion where smilies comes.
var $data1 =($rs[$i]["data1"]);