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.
Unfortunately, activation email could not send to your email. Please try again.

Datatype detection when column headings are present

Thread ID:

Created:

Updated:

Platform:

Replies:

107778 Mar 17,2013 04:50 PM Mar 21,2013 12:17 AM Windows Forms 1
loading
Tags: XlsIO
Merlin McKenzie
Asked On March 17, 2013 04:50 PM

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 [Syncfusion]
Replied On March 21, 2013 12:17 AM

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

CONFIRMATION

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.

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.

;