Special formulas

Jexcel runs excel-like formulas, and a few special formulas are available to help relative calculations.

Method Example
=TABLE() Return the jexcel table instance
=COLUMN() Return the column number where the formula has been executed
=ROW() Return the row number where the formula has been executed
=CELL() Return the cell string identification
=VALUE(int, int) Return the cell value based on the colNumber and rowNumber

Click here to see an example