It looks like at the current state ExcelProvider<> supports a very limited set of data types, namely float, bool, DateTime (which sometimes is not recognized correctly) and string.
This issue brings two things:
Support more types, at least double, decimal, int, int64 and options. Excels are often used in fields, where float precision is far to weak.
Idea borrowed from a CsvProvider, which allows to define additional Schema property where types of columns can be specified manually (I found some cases where Date column is treated as float). It doesn't have to be as advanced as in CsvProvider, but something like date,string, string, int option, decimal would be a great relief.
dsyme
commented
6 years ago
It looks like at the current state
ExcelProvider<>supports a very limited set of data types, namelyfloat,bool,DateTime(which sometimes is not recognized correctly) andstring.This issue brings two things:
double,decimal,int,int64and options. Excels are often used in fields, where float precision is far to weak.Schemaproperty where types of columns can be specified manually (I found some cases where Date column is treated as float). It doesn't have to be as advanced as in CsvProvider, but something likedate,string, string, int option, decimalwould be a great relief.