Find the last empty column in an excel

Learn
1

Hi There,

I have a excel file. I have write values in the last column after running a process.
image

How to find the last empty column Here the last column for today is ZJ. for tomorrow ZK and so on. Please help anyone.

Thank you in advance.

2

Hi,

How about ReadRange Activity or Read Row activity?

We can get number of columns using dataTableVar.Columns.Count() with ReadRange activity.

Or We can also get number of items in a specific row using enumObj.Count() with ReadRow activity.

Then we can calculate address from the above value.

Regards,

1 Like
3

I solved the problem. I created and string array {“A”,“B”}. Read the first column row. and looped through the column till I don’t find any value and assigned the counter variable and with counter variable I got the column value which is empty. My column row contails Date value. I check the row contains “/”.

1 Like