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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How do I read a filtered Excel file?

Thread ID:





73132 Apr 21,2008 07:44 PM UTC Apr 24,2008 12:05 PM UTC WinForms 2
Tags: XlsIO
Asked On April 21, 2008 07:44 PM UTC

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 07:10 AM UTC

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 12:05 PM UTC

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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon