Excel data remove

Hi,
There is a excel that I creating from the bot. I need to remove some data.
If REFERENCE is equal 20000000 I need to remove data in Text, Quantity, Amount column data.
I attached excel with Input data and What output that I want

New Microsoft Excel Worksheet (2).xlsx (12.8 KB)

@Lochana_Bandusena

Welcome back to our UiPath community.

  1. Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say ‘InputDT’.

  2. And then use below expression to filter Reference value.

         OutputDT = InputDT.AsEnumerable().Where(Function(row) Not row("REFERENCE").ToString.Trim.Equals("20000000")).CopyToDataTable
    
  3. Finally use Write Range activity and pass OutputDT to write into Excel file.

@Lochana_Bandusena

Use Read Range activity and output to a Datatable Variable

Now use Filter Datatable, Click on Remove and in the column

ColumnName = 20000000

Hope this may help you

Thanks