Get the value to handle in excel and than move to next unused value


Anyone that can help me with this?

I have two columns and several rows, I need to get the value of row 1 to handle and next time get the second row and so on. I need to add the former row to “old” somehow to know that is is already used… Anyone with idea how to do so?

Hi @Didem,

You can use DataRow variable to store the previous row and just use if condition for skip the first iteration.

first read excel as datatable dt.
inside foreachrow loop and initialze in dex variable in foreachrow properties
get row values to handle
{add data row(in row properties you will pass dt.rows(index-1))(and in datatable you will pass another datatable to keep record of used row)
}add data row(dt.rows.count-1) to used record datatable for the last row of table.

cheers mate…

1 Like

Do you have any example?

example how to set it up?

Hi @Didem,

As @AkshaySingh said, we can use index variable to done this. I have attached the sample workflow.

ExcelColumn.xaml (8.5 KB)
Book1.xlsx (8.5 KB)

Thanks a lot :slight_smile:

1 Like