Telerik xamarin export worksheet to datatable error.

[Coopbase]

{Telerik.Windows.Documents.Spreadsheet.FormatProviders.InvalidDataTypeException: Invalid data passed
  at Telerik.Windows.Documents.Spreadsheet.FormatProviders.DataTableFormatProvider.ValidateDataType

 

ColumnIndex = 0

CurrentDataType = "System.Double"

ExpectedDataType = "System.String"

RowIndex = 41

error occurs when i add number in the worksheet cell.

ive tried testing  a blank worksheet it works fine.

[Dimitar]

Hello,

This happens when there is more than one data type in a single column. By default, the provider is setting the datatype of each column in the data table. This is controlled by the ShouldSetDataTypes property. More information is available here: Settings.

I hope this helps. Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik