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 ?

Thanks,

Angélique

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.

Thanks

Angélique