Determine the last filled column

Help Studio
,
1

Hello friends! I need your help, the fact is that the robot needs to go through all the columns, starting with “1” and determine the last column with data, and not those that are empty (data
data columns may change too).
I thought to go through a For Each loop through the ReadRow activity and filter each column for the presence of data,
but I cannot determine the last one filled.
For example, here I need to define a column “5” with its data

image

Can you help with this, please? Sorry for my english

2

Hi @asiljan.7

I had used a sample excel file like this

image
image1004×191 3.89 KB

For to find the last filled column starting with 1

Main.xaml (16.1 KB)
I had developed this workflow

Check this

Regards,
Nived N

3

Hi thanks for the answer, but I am getting the error here

Assign: An object reference does not point to an instance of an object.

image

4

Did u tried same as I did in my workflow?

5

Yes, did the same

6

But @asiljan.7
It is working fine for my case