Special formulas

Jexcel runs excel-like formulas, and a few special formulas area available to support a better use of this feature.


1

Custom jExcel Methods

MethodExample
=PROGRESS(int, string) Create a progressbar
@Param int percent - Value from 0-100
@Param string color - Hex color for the progressbar
Example
=RATING(int) Create a start rating based on a integer
@Param int value - Rate value from 0-5
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