How to get Row Number

Help Studio
, ,
3

Hi @Relangi_Siva
By using rowindex function you can get the row number

Ex: index = row.rowindex

  1. First, use the Read Range activity to read the data from your Excel file into a DataTable variable.
  2. Next, use a For Each Row activity to loop through the rows in the DataTable. Inside the loop, use a Condition activity to check if the value of the cell in the current row matches the text you are looking for.
  3. If the condition is met, use the RowIndex property of the current row to get the row number. You can store the row number in a variable and use it later in your workflow.