How to delete multiple rows in excel

Help Studio
#1

Hello

How can I delete multiple rows in excel sheet for same value/string.

Ex. Input string : 102
In excel sheet 102 string find multiple times.

delete all rows of 102 string/value.

Thanks
Minal Patil

#2

Couple off the top of my head.

You could do a foreach row in the table loop.
You could add an excel macro into the spreadsheet and have the robot execute it.

#3

  1. download
    Append Row Number in DataTable - RPA Component | UiPath Marketplace

  2. use append row number activity to your datatable, so it will have a “RowNumber” column

  3. use filter datatable activity to filter column = 102

3a. set rowsList (list of integer variable) = dtFiltered.AsEnumerable.Select(function(x) CInt(x("RowNumber").toString)).ToList
this will give you a list of rowNumbers where column = 102

  1. download
    Excel Activities for Processing and Filtering - RPA Component | UiPath Marketplace

  2. use Batch Delete Rows In Excel activity, pass in rows list