Jan 29, 2020 05:42 AM|Yongqing Yu|LINK
According to the master_employee object mentioned in your code, is this a custom class that is consistent with the database table field ?
This error indicates that the field active
you get from excel cannot be converted to the Boolean field active in the master_employee class,because active field is a string type in excel.
I suggest that you create a new class, and keep it the same struct except that the active type is changed to a string type.
Use the new class to receive the data obtained in Excel, and then convert the active to bool when assigning to the master_employee class.
You can also refer to this link:
PostgreSQL, problems with Boolean type storing values as “T” and “F” breaking ORM