Unity Error:InvalidCastException: Cannot cast from source type to destination type.

when I use system.data.dll to parse excel table; Encountered this error:

wrong positioning:
this is an excel problem; The error is reported in: excel reader. Asdataset() is due to the problem of Excel format;

you can solve this problem by setting the cell format as text in Excel table;

Reference website:
Yusong Momo cross platform analysis Excel

Read More: