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


Thread ID:





73461 May 7,2008 07:04 PM UTC Nov 11,2012 10:06 PM UTC ASP.NET Web Forms (Classic) 2
Tags: XlsIO
Administrator [Syncfusion]
Asked On May 7, 2008 07:04 PM UTC

I have a set of rows that has a number representing the column name. When I exportDataTable with ExcelExportDataTableOptions.ColumnNames and later try to retrieve the column name from the DataTable, I get a generic "Column1,Column2, etc" instead of the actual number (which is the column name).

To work around this, I have to make the cell a "text" field, but most users won't remember to do this...

Bhuvaneswari P [Syncfusion]
Replied On May 8, 2008 01:38 PM UTC

Hi Mia,

Thank you for your interest in Syncfusion products.

I am afraid that I am not able to reproduce the issue. After export to Data table, it’s returning the correct column name. It’s not returning the generic column name.

Here is the sample for your reference:


Please take a look into the sample and let me know the modified sample to reproduce the issue in our end.

Best Regards,

Aaron Elder
Replied On November 11, 2012 10:06 PM UTC

This seems to be a bug, even though you are exporting a "data table", the "ColumnNames" options seems to require the FIRST row of the SHEET to have the names.


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

This page will automatically be redirected to the 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