How to Filter Column values in Excel Sheet

[ppr (Peter Preuss)]

@Priyanka_Jadhav1

I want to filter out these values in a separate excel sheet. sheet name rename with filtered value.

sounds like you want to create different excels for each occuring region value

Assign activity
Left: TableList | List(of DataTable)
Right

(From d in dtData.AsEnumerable
Group d by k=d(“Region”).toString.Trim into grp=Group
Select gt=grp.CopyToDataTable).toList

Afterwards use a for each activity | item in TableList | TypeArgument: DataTable
and write each table to Excel with write range
The sheetname can be set e.g. table.Rows(0)(“Region”).toString

Case is very close to:

Split Csv file into multiple files according to month in date column

@Diva_P Welcome to the forum we can do it with help of GroupBy As a starter help: Assign activity: leftSide: TableList | DataType: List(Of DataTable) Right side: (From d in YourDataTableVar.AsEnumerable Group d by k= CDate(d(“Date”)).Month into grp=Group Select t=grp.CopyToDataTable).toList For Each Activity (NOT for each row) | TypeArgument: DataTable item in TableList write out month split excel to Excel - e.g. with write excel