How to remove empty rows in excel sheet

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

Thanks in advance

Hi @Rsr_C29

Welcome to uipath community

Refer the XAML file

RemoveEmptyRowsinExcel.xaml (5.3 KB)

Regards
Gokul

I tried not working

Have check the XAML file @Rsr_C29

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

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)

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