Exporting Excel Formulas
Download an Excel file that retains the formulas applied within the grid.
In the downloaded Excel file, if you modify values such as "Number of Payments" or "Payment Amount," the calculation results will update automatically based on the formulas.
Try changing the values in the "Number of Payments" or "Payment Amount" columns in the downloaded Excel file.
Loading RealGrid...
Use the excelFormulaStatement property on a column or group footer to specify the formula to be exported to the Excel file.
{
name: "SaveMaturity",
fieldName: "SaveMaturity",
width: "100",
numberFormat: "#,##0",
header: {
text: "Total Amount"
},
excelFormulaStatement: "\${excelcolumn['SaveCost']}\${row} * \${excelcolumn['ToMonth']}\${row}",
groupFooter: {
expression: "sum['SaveMaturity']",
numberFormat: "#,##0",
excelFormulaStatement: 'subTotal(9, \${excelcolumn["SaveMaturity"]}\${firstRow}:\${excelcolumn["SaveMaturity"]}\${lastRow})'
},
footer: {
expression: "sum['SaveMaturity']",
excelFormulaStatement: 'subTotal(9, \${excelcolumn["SaveMaturity"]}\${firstRow}:\${excelcolumn["SaveMaturity"]}\${lastRow})',
numberFormat: "#,##0"
},
styleName: "right-column"
}