How to retrieve the last cell of a coulmn where each coulmn in the excel have different length

Help IT Automation
1

Hi Team, I am trying to retrieve the last cell of a coulmn and in my excel sheet I have different lengths of coulmn… so I am not able to use the row count formula to get to the last cell of a specific column. Any help will be much appreciated.

2

Use Balareva EasyExcelActivities. Get last column and Get last row, use that to get the cell value.

3

Thanks Matt, I have seen that. but my requirement is to get to the last cell of a coulmn in a sheet where the number of rows in each coulmn is different. The code by Balareval takes the idex to the last row of the sheet where the length of the coulmn is maximum.

4

@mithun.infotech
Lets assume the excel is read in into a datatable.

Find some demo on:
datatable - input:
[Column1,Column2,Column3
#A1,1,#C1
#A2,#C2
#A3,
,
]

creating following output:

ColumnIndex RowIndex ExcelRange Value
0 2 A2 #A3
1 0 B3 1
2 1 C4 #C2

find demo xaml here:
GetLastValueIndex_AllCols.xaml (10.8 KB)

ensure following dependency is set:
grafik