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…...DataTable var table = new DataTable("MyTable"); table.Columns.Add("ColInt"...typeof(int)); table.Columns.Add("ColString", typeof(string)); table.Columns...