Telerik xamarin export worksheet to datatable error.

1 Answer 92 Views
SpreadStreamProcessing
Coopbase
Top achievements
Rank 2
Iron
Iron
Coopbase asked on 11 Nov 2021, 08:12 AM | edited on 12 Nov 2021, 02:48 AM

{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.

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 12 Nov 2021, 06:05 AM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
SpreadStreamProcessing
Asked by
Coopbase
Top achievements
Rank 2
Iron
Iron
Answers by
Dimitar
Telerik team
Share this question
or