public static ExcelRange WriteNumber(this ExcelRange rnge, decimal?number, string format = "#,##0.00 ")
{
rnge.Value = number;
return(rnge.FormatNumber(format)
.AlignRight());
}
public static ExcelRange WriteFormula(this ExcelRange rnge, string formula, string format = "#,##0.00 ")
{
rnge.Formula = formula;
return(rnge.FormatNumber(format)
.AlignRight());
}
public static ExcelRange WriteDate(this ExcelRange rnge, DateTime date, string format = "d MMM yyyy")
{
rnge.Formula = $"=DATE({date.Year},{date.Month},{date.Day})";
return(rnge.FormatNumber(format)
.AlignCenter());
}