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.

Read a value from an excel and type in the text box

swikrathswikrath Members
edited January 2013 in Sahi - Open Source
Hi

I am very new to Sahi and I understand that my question is very stupid . I am trying to read a value from an excel sheet to a variable and type that out on an application and perform click action. So far, my attempts inspite off reading the links one excel et al have been futile.Can any throw a sample script of how that is done please?

Many thanks

Answers

  • lonely_girl01lonely_girl01 Members 
    $readExcel = _getExcel($excelFile, $worksheetName);
$dataFromExcel = $readExcel.getData();
_setValue(_textbox("my_textbox"), $dataFromExcel[0][0]);

    Hi swikrath,

    Remember that excel data is a 2-dimensional array.
    The first index relates to the row number and the second index for the column number.
    So from my example, $dataFromExcel[0][0] is the value for the first cell in the excel (A1)
  • swikrathswikrath Members
    Hi Lonely,

    Many thanks
Sign In or Register to comment.