ExcelProvider
ExcelProvider copied to clipboard
InvalidCastException if some of cells in string column are numeric
Occurs if enumerate all rows. As a workaround i have selected the entire column and set format to text
System.InvalidCastException: Unable to cast object of type 'System.Double' to type 'System.String'.
at [email protected](Row x) in my.fsx:line 245
at [email protected](b& )
at Microsoft.FSharp.Collections.IEnumerator.MapEnumerator1.System-Collections-IEnumerator-MoveNext() at Microsoft.FSharp.Collections.SeqModule.ToList[T](IEnumerable
1 source)
at <StartupCode$FSI_0073>.$FSI_0073.main@()
Stopped due to error
I have this problem too. Same workaround - format column to Text. would be nice if the type provider could automatically call ToString where necessary