corpus.excel.parser
Class CellReferenceParser

java.lang.Object
  |
  +--corpus.excel.parser.FormulaComponentParser
        |
        +--corpus.excel.parser.CellReferenceParser

public class CellReferenceParser

extends FormulaComponentParser

A parser for a formula component.

See Also:

CellReference

Field Summary

static java.lang.String	COL_PATTERN Useg with GNU regular expressions to recoginse a cells column component.
static java.lang.String	PATTERN The complete pattern for recognising a cell reference in a formula.
static java.lang.String	ROW_PATTERN Recognises 1 to 5 digits.

Constructor Summary

CellReferenceParser()

Method Summary

FormulaComponent

parseOne(java.lang.String input, Formula formula) Given a string containing a Excel formula, break it down into components.

Methods inherited from class java.lang.Object

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

Field Detail

COL_PATTERN

public static final java.lang.String COL_PATTERN

Useg with GNU regular expressions to recoginse a cells column component. I.e. A, AA, AB, IV.

See Also:

Constant Field Values

ROW_PATTERN

public static final java.lang.String ROW_PATTERN

Recognises 1 to 5 digits. The Row pattern

See Also:

Constant Field Values

PATTERN

public static final java.lang.String PATTERN

The complete pattern for recognising a cell reference in a formula.

See Also:

Constant Field Values

Constructor Detail

CellReferenceParser

public CellReferenceParser()

Method Detail

parseOne

public FormulaComponent parseOne(java.lang.String input,
                                 Formula formula)

Given a string containing a Excel formula, break it down into components.

Specified by:

parseOne in class FormulaComponentParser

Returns:

A FormulaComponent