While Importing how to check spreadsheet is filtered

[Administrator]

Hi,

I am opening an excel file, I want to check whether there is a filter on the worksheet?
I tried using
IWorksheet.AutoFilters.Count but the problem with it is that once all the filter is removed from the sheet, it still gives count greater than zero.
Is there any other way to find out if the sheet is filtered?

MTK

[Administrator]

Hi,

This has been identified as a bug . You can track the live status of this issue here

http://www.syncfusion.com/support/issues/excelrw/Default.aspx?ToDo=view&questId=482

We will try to address this issue as soon as possible.

Thanks,

Stephen.

>Hi,
>
> I am opening an excel file, I want to check whether there is a filter on the worksheet?
>I tried using
>IWorksheet.AutoFilters.Count but the problem with it is that once all the filter is removed from the sheet, it still gives count greater than zero.
>Is there any other way to find out if the sheet is filtered?
>
>MTK