Reading column with dynamic name and dynamic in Excel position

Help Activities
, , ,
1

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.

EG.
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.

2

@Yugal_Raju

You can get the week of the month

Check below for your reference

Hope this will help you

Thanks

3

Hi

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