Comments

• BG810727 Members

  November 2008

  Hi, I'm new in this forum, I'm using SAHI and need to read data from excel sheets, I'm having a problem like the one described above:
  
  This exception is thrown in the console, I'm using Excel 2007:
  
  java.sql.SQLException: [Microsoft][ODBC Excel Driver] The Microsoft Jet database
  engine could not find the object 'Hoja1'. Make sure the object exists and that
  you spell its name and the path name correctly.
  at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
  at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
  at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
  at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
  at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
  at net.sf.sahi.plugin.DBClient.getResult(DBClient.java:105)
  at net.sf.sahi.plugin.DBClient.select(DBClient.java:83)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:142)
  at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:20
  1)
  at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:84)
  
  at org.mozilla.javascript.gen.c54._c12(<cmd>:81)
  at org.mozilla.javascript.gen.c54.call(<cmd>)
  at org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:64)
  
  at org.mozilla.javascript.gen.c55._c0(<cmd>:6)
  at org.mozilla.javascript.gen.c55.call(<cmd>)
  at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:3
  37)
  at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:275
  5)
  at org.mozilla.javascript.gen.c55.call(<cmd>)
  at org.mozilla.javascript.gen.c55.exec(<cmd>)
  at org.mozilla.javascript.Context.evaluateString(Context.java:1144)
  at net.sf.sahi.rhino.ScriptRunner.run(ScriptRunner.java:94)
  at java.lang.Thread.run(Unknown Source)
• pankaj.nith Members

  November 2008 edited November 2008

  Hi Kirthan,
  
  Try using:
  _set($rs, $db.select("select * from userdata"));
  instead of :
  $rs = $db.select("select * from userdata");
  
  Another thing, although I havnt used excel datatables but I think it must work more or less the same way. I think you will have to define $rs as a 2D array like
  $rs[0]=[];
  and when you want to get a value from a particular cell you will have to address it like this:
  $rs[row number][COLUMN NAME];
  So if the name of the column in your case is say, xyz than:

  var $rs = [];
  $rs[0]=[];
  _set($rs, $db.select("select * from userdata")); 
  _setValue(_textbox("username"), $rs[0]["XYZ"]);
  

  try if this helps
  
  Regards,
  Pankaj.
• BG810727 Members

  November 2008

  Sorry, I think the Excel driver is not working properly in my machine, due if I enter "java com.hxtt.sql.excel.ExcelDriver" on the cmd I get a ClassNotFound exception.