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…...the DateTime column to “YYYY-MM-DD”. But nothing works. I know...string[] { null, null, "YYYY-MM-DD" }, ConvertNumericData = false...