We are using MicrosoftExcelUtils.CreateWorksheet(DataTable data, bool headers) to generate a worksheet from data retrieved from an Oracle database. The DateTime columns are losing the time portion when we save to .txt or .csv but are working fine when saving to .xlsx.
The DateTime used to save properly with time but stopped working recently when we migrated to AWS ECS containers.
Is there a way we can make all DateTime include the time portion? We don't always know which column is a DateTime format, the query can be user specified.
Our code looks like:
Snippetvar excel = CreateWorksheet(data.Tables[0], headers);
var workbook = excel.Item1;
var worksheet = excel.Item2;
switch (fileType.ToLower()) {
case "xlsx":
workbook.SaveAs(stream);
break;
case "xml":
workbook.SaveAsXml(stream, ExcelXmlSaveType.MSExcel);
break;
case "csv":
worksheet.SaveAs(stream, ",", Encoding.ASCII);
worksheet.Range
break;
case "txt":
worksheet.SaveAs(stream, "\t", Encoding.ASCII);
break;
default:
worksheet.SaveAs(stream, " ", Encoding.ASCII);
break;
}
Snippet<package id="Syncfusion.XlsIO.AspNet" version="21.2.10" targetFramework="net48" />
p.s. Richard Bianco is posting this question under the account of Peter DeNoyelles.
