Datatype detection when column headings are present

[Merlin McKenzie]

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 10.204.0.75]

 

[Manikandan M]

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.

Thanks,
Manikandan M.

Forum_ExportDT_77e6d318.zip