How to keep only specific rows of data in excel

[lakshmi.mp]

Hi All,

Excel file has some unwanted rows of data need to remove those particular rows. By taking one column (Sl. No) as condition how to do this, please help.
Below attached file is the sample file, please look on it.
test_file.xlsx (8.8 KB)
Input data:

Expected output:

How to do this. Please help me.

Regards,
Lakshmi

[Gokul001 (Gokul Balaji)]

Hi @lakshmi.mp

You can try with Filter datatable activity

Regards
Gokul

[lakshmi.mp]

hi @Gokul001 ,
i tried but its deleting whole excel file. What to do.

Regards,
Lakshmi

[postwick (Paul)]

Read Range into a datatable. Remove the rows you don’t want, from the datatable. Write to a new Excel file. Delete old Excel file.

[omer.ozturk (Ömer Öztürk)]

Hi @lakshmi.mp,

You can filter your excel like this.

After, you can write filtered table to the excel.

Regards.
Ömer

[lakshmi.mp]

Hi @omer.ozturk ,

Thanks a lot helping. I tried using “SI. No” = “PW980”, its was deleting all the rows.

Thanks & Regards,
Lakshmi

[omer.ozturk (Ömer Öztürk)]

@lakshmi.mp,

I’m glad this activity works, i thought you need to specify the rows start with PW

Have a nice day.

Regards.
Ömer

[postwick (Paul)]

@lakshmi.mp

“Sl no.” = “PW980”

That column name is wrong. It’s “SI. No”