Command defines a transformation applied to the associated XLS Area.
Jxls uses the following Command interface to represent the command.
public interface Command {
String getName(); // command name
List<Area> getAreaList(); // list of command areas
Command addArea(Area area); // adds an Area to the command
Size applyAt(CellRef cellRef, Context context); // applies the command at given cell and context
void reset(); // resets command data for repeatable command usage
// the next two commands operate on a cell shift mode for the command
// shift mode currently can take 2 values Command.INNER_SHIFT_MODE (default) and Command.ADJACENT_SHIFT_MODE
void setShiftMode(String mode);
String getShiftMode();
}
Every command has a name and Area list.
The name defines the command name which is used to refer to the command in Excel or XML markup.
The Area list is a list of command parameters of Area type.
There are 3 built-in commands in Jxls
Each-Command - for object collection iteration
If-Command - for conditional output
Image-Command - for image output
It is easy to create your own commands.
An example of creating a custom command can be found in Custom command example