Formulas in the Excel Export Library

• Sep 19, 2023
• 2 minutes to read

To create a formula in a cell, use the IXlCell.SetFormula method. This method enables you to specify a formula in different ways:

• Use textual representation.

• Use IXlFormulaParameter object.

• Compose a formula from expression tokens.

This section contains the following examples which illustrate the use of the methods described above.

• How to: Create a Cell Formula
• How to: Create Shared Formulas
• How to: Create Subtotals