private static string CreateExcelFormatting(ExportColumnDTO columnInfo)
{
if (string.IsNullOrWhiteSpace(columnInfo.ExcelFormat))
{
return("");
}
var datatypesThatNeedExcelFormatting = new string[] { "int", "long", "decimal", "double", "float", "datetime" };
return(datatypesThatNeedExcelFormatting.Contains(columnInfo.ColumnDataType.ToLowerInvariant())
? $"mso-number-format:\"{columnInfo.ExcelFormat}\""
: string.Empty);
}
private static string GetOfficeValue(ExportColumnDTO column, Type officeType)
{
if (string.IsNullOrWhiteSpace(column.ExcelFormat) || officeType == Type.WORD)
{
return(ApplyValueFormat(column));
}
if (column.ColumnDataType.ToLowerInvariant() == "datetime" && (column?.Value as DateTime?).HasValue)
{
return(ProceedDatetimeFields(column?.Value)?.ToLocalTime().ToOADate().ToString() ?? "");
}
return(column?.Value?.ToString() ?? "");
}
private static string ApplyValueFormat(ExportColumnDTO columnInfo)
{
return(ApplyValueFormat(columnInfo.ColumnDataType, columnInfo.Value, columnInfo.Format));
}
