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.

Sahi: datasheet

chejnesschejness Members
edited November -1 in Sahi - Open Source
Hi team,

Is there any option in Sahi to read data from excel sheets?

Regards,
Chejness.
Tagged:

Comments

  • pankaj.nithpankaj.nith Members
    Hi,

    Sahi is great with excel. Go through these:

    http://sahi.co.in/w/working-with-excel-sheets
    http://sahi.co.in/forums/viewtopic.php?id=684

    Regards,
    Pankaj
  • chetan-24chetan-24 Members
    Hello Pankaj,

    Thanks a lot!

    It's really I am able to connect with Excel and able to perform some general operations.

    Is it any way to connect with different Databases like sql, Access.

    Please guide me if its possible to connect different databases.

    Thanks with Regards,
    Chetan!
  • pankaj.nithpankaj.nith Members
    Hi Chetan,

    It is quite possible to connect to various databases using their drivers. I have used Oracle in my case and I m sure we can have a similar approach for other databases as well. You need to add the class path for the driver in your sahi.bat. Let me know if you need further details for oracle.

    Regards,
    Pankaj
  • chetan-24chetan-24 Members
    Hello Pankaj,

    Thanks a lot for replying!!

    Could you please difine procedure which you are following for oracle (i.e. adding drivers, classpath in sahi.bat etc). with one simple example, Instially i have no oracle in my machine so i will install and try with the way which you are doing or 'll try same thing with sql by replacing the drivers.

    Thanks
    Chetan!
  • narayannarayan Administrators
    Chetan,

    Also have a look at http://sahi.co.in/w/_getdb and http://sahi.co.in/w/adding-jars-to-sahis-classpath.
  • chetan-24chetan-24 Members
    Thanks a lot narayan,

    Let me start some research on it.


    Thanks
    Chetan!
  • pankaj.nithpankaj.nith Members
    Hi,

    This is the content of my sahi.bat. I have given the path for class12.jar (for oracle) 
    SET MOZ_NO_REMOTE=1
java -classpath PATH_TO_classes12.jar;../lib/sahi.jar net.sf.sahi.Proxy
    And this is my connection string: 
    var db = _getDB("oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@DB_NAME:1521:oracle", "USERNAME", "PASSWORD");

    Regards,
    Panakj
Sign In or Register to comment.