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

Error:
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;

Solution:
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: