How to Go to Last Row of Excel

[mazlumkacar (mazlum kaçar)]

Hi all,

I try to go to the last row of an opened excel table but it didn’t work.

I used send hotkey ctrl+down but i do not understand why it is not work.

In addition: when i do that manually it is work.

Have you got any idea about that?

[Palaniyappan (Palaniyappan P)]

Hi
Hmm…that must be working
is the excel application set to full screen and is kept opened in foreground
and then mention the send hot key activity
Cheers @mazlumkacar

[HareeshMR (Hareesh Madasi)]

Can you try sending hot key after a click activity @mazlumkacar

[balupad14 (Balamurugan)]

Hi @mazlumkacar,

Here is an activity called "Find LastRow ". Using this you can able to get the last row no.

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

[mazlumkacar (mazlum kaçar)]

Yes excel is in the foreground. And i think there is no problem at my send hotkey activity as you can see its properties.

When i do that manually, it choose the last row of the table.
But this send hotkey activity choose the second row of the table. I do not understand why.

@Palaniyappan
@HareeshMR

[mazlumkacar (mazlum kaçar)]

And also i am getting this error now.

@Palaniyappan
@HareeshMR

[Palaniyappan (Palaniyappan P)]

Hi
Kindly do a click on the application with CLICK activity On excel and then use send hot key activity or
Use GET ACTIVE WINDOW activity and then inside that use Send hot key activity and try once pls

Cheers @mazlumkacar

[ImPratham45 (Prathamesh Patil)]

Try using indicate that screen