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…...Add("ColString", typeof(string)); table.Columns.Add("ColDateTime"...= true, NumberFormats = new string[] { null, null, "YYYY-MM-DD"...