#pragma warning disable CA1822 // Mark members as static public Cell Cell(object?value, DefaultStyle template, UInt32Value styleIndex) #pragma warning restore CA1822 // Mark members as static { string excelValue = value == null ? "" : template == DefaultStyle.DateTime ? ExcelExtensions.ToExcelDate(((DateTime)value)) : template == DefaultStyle.Date ? value is DateTime dt?ExcelExtensions.ToExcelDate(dt) : ExcelExtensions.ToExcelDate(((DateOnly)value).ToDateTime()) : template == DefaultStyle.Time ? ExcelExtensions.ToExcelTime((TimeOnly)value) : template == DefaultStyle.Decimal ? ExcelExtensions.ToExcelNumber(Convert.ToDecimal(value)) : template == DefaultStyle.Boolean ? ToYesNo((bool)value) : template == DefaultStyle.Enum ? ((Enum)value).NiceToString() : value.ToString() !; Cell cell = IsInlineString(template)? new Cell(new InlineString(new Text { Text = excelValue })) { DataType = CellValues.InlineString } : new Cell { CellValue = new CellValue(excelValue), DataType = null }; cell.StyleIndex = styleIndex; return(cell); }
public static void SetCellValue(this Cell cell, object?value, Type type) { if (type == typeof(string)) { cell.RemoveAllChildren(); cell.Append(new InlineString(new Text((string?)value !))); cell.DataType = CellValues.InlineString; } else { string excelValue = value == null ? "" : type.UnNullify() == typeof(DateTime) ? ExcelExtensions.ToExcelDate(((DateTime)value)) : type.UnNullify() == typeof(bool) ? (((bool)value) ? "TRUE": "FALSE") : IsNumber(type.UnNullify()) ? ExcelExtensions.ToExcelNumber(Convert.ToDecimal(value)) : value.ToString() !; cell.CellValue = new CellValue(excelValue); } }