Excel filter by column and create new sheet

[deha_akbulut]

Hi,

I have this excel file as shown below. I want to write all rows with “İstanbul” under column “H” on a new sheet.

Can anyone help please ?
Thanks

[vrdabberu (Varunraj Dabberu)]

Hi @deha_akbulut

Try this:

istanbulRows = (From row In YourDataTableVar.AsEnumerable()
                    Where row.Field(Of String)("ColumnHName").Trim().Contains("İstanbul", StringComparison.OrdinalIgnoreCase)
                    Select row).CopyToDataTable()

istanbulRows is of DataType System.Data.DataTable.

Please Replace your column name and the name you want t write in seperate sheet accordingly.

Regards

[adiijaiin (Aditya Jain)]

Hi @deha_akbulut

Just use a filter data Table activity.
Use the Filter <Il/Ilce> contains Istanbul
Write the data in another sheet using Write Range or delete the data from existing one and write it using Write Range.

Thanks
Happy Automation!

[Jayesh_678 (Jayesh)]

Hi,

Input:-

Output:-

Xaml File:-
filter data forum.zip (10.0 KB)

If this works you, please mark this as a solution for others reference.

Thanks