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…...values becomes formatted as “Date” in Excel. But, if the value...that should be formatted as Date, but that is too slow and clunky...