Multiple AutoFilter Ranges?

[Administrator]

Hi. I'm wondering if it is possible to assign multiple Autofilter ranges to the same sheet with XLSIO?

Any help would be appreciated.

[Yavanaarasi G]

Hi Hockett,

Thank you for your interest in Syncfusion products.

Yes. It is possible to assign multiple Autofilter ranges to the same sheet with XlSIO. Please refer the below code snippet:

[C#]
IRanges rangesOne = sheet.CreateRangesCollection();
rangesOne.Add(sheet.Range["A1:C7"]);
sheet.AutoFilters.FilterRange = rangesOne;

Here is the sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Windows/F73791/ExcelAutofilter/main.htm

Please try this and let me know if this helps.

Regards,
G.Yavana