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

Datatype detection when column headings are present

Thread ID:





107778 Mar 17,2013 08:50 PM UTC Mar 21,2013 04:17 AM UTC WinForms 1
Tags: XlsIO
Merlin McKenzie
Asked On March 17, 2013 08:50 PM UTC

I am using this syntax to dump worksheet contents into a datatable:

sheet.ExportDataTable(sheet.UsedRange, ExcelExportDataTableOptions.ColumnNames | ExcelExportDataTableOptions.DetectColumnTypes)

It seems that the detection of column types is looking only at the first row, i.e. the row containing column names, and as they are all non-numeric, it never figures out that the subsequent rows actually contain numeric or date information.

Isn't this a bug? [using version]


Manikandan M [Syncfusion]
Replied On March 21, 2013 04:17 AM UTC

Hi Merlin McKenzi,

Thank you very much for your patience.

We are afraid that we are not able to reproduce the issue "Datatype is detect based on first row" from side. Whereas we could see the issue "Datatype is detect based on second row omitting subsequent rows"  and suspect that this could be issue. if this is the issue you are facing, please create the new incident with sample. so that we can proceed further and update you solution.

We have attached the sample below which we tried to reproduce the issue at our side.  If this sample does not meet with your sample scenario, please revert back us with issue reproducing sample. it would helps us to resolve the issue.

Please let us know if you need any clarifications.

Manikandan M.



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