Hello Everyone,
I would like to use select, to find first empty row.
How can I do it?
Is it possible to find first empty cell in specific column?
E.g I would like to find first empty cell in ‘ColumnA’ (it is 20 row) but in next ‘Columnb’ is not empty. I would like to select ‘ColumnA’
HI @aleksandra.plichta5
Can you elaborate your task what are you trying to do after selecting the empty line
Regards
Sudharsan
Hi @Sudharsan_Ka
In ‘ColumnA’ I have specific dates.
I have to find first empty to put there my date.
Anil_G
(Anil Gorthi)
February 13, 2023, 7:52am
4
@aleksandra.plichta5
You can select
Dt.Rows.IndexOf(Dt.AsEnumerable.Where(function(x) IsNothing(x(0)) OrElse String.IsNullOrEmpty(x(0).ToString.Trim))(0))
Thus basically check First column you can change 0 to anothwr column index or column name as needed
Cheers
@aleksandra.plichta5
You can try with Find First/Last Data Row activity in the modern design
To enable it
Go to → Activities Panel → Click on Filter → Select Show Modern.
@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.
Regards
Sudharsan