I have a requirement to quickly load a DataTable into an Excel sheet, where cells should automatically format to correspond to the DataTable’s column types. This is particularly important for DateTime columns.
This work…... to explicitly specify the number format for the DateTime column...cell is left with the General number format. Aspose .Cells does...