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.

Error while fetching the data from excel

rajathummalarajathummala Members
edited November -1 in Sahi - Open Source
Hi,

We are facing "unterminated string literal error" in log when we are trying to fetch data from excel. if we click on error line its navigate to scripting file at the line "Db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Excel Driver(*.xls)};
DBQ=C://Users//userxxx//sahi//userdata//scripts//Data.xls;readOnly=false","","");

Please help me to resolve this issue..

Thanking you inadvance..:)

Regards
Raja

Comments

  • rajathummalarajathummala Members
    Hi Sumitra/Narayan/kulakarni

    Please help me to resolve this issue.

    Regards
    Raja
  • SumitraSumitra Members
    Hi Raja,

    Kindly make sure that the following code is in a single line:
    var $Db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver = {Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ = C://Users//userxxx//sahi//userdata//scripts//Data.xls;readOnly = false", "", "");

    Check if this solves your issue.

    Regards
    Sumitra
  • rajathummalarajathummala Members
    Hi Sumitra,

    Thank you so much for your reply..

    do we have jdbc on our mechine to use this code.. please clarify us on the same.


    Thanking you inadvance..

    Regards
    Raja
  • SumitraSumitra Members
    Hi Raja,

    Sahi uses JDBC to connect to various databases. You will need to get the corresponding JDBC driver for your database and add it to Sahi’s classpath.

    On Windows, you could use the jdbc:odbc driver to access Excel. This does not need any extra jars.

    NOTE: On 64 bit windows, you need to download and install the 64 bit ODBC drivers (Download and install AccessDatabaseEngine_x64.exe)

    You can download it from here:

    http://sahi.co.in/w/working-with-excel-sheets

    Regards
    Sumitra
  • rajathummalarajathummala Members
    Hi Sumitra,

    Thanks a lot for your wonderful support..


    Regards
    Raja
This discussion has been closed.