Page History

ExcelApplication xla = new ExcelApplication();
Workbook wb = xla.Create();
wb.UseRCFormulaNotation = true;
Worksheet ws = wb.Worksheets[0];
String formulaString = "=SUM(R[-12]C:R[-1]C)";
Cell columnTotal;
for (int i = 0;i < 3; i++)
{
     columnTotal = ws.Cells[13, i + 1];
     columnTotal.Formula = formulaString;
}