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 get column names of a named range with column headers in C#, VB.NET?

Platform: WinForms |
Control: XlsIO

This article explains how to retrieve the column names from a named range with column headers using XlsIO.

XlsIO does not have any direct way of retrieving column names from a named range with column headers. But there are few workarounds to achieve this. One way is exporting the named range to data table and retrieving the column names from data table. The alternate one is processing named range.

XlsIO always considers first row of named range as column header. So, the column names can be retrieved by accessing the first row of named range.

Download input file with data

Download complete sample

To know more about exporting data to data table, please refer the documentation.

The following complete code snippet explains how to retrieve column names of a named range with column headers by processing it.

C#

VB

 

2X faster development

The ultimate WinForms UI toolkit to boost your development speed.
ADD COMMENT
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