Namespace EasyXLS.Util

Class FormulaParser

System.Object
EasyXLS.Util.FormulaParser
public class FormulaParser extends System.Object
This class contains useful methods for parsing formulas.

  • Constructor Summary

    Constructors
    Constructor
    Description
    FormulaParser()
     

  • Method Summary

    Modifier and Type
    Method
    Description
    const int[]
    get2DCellElements​(System.String sCellReference)
    Returns an array of integers containing the elements of the specified sCellReference
    const int[]
    get2DRangeElements​(System.String sRange)
    Returns an array of integers containing the elements of the specified sRange
    const System.String[]
    get3DCellElements​(System.String sCellReference)
    Returns an array of objects containing the elements of the specified sCellReference
    const List
    getTokens​(System.String formula)
    Returns a list of tokens after parsing a formula definition
    const bool
    IsUnsignedInteger​(System.String sValue)
    Returns true if the sValue represents an unsigned integer value.

    Methods inherited from class System.Object

    equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

  • Constructor Details

    • FormulaParser

      public FormulaParser()

  • Method Details

    • get2DCellElements

      public const int[] get2DCellElements​(System.String sCellReference)
      Returns an array of integers containing the elements of the specified sCellReference
      Parameters:
      sCellReference - the range whose elements will be returned.
      Returns:
      int[0] - the number of the column; int[1] - the number of the row; int[2] - 1 if is absolute column; int[3] - 1 if is absolute row;

    • get3DCellElements

      public const System.String[] get3DCellElements​(System.String sCellReference)
      Returns an array of objects containing the elements of the specified sCellReference
      Parameters:
      sCellReference - the range whose elements will be returned.
      Returns:
      String[0] - sheet name; String[1] - the number of the column; String[2] - the number of the row; String[3] - 1 if is absolute column; String[4] - 1 if is absolute row;

    • get2DRangeElements

      public const int[] get2DRangeElements​(System.String sRange)
      Returns an array of integers containing the elements of the specified sRange
      Parameters:
      sRange - the range whose elements will be returned.
      Returns:
      int[0] - the number of the first column; int[1] - the number of the first row; int[2] - the number of the second column; int[3] - the number of the second row. int[4] - 1 if is absolute first column; int[5] - 1 if is absolute first row; int[6] - 1 if is absolute second column; int[7] - 1 if is absolute second row;

    • IsUnsignedInteger

      public const bool IsUnsignedInteger​(System.String sValue)
      Returns true if the sValue represents an unsigned integer value.
      Parameters:
      sValue - the value to be checked
      Returns:
      true if the value represents an unsigned integer value.

    • getTokens

      public const List getTokens​(System.String formula)
      Returns a list of tokens after parsing a formula definition
      Parameters:
      formula - the formula to be parsed
      Returns:
      a list of string tokens