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.

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:

C#

VB

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

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

Reply
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

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.