How to find the last filled value's column noof the row

Help Activities
1

I need to find the last filled value’s column no in row
For eg:if the last filled row is A1 I need the output as B1

2

HI @sruthesanju

You can try using this expression

YourDataTableVar.AsEnumerable.ToList.FindLastIndex(Function (x) Not (IsNothing(x(YourColNameOrIndex)) OrElse String.IsNullOrEmpty(x(YourColNameOrIndex).toString.Trim)))

Regards
Gokul

3

It’s taking the column count .I need row count

4

Hi @sruthesanju

Dt_Variable.Rows.Count

Dt_Variable is DataTable Variable Type

Regards
Gokul

5

I am getting row count I am not able to get last filled value’s celladdress

6

Hi @sruthesanju

If DtData is my datatable, the last row and column item is at DtData.Rows(DtData.Rows.Count - 1)(DtData.Columns.Count - 1)

Regards
Gokul

7

Will I get cell address like B1 AS output

8

Yes, give a try @sruthesanju

Regards
Gokul

9

Can I get fort particular row

10

I am getting output as system .data.datrow