We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Using Filter with criterias

Dear Aspose Team,

I've a table excel with 2 columns:

Column1 Column2

Data1 R1C2

Data2 R2C2

Data3 R3C2

I want to see the rows with this criterias: Column2 contains R?C2.

I'm using this code:

src.AutoFilter.SetRange(0, 0, 1)

src.AutoFilter.Filter(2, "R?C2")

But, it will return no lines.

How do i write my criteria with aspose ?



Hi Angélique,

Well, Custom filterization using wildcards like '?' is not supported, we will look into it to support it soon.

Thank you.

Hi Angélique,

Please try the new version http://www.aspose.com/community/files/51/file-format-components/aspose.cells/entry133353.aspx

And please set the custion filer as the following codes :

sheet.AutoFilter.Custom(1,FilterOperatorType.Equal, "R?C2");

It's great.