How can I remove text from end part of a excel doc

[pasingh]

[KanadMehta]

Hello @pasingh, welcome to the forum.
If the empty line before is constant you can use that as index for row removal and for added validation you can check empty column one.

In case solution is unclear to you please happen some excels, I will give you xaml file

[Atul_Rai]

@pasingh

Is the unwanted data always come in the same rows?

[balupad14 (Balamurugan)]

Hi @pasingh !

Welcome to UiPath Community !

1. use the Find last row activity from below. It will return the row index which you have used the last row.

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…

Here is the video demo :

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

2. Use the delete row activity from here.

UiPath Go ! BalaReva EasyExcel Activities

Hi , I have developed a new activity to delete the contiguous rows in side excel sheet in the package version 6.0.0. You can get the package Here. Important Property : Row Range : { “1”,“3:5”,“11”,“20:35” } Namespace : [image] Activity and Properties : [image] Regards Balamurugan.S

Here is the demo :

Uipath | excel delete rows | excel delete columns | excel copy as picture (BalaReva)

Regards
Balamurugan.S

[pasingh]

Hi Thanks very much for your post but this is unclear to me. could you please send me the xaml file.

[KanadMehta]

Here is sample logic w.r.t. excel
test123.xlsx (9.7 KB) DeleteExtraFromExcel.xaml (9.5 KB)

[pasingh]

Thanks very very much for your help.
I have also posted another question regarding excel. Could you please look into it and help me with that.

Here is link to the question - Delete Zero from Column 2 in Excel