Hello,
I have a ops column where some of the values in datatable like 10,15 or 03,10,15. Now when it's displaying this using Free spire.xls the column looks like 10/15/2017 or 3/10/2015
Datable Excel
10,15 10/15/2017 not ok. how it's converting to date
03,10,15 3/10/2015 not ok. how it's converting to date
09 9 This is ok. But needs to be 09 though
I don't have any date format or anything.
code is simple . I have sheet.InsertDataTable(dt, true, 3, 1);
then savetoFile. Need help. this is strange.