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.

reterive data from _cell("16200.0000 USD")

sudhirguptasudhirgupta Members
edited November -1 in Sahi - Open Source
Hi,
I am facing a problem.
I want to get data from cell itself as while recognizing through controller its showing " _cell("16200.0000 USD") " As i cannot use this element in my excel file for testing because the data in cell will keep changing.
I am interested in data under cell that is "16200.0000", if m using
_getText(_cell("16200.0000 USD") ) under controller , its givin me " 16200 " which is perfectly ok with me.
But i cannot use _cell("16200.0000 USD") in my .xls file as data will change next time.

Jst above this cell there is a another column named as "_tableHeader("Available") " and my cell is coming jst under this tableheader section.

please suggest me somthing.

Comments

  • narayannarayan Administrators
    If it is a table, use this API

    _cell(_table("tableId"), "text of some cell in that row", "text of some cell in that column");

    In your case, you may be able to use something like

    _cell(_table("tableId"), "Amount Paid", "Available");

    Regards,
    Narayan
  • sudhirguptasudhirgupta Members
    Hi narayan,
    I am not able to see any tableId through sahi controller, its giving me only tableHeader section for all columns and under that columns its givng _cell("xyz).
    Moreover i cannot use " _cell(_table("tableId"), "Amount Paid", "Available"); ", as Amount Paid will keep changing according. Its not a static data over there.

    Regads
    Sudhir
  • sudhirguptasudhirgupta Members
    Hi naryan,

    Its working fine.
    I am using row ,column no in cell and its working good

    _getText(_cell(_table(8), 1,4))


    Thanks
    Sudhir
This discussion has been closed.