Wiki Markup |
---|
{description} {excerpt} Sets the formula of the worksheet to the given Add-In Formula. {excerpt} {signature:C#} public void SetAddInFormula(string formula) {signature} {signature:vb.net} Public Sub SetAddInFormula(ByVal formula As String) {signature} {parameters} {param:formula} Add-In Formula you wish to add, as a String. Include the equals sign as well as a reference to the Excel Add-In file you wish to reference, if the file is not included in the local macros directory. {param} {remarks} {remarks} {example} {code:csharp|title=C#} //--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple //--- from the file TestAddInFormula2Helper.xpl.xla WB[0]["D3"].SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)"); {code} {code:vb.net|title=vb.net} '--- Set Cell D3 on the first Worksheet to reference formula Module1.Apple '--- from the file TestAddInFormula2Helper.xpl.xla WB(0)("D3").SetAddInFormula("=TestAddInFormula2Helper.xpl.xla!Module1.Apple(1)") {code} {example} {scrollbar} |
Page History
Overview
Content Tools