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

My used range includes empty cells. How do I avoid this?

By default, used range include cells with value and sometimes cell with no data (but has

Formatting applied etc.). This is the nature that can be seen in MS Excel (by pressing Ctrl + End). In order to get the range of cell which has data alone, UsedRangeIncludesFormatting should be set to false. The below snippet illustrates this:



Article ID: Published Date: Last Revised Date: Platform: Control:
1917 04/30/2011 07/18/2014 WinForms XlsIO
Did you find this information helpful?
seetharaman Mar 09, 2018

sometimes when i give this , it gives compile error , some times run time error 424!!!

Abirami Varadharajan [Syncfusion] Mar 20, 2018

There should not be any compilation error or runtime exception while using this property.

API Reference: https://help.syncfusion.com/cr/cref_files/file-formats/xlsio/Syncfusion.XlsIO.Base~Syncfusion.XlsIO.IWorksheet~UsedRangeIncludesFormatting.html
This property works fine and we recommend you to upgrade your Syncfusion version to latest one if you are using older version.
In-case if there is any error or exception, please share us the error/exception stack trace to check further.
Add Comment
You must log in to leave a comment

Please sign in to access our KB

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