CellSetAddInFormula Method

Note: This API is now obsolete.

Sets an Add-In formula to the cell.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.10.0.0 (19.10)
Syntax
[ObsoleteAttribute("Use WorksheetCollection.RegisterAddInFunction and Cell.Formula/Cell.SetFormula() instead.")]
public void SetAddInFormula(
	string addInFileName,
	string addInFunction
)

Parameters

addInFileName
Type: SystemString
Add-In file name.
addInFunction
Type: SystemString
Add-In function name.
Remarks
Add-In file should be placed in the directory or sub-directory of Workbook Add-In library. For example, file name can be "Eurotool.xla" or "solver\solver.xla". NOTE: This class is now obsolete. Instead, please use Cell.Formula/Cell.SetFormula() to set cell formula with the Add-In functions after registering it by WorksheetCollection.RegisterAddInFunction(). This property will be removed 12 months later since January 2019. Aspose apologizes for any inconvenience you may have experienced.
Examples
[C#]
cells["h11"].SetAddInFormula("HRVSTTRK.xla", "=pct_overcut(F3:G3)");
cells["h12"].SetAddInFormula("HRVSTTRK.xla", "=pct_overcut()"); 

[Visual Basic]
cells("h11").SetAddInFormula("HRVSTTRK.xla", "=pct_overcut(F3:G3)")
cells("h12").SetAddInFormula("HRVSTTRK.xla", "=pct_overcut()")
See Also