We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How do I read a filtered Excel file?

Thread ID:





73132 Apr 21,2008 03:44 PM Apr 24,2008 08:05 AM Windows Forms 2
Tags: XlsIO
Asked On April 21, 2008 03:44 PM

I have a pretty big xls-file (of 8 megs). Is it possible to read only filtered rows?

Thanks in advance.

Replied On April 23, 2008 03:10 AM

Seems impossible as Excel does filtering at the runtime :(. Any ways to get the filtered rows with XlsIO itself?

Yavanaarasi G [Syncfusion]
Replied On April 24, 2008 08:05 AM

Hi Vadim,

Sorry for the delay in responding.

You can filtered the rows by using the following code snippet:

IWorksheet sheet = workbook.Worksheets[0];
//Creating an AutoFilter in the first worksheet. Specifying the Autofilter range.
sheet.AutoFilters.FilterRange = sheet.Range["B4:E19"];

Please refer the sample in the below link which illustrates the above:


Please try this and let me know if this helps.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.