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…...quickly load a DataTable into an Excel sheet, where cells should automatically...becomes formatted as “Date” in Excel. But, if the value being imported...