API Reference
Class
ExcelFormulaSyntaxTree
Immutable syntax tree for reference-bearing Excel formula text. It preserves all non-reference tokens verbatim and provides the common rewriter used by public conversion and search APIs.
Inheritance
- Object
- ExcelFormulaSyntaxTree
Usage
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by
- Property ExcelFormulaCellInfo.SyntaxTree
- Method ExcelFormulaSyntaxTree.Parse
Methods
public String ConvertReferences(ExcelReferenceStyle outputStyle, Int32 anchorRow = 1, Int32 anchorColumn = 1) #Returns:
StringConverts every parsed reference to A1 or R1C1 notation.
Parameters
- outputStyle OfficeIMO.Excel.ExcelReferenceStyle
- anchorRow System.Int32 = 1
- anchorColumn System.Int32 = 1
public static ExcelFormulaSyntaxTree Parse(String formula) #Returns:
ExcelFormulaSyntaxTreeParses A1 formula references while preserving all other tokens verbatim.
Parameters
- formula System.String
public String Rewrite(Func<ExcelReference, ExcelReference> rewriter, ExcelReferenceStyle outputStyle = A1, Int32 anchorRow = 1, Int32 anchorColumn = 1) #Returns:
StringRewrites reference nodes once while preserving literals and all other syntax.
Parameters
- rewriter System.Func{OfficeIMO.Excel.ExcelReference,OfficeIMO.Excel.ExcelReference}
- outputStyle OfficeIMO.Excel.ExcelReferenceStyle = A1
- anchorRow System.Int32 = 1
- anchorColumn System.Int32 = 1
public String RewriteNames(Func<String, String> rewriter) #Returns:
StringRewrites defined-name nodes while preserving all other formula syntax.
Parameters
- rewriter System.Func{System.String,System.String}
public String RewriteStructuredReferences(Func<String, String, String> rewriter) #Returns:
StringRewrites structured table-reference nodes while preserving all other formula syntax.
Parameters
- rewriter System.Func{System.String,System.String,System.String}
public String RewriteTableNames(Func<String, String> rewriter) #Returns:
StringRewrites table identifiers in structured and bare table-reference nodes.
Parameters
- rewriter System.Func{System.String,System.String}
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object