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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to access entire named range count in a workbook?

Platform: WinForms |
Control: XlsIO

The named ranges in a workbook is separated into two types based on their values. If value is a valid range, then it is known as known named range. If values is invalid range (i.e., #REF), then it is known as unknown named range. We have maintained two properties to return the count of named ranges with and without unknown named ranges.





Returns the count of the known named range.


Returns the count of the named range including unknown named range.


To access the entire named range count, the INames object must be type-casted to WorkbookNamesCollection. Please refer the below code example to access the entire named range count in workbook.




The sample illustrating this behavior can be downloaded here.


2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
You must log in to leave a comment

Please sign in to access our KB

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

Up arrow icon

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

Live Chat Icon For mobile