Hi All, I need to filter this excel file to extract only the current month’s data. the file has two columns of current year and current month, and there might be another column with same month but different year. I need to extract only the data for current month and year [A spreadsheet with colum…

@sahfarooq read whole excel without headers then use a for loop with dt.Columns now inside loop use crrentitem.ColumnName = dt.Rows(1)(currentItem.ColumnName).ToString + "-" + dt.Rows(0)(currentItem.ColumnName).ToString now column names are of format month-year so use a filter datatable and sel…

Filter particular columns in excel

Help Studio

system (system) Closed February 2, 2025, 9:58am 3

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

Topic		Replies	Views
Excel / filter date Studio datatable , excel , studio , question , activities_panel	1	889	August 25, 2022
Filter Datatable to get only current month Data Academy Feedback studio	9	2529	March 26, 2019
Filtering Column by the Current Month Help	8	2313	February 14, 2019
How to apply filter for columns(date column) in excel & filter latest 2 months data Help	13	2062	February 25, 2020
Filter in excel data Help studio	2	1177	July 12, 2018

Filter particular columns in excel

Related topics