How to keep only specific rows of data in excel

Help Studio
, , ,
1

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:
image
Expected output:
image
How to do this. Please help me.

Regards,
Lakshmi

2

Hi @lakshmi.mp

You can try with Filter datatable activity

Regards
Gokul

3

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

Regards,
Lakshmi

4

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.

5

Hi @lakshmi.mp,

You can filter your excel like this.

After, you can write filtered table to the excel.

image

Regards.
Ömer

1 Like
6

Hi @omer.ozturk ,

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

Thanks & Regards,
Lakshmi

1 Like
7

@lakshmi.mp,

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

Have a nice day.

Regards.
Ömer

1 Like
8

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

1 Like
9

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