Package | Description |
---|---|
net.sf.jett.expression |
Provides the classes necessary for JETT to interface to JEXL and evaluate
Expressions . |
net.sf.jett.tag |
Provides Tag functionality, including the
Tag interface and
all built-in tag classes, plus the TagLibrary interface and
TagLibraryRegistry classes for custom tag creation and
registration. |
net.sf.jett.transform |
Provides the classes and API necessary to transform pre-existing Excel
template spreadsheets (.xls and .xlsx are supported) into new spreadsheets
that are fully populated with user data.
|
net.sf.jett.util |
Provides utility functionality for JETT.
|
Modifier and Type | Method | Description |
---|---|---|
static java.util.List<java.lang.String> |
Expression.getImplicitCollectionExpr(java.lang.String value,
java.util.Map<java.lang.String,java.lang.Object> beans,
WorkbookContext context) |
Determines whether a string representing an
Expression
represents implicit Collections access, which would result in an implicit
collections processing loop. |
java.lang.String |
Expression.getValueIndicatingImplicitCollection(java.util.Map<java.lang.String,java.lang.Object> beans,
WorkbookContext context) |
Determines whether this represents implicit Collections access, which
would result in an implicit collections processing loop.
|
Modifier and Type | Method | Description |
---|---|---|
WorkbookContext |
BaseTag.getWorkbookContext() |
Returns the
WorkbookContext to which the Tag is
associated. |
WorkbookContext |
Tag.getWorkbookContext() |
Returns the
WorkbookContext to which the Tag is
associated. |
Modifier and Type | Method | Description |
---|---|---|
Tag |
TagLibraryRegistry.createTag(TagParser parser,
TagContext context,
WorkbookContext workbookContext) |
Creates a
Tag , looking in a specific namespace for a class
matching a specific tag name. |
void |
BaseTag.setWorkbookContext(WorkbookContext context) |
Sets the
WorkbookContext to which the Tag is
associated. |
void |
Tag.setWorkbookContext(WorkbookContext context) |
Sets the
WorkbookContext to which the Tag is
associated. |
Modifier and Type | Method | Description |
---|---|---|
WorkbookContext |
ExcelTransformer.createContext(org.apache.poi.ss.usermodel.Workbook workbook,
SheetTransformer transformer) |
Creates a
WorkbookContext for a Workbook . |
WorkbookContext |
ExcelTransformer.createContext(org.apache.poi.ss.usermodel.Workbook workbook,
SheetTransformer transformer,
java.util.List<java.lang.String> templateSheetNames,
java.util.List<java.lang.String> sheetNames,
java.util.List<java.util.Map<java.lang.String,java.lang.Object>> beansMaps) |
Creates a
WorkbookContext for a Workbook . |
Modifier and Type | Method | Description |
---|---|---|
void |
SheetTransformer.replaceFormulas(org.apache.poi.ss.usermodel.Sheet sheet,
WorkbookContext context) |
Replace all
Formulas found in the given Sheet
with Excel formulas. |
java.util.Map<java.lang.String,java.lang.Object> |
SheetCloner.setupForImplicitCloning(org.apache.poi.ss.usermodel.Sheet sheet,
java.util.Map<java.lang.String,java.lang.Object> beans,
WorkbookContext context) |
Performs all manipulation necessary for implicit cloning, so that the
SheetTransformer can transform the resultant sheets as if
they were already there. |
void |
BlockTransformer.transform(TagContext context,
WorkbookContext workbookContext) |
Transforms the given
Sheet , using the given Map
of bean names to bean objects. |
void |
BlockTransformer.transform(TagContext context,
WorkbookContext workbookContext,
boolean process) |
Transforms the given
Sheet , using the given Map
of bean names to bean objects. |
boolean |
CellTransformer.transform(org.apache.poi.ss.usermodel.Cell cell,
WorkbookContext workbookContext,
TagContext cellContext) |
Transforms the given
Cell , using the given Map
of bean names to bean objects. |
void |
CollectionsTransformer.transform(org.apache.poi.ss.usermodel.Cell cell,
WorkbookContext workbookContext,
TagContext cellContext) |
Transform a
Block of Cells around the given
Cell , which has declared implicit collection processing
behavior using the given collection expression. |
void |
SheetTransformer.transform(org.apache.poi.ss.usermodel.Sheet sheet,
WorkbookContext context,
java.util.Map<java.lang.String,java.lang.Object> beans) |
Transforms the given
Sheet , using the given Map
of bean names to bean objects. |
void |
SheetTransformer.transform(org.apache.poi.ss.usermodel.Sheet sheet,
WorkbookContext context,
java.util.Map<java.lang.String,java.lang.Object> beans,
SheetCloner cloner) |
Transforms the given
Sheet , using the given Map
of bean names to bean objects. |
Modifier and Type | Method | Description |
---|---|---|
static void |
FormulaUtil.addSheetNameRefsAfterClone(WorkbookContext context,
java.lang.String origSheetName,
java.lang.String newSheetName,
int clonePos) |
After a sheet has been implicitly cloned, there is a sheet that is
unaccounted for in the template sheet names, new sheet names, the formula
map, and the cell ref map.
|
static void |
SheetUtil.clearBlock(org.apache.poi.ss.usermodel.Sheet sheet,
Block block,
WorkbookContext context) |
Blanks out all
Cells found inside the given
Block on the given Sheet . |
static Block |
SheetUtil.copyBlock(org.apache.poi.ss.usermodel.Sheet sheet,
TagContext tagContext,
Block block,
WorkbookContext context,
int numBlocksAway) |
Copies an entire
Block the given number of blocks away on
the given Sheet . |
static void |
FormulaUtil.copyCellReferencesInRange(java.lang.String sheetName,
WorkbookContext context,
int left,
int right,
int top,
int bottom,
int numCols,
int numRows,
java.lang.String currSuffix,
java.lang.String newSuffix) |
Copies cell references that are on the same
Sheet in the
given cell reference map by the given number of rows and/or columns
(usually one of those two will be zero). |
static java.lang.String |
FormulaUtil.createExcelFormulaString(java.lang.String formulaText,
Formula formula,
java.lang.String sheetName,
WorkbookContext context) |
Replaces cell references in the given formula text with the translated
cell references, and returns the formula string.
|
static java.lang.String |
FormulaUtil.createExcelFormulaString(Formula formula,
java.lang.String sheetName,
WorkbookContext context) |
Replaces cell references in the given formula text with the translated
cell references, and returns the formula string.
|
static void |
SheetUtil.deleteBlock(org.apache.poi.ss.usermodel.Sheet sheet,
TagContext tagContext,
Block block,
WorkbookContext context) |
Removes all
Cells found inside the given Block
on the given Sheet . |
static void |
SheetUtil.removeBlock(org.apache.poi.ss.usermodel.Sheet sheet,
TagContext tagContext,
Block block,
WorkbookContext context) |
Removes the given
Block of Cells from the given
Sheet . |
static void |
FormulaUtil.replaceSheetNameRefs(WorkbookContext context,
java.lang.String oldSheetName,
java.lang.String newSheetName) |
When a
Sheet is renamed, then this updates all
CellRefs in the cell reference map need to be updated too. |
static java.lang.Object |
SheetUtil.setCellValue(WorkbookContext context,
org.apache.poi.ss.usermodel.Cell cell,
java.lang.Object value) |
Sets the cell value on the given
Cell to the given
value , regardless of data type. |
static java.lang.Object |
SheetUtil.setCellValue(WorkbookContext context,
org.apache.poi.ss.usermodel.Cell cell,
java.lang.Object value,
org.apache.poi.ss.usermodel.RichTextString origRichString) |
Sets the cell value on the given
Cell to the given
value , regardless of data type. |
static void |
FormulaUtil.shiftCellReferencesInRange(java.lang.String sheetName,
WorkbookContext context,
int left,
int right,
int top,
int bottom,
int numCols,
int numRows,
boolean remove,
boolean add) |
Shifts all
CellRefs that are in range and on the same
Sheet by the given number of rows and/or columns (usually
one of those two will be zero). |
static void |
SheetUtil.shiftForBlock(org.apache.poi.ss.usermodel.Sheet sheet,
TagContext tagContext,
Block block,
WorkbookContext context,
int numBlocksAway) |
Shifts
Cells out of the way. |
static void |
FormulaUtil.updateSheetNameRefsAfterClone(WorkbookContext context) |
After sheets have been cloned, all sheets could have been renamed,
leaving the situation where in the cell ref map, all cell keys are of the
new sheet names, but the
CellRefs still refer to the
template sheet names. |
Copyright © 2012–2018 Jett Team. All rights reserved.