ExcelProvider icon indicating copy to clipboard operation
ExcelProvider copied to clipboard

InvalidCastException if some of cells in string column are numeric

Open vilinski opened this issue 9 years ago • 1 comments

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](IEnumerable1 source) at <StartupCode$FSI_0073>.$FSI_0073.main@() Stopped due to error

vilinski avatar Apr 18 '15 23:04 vilinski

I have this problem too. Same workaround - format column to Text. would be nice if the type provider could automatically call ToString where necessary

alexfoxgill avatar Nov 02 '16 11:11 alexfoxgill