How to find the last filled value cell address

[ermanoj3101 (MANOJ)]

I have ran the same code and it is printing right value, not sure why you are not getting it.

Let me out this variable instead of message box then just use that variable.

[ermanoj3101 (MANOJ)]

Try this
GetLastRow.xaml (8.2 KB)

[balupad14 (Balamurugan)]

Hi @sruthesanju ,

It may help you ,

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed 2 new activities. Find LastColumn that to find the last column Index and Column Name of the sheet . Find LastRow that to find the last row of the sheet and it returns the row index. [image] [image] Find LastColumn’s Properties : [image] Find LastRow Properties : [image] Note : If the sheet name is empty , It will take the first sheet name . Here is the video demonstration. [UiPath excel Extract Graph as Image | find last column Index| find last Row No…

Regards
Balamurugan.S

[sruthesanju (Sweety)]

It’s taking the whole excel last filled cell address
I need only for row no 1 which has period in A1

[ermanoj3101 (MANOJ)]

Getting some issue in invoke code.

I have create vba code, let me know if this works for you.

This will give you column number and address for row number 1

[sruthesanju (Sweety)]

How to use in uipath should I need to write code in invoke code

[ermanoj3101 (MANOJ)]

You can put this in xlsm file and call macro function from execute macro activity.