How to Iterate SAP Table and click Each Row Using Excel?

[krishnareddy (krishna)]

Hi all,
I have sap table i want to iterate each row and click the row using Excel.
How can i do that can anyone explain briefly.
the tables are differant but it looks same scenario.

thanks in advance
krishnareddy

[Palaniyappan (Palaniyappan P)]

Hi
If we are able to select the rows individually then we can use selectors where the row index of the each row in datatable variable named outdt obtained from excel using read range can be passed as input to id attribute of the selector
Like this
id = ‘ “ + rowindex.Tostring + “ ‘
Where row index will be obtained from
—for each row loop and pass the datatable obtained from excel as input
—inside the loop use a assign activity like this
rowindex = outdt.Rows.IndexOf(row)
Where rowindex is a int32 variable defined in the variable panel

Or
If we are not able to select the rows as individual elements the we can use CLICK TEXT activity where pass the row(“yourcolumnname”).ToString as input so that it will click on that text

Hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @krishnareddy

[LevKushnir]

HI

If there are some questions how to work with SAP and Excel, please check this training and you will find all answers there.

---

Completely new SAP Academy course , to help you to learn the automation techniques and the best practices for SAP WinGUI automation

---

Best regards, Lev