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.

Excel V/s SAHI

rohit.roorkeerohit.roorkee Members
edited November -1 in Sahi - Open Source
Hi Narayana,

Is SAHI able to read the test data from the Excel.

Problem is, Say I am having 5 different environments running (5 different URL's) having different Username & Password. this is a test data and I am having this on Excel or any other text editor.

Does SAHI provide the functionality to visit the excel and take the test data from there & provide the same to the browser. For login to the application. Please respond ASAP.

Regards,
-Rohit.

Comments

  • Hi Rohit,

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

    Regards,
    Pankaj.
  • Hi Narayana,

    I am not able to click on Image Button through script.
    The script is as follows :

    function Demo_IRCTC($userName, $password)
    {
    _setValue(_textbox("q"), "irctc");
    _click(_submit("Google Search"));
    _click(_link("IRCTC Online Passenger Reservation Site."));
    _setValue(_textbox("userName"), $userName);
    _setValue(_password("password"), $password);
    _click(_submit("Login"));
    _click(_image(3));
    _click(_link("Log Out"))
    }

    Demo_IRCTC("xyz", "abc");

    Please help me to resolve the issue.

    Regards,
    Shatrughan
  • Hi Narayana,

    Can Sahi connect with CSV file or any dabases like MS Access 2007 & Sql server 2000.
    If yes, then how can we do it.

    Please respond.

    Regards,
    Shatrughan
  • Hi,

    To connect to a database you can use _getDB
    see:
    http://sahi.co.in/w/_getdb
    and for using excel:
    http://sahi.co.in/w/working-with-excel-sheets

    Regards,
    Pankaj
  • Hi Pankaj,

    Please let me know how i make connection with MS Access 2007 & Sql server 2000.
    Please repond ASAP.

    Regards,
    Shatrughan
  • narayannarayan Administrators
    Shatrughan,

    I tested your script and it works fine for me on firefox 3 and IE 7.
    Are you using something else?

    Please start a different topic if the issues are not related. It helps both people who answer and people who look for information.

    Regards,
    Narayan
  • Hi Narayana,

    I have successfully read the data from MSAccess 2003 but same script is not working with MSAccess 2007.
    What changes i have to make so that it work with MSAccess 2007.

    Please help me.

    Thanks & Regards,
    Shatrughan
Sign In or Register to comment.