Free Support Forum - aspose.com

AutoFilter

Is there a way I can dynamically set autofilter for a specified cell or group of cells via code?

thanks,
-c

Hi, thanks for your consideration.

Currently Aspose.Excel only support autofilter in designer file.

We would REALLY appreciate it if you can add a method to Aspose Excel which would allow us to dynamically set autofilter for a particular column. Is there any chance? We are in the process of developing complicated reports which require this feature.

Thanks,
-Chi

Hi, Chi.

I will start to add a method to meet your need. But since this feature is difficult to implement, it will be available till 10/15 in my plan.

Thanks! again, we truly appreciate it.

-Chi

Dear Chi,

Please download hotfix 1.6.1.

You can use the following code to set autofilter in column 1 & 2.

sheet.AutoFilter.Name = “A1:B1”;

Sorry, mistyped.

sheet.AutoFilter.Range = “A1:B1”;

fantastic! i will download and try it today. thank you.