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

#1

Hi,

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?

#2

Hi @Didem,

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

#3

hi,
first read excel as datatable dt.
inside foreachrow loop and initialze in dex variable in foreachrow properties
{
get row values to handle
if(index<>0)
{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
#4

Do you have any example?

#5

example how to set it up?

#6

Hi @Didem,

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

Cheers:slightly_smiling_face:!!!
ExcelColumn.xaml (8.5 KB)
Book1.xlsx (8.5 KB)

#7

Thanks a lot :slight_smile:

1 Like