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

Capture

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

@pasingh

Is the unwanted data always come in the same rows?

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.

Here is the video demo :

  1. Use the delete row activity from here.

Here is the demo :

Regards
Balamurugan.S

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

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

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

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.