public ExcelRange WriteDifferenceFormula(string minuendAddress, string subtrahendAddress, string format = "#,##0.00 ") { var fmla = $"={minuendAddress} - {subtrahendAddress}"; var cell = CurrentCell.WriteFormula(fmla, format); MoveToNextRow(); return(cell); }
public ExcelRange WritePercentFormula(string numeratorAddress, string denominatorAddress, string format = "#,##0.00 % ") { var fmla = $"={numeratorAddress} / {denominatorAddress}"; var cell = CurrentCell.WriteFormula(fmla, format); MoveToNextRow(); return(cell); }