Reading column with dynamic name and dynamic in Excel position

Hello all,

I’m want to filter a condition for a column which is dynamic.

The bot runs weekly so when the excel is exported new latest column is added to the sheet.

1st week run:
week 1 , week 2, week 3

Need to read week 3’s data.

2nd week run:

Week 1 , week 2 , week 3,week 4

Need to read week 4’s data

And so on.

I hope I’ve explained it well enough.
Kindly please help.


You can get the week of the month

Check below for your reference

Hope this will help you



First read the excel file using READ RANGE activity and get the output as dt

Now use a assign activity like this to know the number of columns you have

int_columncount = dt.Columns.Count

Now use a for each row activity and pass dt as input and inside the loop use a assign activity like this to read the last newly added column

str_value = CurrentRow(int_columncount-1).ToString

Cheers @Yugal_Raju