Since upgrading from Spire.XLS version 7.3.12.7040 to 7.12.27.6040 my InsertDataTable calls fail to insert Integer data.
My code:
ws.InsertDataTable(subset, False, 2, 2, True)
In every field that is an integer I get #NAME? in the spreadsheet cell. It does not matter if it is a 0 , 1, or 2017101110.
If my datatable contains a varchar, or floating point the insert works fine, but something is wrong when inserting an integer datatype.