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…...Rows.Add(1, "Hello", DateTime.UtcNow...UtcNow.Date.AddHours(9)); table.Rows.Add(2, "World", DateTime.UtcNow...