Using Filter with criterias

Aspose.Cells Product Family
1

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

2

Hi Angélique,

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

Thank you.

3

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");

4

It's great.

Thanks

Angélique