StudioX - Find Last data row in excel file

Help
,
8

@ayyagari.sudhakar - I was able to achieve it with out using Find Last Row/Column.

Here is the xaml. FindLastRow_20.4.zip (647.3 KB)

Idea is simple: I wrote the excel formula on the cell as: =LOOKUP(2,1/(B:B<>“”),ROW(B:B))

This will give the last row count. Then i added +1 and saved it to a variable.

Finally wrote the output text using the variable ex: B34.

Please test this and let me know.

2 Likes