How to remove empty rows in excel sheet

[Rsr_C29]

PFA, I need to remove empty rows from sheet, I tried but it is not working

Thanks in advance

[Gokul001 (Gokul Balaji)]

Hi @Rsr_C29

Welcome to UiPath community

Refer the XAML file

RemoveEmptyRowsinExcel.xaml (5.3 KB)

UiPath Remove or Delete Empty Rows Example

Regards
Gokul

[Rsr_C29]

I tried not working

[Gokul001 (Gokul Balaji)]

Have check the XAML file @Rsr_C29

[hairulazizan]

There is an activity to insert/delete rows. You can use it to remove the empty rows

[ushu (Usha kiranmai)]

Hello, @Rsr_C29

Welcome to UiPath community!

Look for a column name called Name using LookUpRange activity and remove the empty rows on top of it. Have a look on the attached workflow

Example.zip (10.1 KB)