I’m using Aspose.cells V 188.8.131.52 and I have the same problem that we can find in the other topics (ImportDataTable- convertStringToNumber- and Dates).
I have a DataTable which contains Strings, Float and DateTime. I use this code for importing data:
worksheet.Cells.ImportDataTable(dataTables[i], true, 0, 0, dataTables[i].Rows.Count, dataTables[i].Columns.Count, true, “d-m-yyyy”, true);
and in output I have number values like 42628 for dateTime.
Do you have any suggestion for me?