A cell of an Excel matrix with a formula (<f>) and its calculated value (<v>, shown until Excel recalculates). Understood by ExcelService; TableApi.downloadExcel writes them for cell formulas with { cellFormulas: true }.
<f>
<v>
{ cellFormulas: true }
await new ExcelService().downloadExcel([[2, 3, { formula: "A1*B1", value: 6 }]], "sheet.xlsx"); Copy
await new ExcelService().downloadExcel([[2, 3, { formula: "A1*B1", value: 6 }]], "sheet.xlsx");
1.1.99
The formula without =, with Excel's function names ("SUM(D2:D4)", "_xlfn.XLOOKUP(…)").
=
"SUM(D2:D4)"
"_xlfn.XLOOKUP(…)"
The calculated value: a number, text, boolean, Date or an error value.
Date
A cell of an Excel matrix with a formula (
<f>) and its calculated value (<v>, shown until Excel recalculates). Understood by ExcelService; TableApi.downloadExcel writes them for cell formulas with{ cellFormulas: true }.Example
Since
1.1.99