How can I do that using Spire.XLS?
I was trying to get to see if I can use a console application to print the filtered data on console to check whether I was on the right path but I was unable to print the filtered data on console and it just printed the entire worksheet data
Here's my code snippet
- Code: Select all
Workbook wbk = new Workbook();
wbk.LoadFromFile(@"D:\@@@21-2-21\data.xlsx",true);
Worksheet sht = wbk.Worksheets[0];
AutoFiltersCollection filters = sht.AutoFilters;
filters.Range = sht.Range[1, 1, sht.LastRow, sht.LastColumn];
filters.AddFilter(10, "Seattle");
filters.Filter();
foreach (var item in filters.Range)
{
Console.WriteLine(item.Value2);
}
Console.WriteLine("Done!");
Please help.