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

Datatype detection when column headings are present

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]


1 Reply

MM Manikandan M Syncfusion Team 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.


Live Chat Icon For mobile
Up arrow icon