Comments

• Sumitra Members

  January 2012

  Hi Sandeep,
  
  Kindly have a look at http://sahi.co.in/forums/viewtopic.php?id=1599 .
  
  If you are using an old version of Sahi, could you please try with the latest version and check.
  
  Check if you are getting any error on Sahi console? If so then please post it here.
  
  Regards
  Sumitra
• Sunny Boy Members

  January 2012 edited January 2012

  Hi Sumitra,
  Thanks for your reply.
  Here i am using Sahi 4.0 pro newer version but still also i m getting the error as mentioned above..
  please find the my code below..
  
  
  
  var ExObj = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver = {Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};
  DBQ = \\Sahi Practice\\InputData\\SampleData.xls;readOnly = false", "", "");
  
  
  
  $strGetVal = ExObj.select("select* from [Sheet1$]");
  
  _assertEqual("10",parseInt($strGetVal[0]["First Number"]));
  
  _assertEqual("20",parseInt($strGetVal[1]["Second Number"]));
  
  _assertEqual("Add",$strGetVal[2]["Action"]);
  
  _assertEqual("30",parseInt($strGetVal[3]["Total"]));
  
  
  
  Error Which i got is
  Starting script
  ERROR [110 ms]
  unterminated string literal
  Stopping script
  
  
  please help me out..
  
  Regards,
  Sndeep S S
• Sumitra Members

  January 2012

  Hi Sandeep,
  
  Kindly make sure that the below line in the script is in a single line.
  

  var ExObj = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver = {Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ = D:\\Sahi Practice\\InputData\\SampleData.xls;readOnly = false", "", "");
  

  
  Also, the other part of code should be:
  

  $strGetVal = ExObj.select("select* from [Sheet1$]");
  _assertEqual(10, parseInt($strGetVal[0]["First Number"]));
  _assertEqual(20, parseInt($strGetVal[1]["Second Number"]));
  _assertEqual("Add", $strGetVal[2]["Action"]);
  _assertEqual(30, parseInt($strGetVal[3]["Total"]));
  

  
  Check if this solves your issue.
  
  Regards
  Sumitra
• Sunny Boy Members

  January 2012

  Hi Sumitra,
  
  the code is in singale line and now This time i got below error ..
  
  
  exception: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at net.sf.sahi.plugin.DBClient.getResult(DBClient.java:100) at net.sf.sahi.plugin.DBClient.select(DBClient.java:79) 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:161) at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:247) at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:3330) at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:2487) at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:164) at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:398) at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3065) at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:175) at org.mozilla.javascript.Context.evaluateString(Context.java:1104) at net.sf.sahi.rhino.RhinoScriptRunner.run(RhinoScriptRunner.java:144) at java.lang.Thread.run(Unknown Source)
  
  
  Regards,
  Sandeep S S
• Sumitra Members

  January 2012

  Hi Sandeep,
  
  Kindly have a look at :
  
  http://sahi.co.in/forums/viewtopic.php?id=3159
  
  http://sahi.co.in/forums/viewtopic.php?id=1840
  
  Regards
  Sumitra
• Sunny Boy Members

  January 2012 edited January 2012

  Hi Sumitra,
  
  I have done the Changes as per above links and its working fine now... Thanks a lot..
  
  can you please let me know is what is the method to count the number of rows in Excel sheet i used below menthod but i m getting error as
  
  Method
  var $sRowCount = ExObj.select("select count(*) from [Sheet1$]");
  
  Error
  "recursive_access"
  
  Please let me know the method..
  
  Thanks in Advance.
  
  Regards,
  Sandeep S S
• Sumitra Members

  January 2012

  Hi Sunny,
  
  Could you try using this:
  
  var $sRowCount = "" + $ExObj.select("select count(*) from [Sheet1$]");
  
  Check if this solves your issue.
  
  Regards
  Sumitra
• Sunny Boy Members

  January 2012

  Hi Sumitra,
  
  Thanks a ton for your support that line of code works for me...
  only some change i did is..
  
  var $sRowCount = "" + $ExObj.select("select count(*) from [Sheet1$]");
  
  it should be like
  var $sRowCount = "" + ExObj.select("select count(*) from [Sheet1$]");
  
  
  Really Hats off to you and your team.....
  
  Regards,
  Sandeep S S