Read last row excel

[fairymemay (noona)]

I want to read data from file input last rows in yellow highlight (column G - column AE)
And write in folder output follow date month data input (column B -Z)

Example : input file date = 31/12/2021
I want to write in folder output in file 12/2021 and row 31/12/2021

Please guide me about it.

[balupad14 (Balamurugan)]

Hi @fairymemay

To find the last row in the excel you use this activity.

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…

Check this video!

UiPath excel Extract Graph as Image | find last column Index| find last Row No (BalaReva)

Regards
Balamurugan.S