Filtering Column in Excel


#1

Hi All,

I need to filter column in excel where I want to filter column “courseNumber” which starts with 1013 and save it into another CSV…here is the screenshot of Excel…Quick suggestion and reply would really help.

Thanks,
Somya


#2

Hi,
Here i have attached the sample for filtering column in Excel

File : Filtering Column in Excel.zip (13.5 KB)

Thank you
Balamurugan.S


#3

@somya177
First Read your excel sheet and store it in a datatable variable dt
Then try this query and Assign the result to datatable dtb
dtb=(From p in dt.select()
where Convert.Tostring(p.Item(“COURSE_Number”)).startsWith(“1013”)
Select p).ToArray.CopyToDataTable

Regards,
Mahesh


#4

Hi @somya177,
Using Read range activity to get the data to Data Table (Dt)
use assign activity to filter the data
Dt=Dt.Select("COURSE_NUMBER like '1013%' ").CopyToDataTable()

use write range to write the data into another excel file.

Regards,
Arivu