I would like to know the row number of Currentrow in for Each Row in Data table.
This activity uses Excel scope, Read Range, and For Each Row in Data Table.
and
Uses IF Activity and get row items together
What to do if there are no specific characters in the A-th column of that row. If there are specific characters, do nothing and move to the next current row.
If there is no a specific character, it obtains the corresponding row number at the end of the task and enters a specific character in the Excel cell.
So I need to know the rowcount of the current row, but I don’t know the expression.
For example, for a data table
dt.Rowcount.Tostring
i can import Row numbers
but What should I do with the currentrow?