Package | Description |
---|---|
org.jxls.area | |
org.jxls.builder.xls | |
org.jxls.command | |
org.jxls.common | |
org.jxls.common.cellshift | |
org.jxls.formula | |
org.jxls.transform | |
org.jxls.util |
Modifier and Type | Method and Description |
---|---|
CellRef |
CommandData.getSourceStartCellRef() |
CellRef |
CommandData.getSourceStartCellRef() |
CellRef |
Area.getStartCellRef() |
CellRef |
CommandData.getStartCellRef() |
CellRef |
XlsArea.getStartCellRef() |
CellRef |
XlsArea.getStartCellRef() |
CellRef |
CommandData.getStartCellRef() |
CellRef |
Area.getStartCellRef() |
Modifier and Type | Method and Description |
---|---|
Size |
Area.applyAt(CellRef cellRef,
Context context) |
Size |
XlsArea.applyAt(CellRef cellRef,
Context context) |
Size |
XlsArea.applyAt(CellRef cellRef,
Context context) |
Size |
Area.applyAt(CellRef cellRef,
Context context) |
void |
CommandData.setSourceStartCellRef(CellRef sourceStartCellRef) |
void |
CommandData.setSourceStartCellRef(CellRef sourceStartCellRef) |
void |
CommandData.setStartCellRef(CellRef startCellRef) |
void |
CommandData.setStartCellRef(CellRef startCellRef) |
Constructor and Description |
---|
CommandData(CellRef startCellRef,
Size size,
Command command) |
CommandData(CellRef startCellRef,
Size size,
Command command) |
XlsArea(CellRef startCell,
CellRef endCell,
Transformer transformer) |
XlsArea(CellRef startCell,
CellRef endCell,
Transformer transformer) |
XlsArea(CellRef startCellRef,
Size size) |
XlsArea(CellRef startCellRef,
Size size) |
XlsArea(CellRef startCellRef,
Size size,
List<CommandData> commandDataList,
Transformer transformer) |
XlsArea(CellRef startCellRef,
Size size,
List<CommandData> commandDataList,
Transformer transformer) |
XlsArea(CellRef startCellRef,
Size size,
Transformer transformer) |
XlsArea(CellRef startCellRef,
Size size,
Transformer transformer) |
Modifier and Type | Method and Description |
---|---|
Size |
AreaCommand.applyAt(CellRef cellRef,
Context context) |
Size |
AreaCommand.applyAt(CellRef cellRef,
Context context) |
Modifier and Type | Method and Description |
---|---|
CellRef |
CellRefGenerator.generateCellRef(int index,
Context context) |
CellRef |
DynamicSheetNameGenerator.generateCellRef(int index,
Context context) |
CellRef |
SheetNameGenerator.generateCellRef(int index,
Context context) |
CellRef |
SheetNameGenerator.generateCellRef(int index,
Context context) |
CellRef |
DynamicSheetNameGenerator.generateCellRef(int index,
Context context) |
CellRef |
CellRefGenerator.generateCellRef(int index,
Context context) |
Modifier and Type | Method and Description |
---|---|
Size |
Command.applyAt(CellRef cellRef,
Context context)
Applies a command at the given cell reference
|
Size |
EachCommand.applyAt(CellRef cellRef,
Context context) |
Size |
GridCommand.applyAt(CellRef cellRef,
Context context) |
Size |
IfCommand.applyAt(CellRef cellRef,
Context context) |
Size |
ImageCommand.applyAt(CellRef cellRef,
Context context) |
Size |
MergeCellsCommand.applyAt(CellRef cellRef,
Context context) |
Size |
UpdateCellCommand.applyAt(CellRef cellRef,
Context context) |
Size |
UpdateCellCommand.applyAt(CellRef cellRef,
Context context) |
Size |
MergeCellsCommand.applyAt(CellRef cellRef,
Context context) |
Size |
ImageCommand.applyAt(CellRef cellRef,
Context context) |
Size |
IfCommand.applyAt(CellRef cellRef,
Context context) |
Size |
GridCommand.applyAt(CellRef cellRef,
Context context) |
Size |
EachCommand.applyAt(CellRef cellRef,
Context context) |
Size |
Command.applyAt(CellRef cellRef,
Context context)
Applies a command at the given cell reference
|
void |
CellDataUpdater.updateCellData(CellData cellData,
CellRef targetCell,
Context context) |
void |
CellDataUpdater.updateCellData(CellData cellData,
CellRef targetCell,
Context context) |
Constructor and Description |
---|
DynamicSheetNameGenerator(String sheetNameExpression,
CellRef startCellRef,
ExpressionEvaluator expressionEvaluator) |
DynamicSheetNameGenerator(String sheetNameExpression,
CellRef startCellRef,
ExpressionEvaluator expressionEvaluator) |
SheetNameGenerator(List<String> sheetNames,
CellRef startCellRef) |
SheetNameGenerator(List<String> sheetNames,
CellRef startCellRef) |
Modifier and Type | Field and Description |
---|---|
protected CellRef |
CellData.cellRef |
protected CellRef |
CellData.cellRef |
Modifier and Type | Method and Description |
---|---|
CellRef |
CellRange.getCell(int row,
int col) |
CellRef |
CellRange.getCell(int row,
int col) |
CellRef |
CellData.getCellRef() |
CellRef |
CellData.getCellRef() |
CellRef |
AreaRef.getFirstCellRef() |
CellRef |
AreaRef.getFirstCellRef() |
CellRef |
AreaRef.getLastCellRef() |
CellRef |
AreaRef.getLastCellRef() |
CellRef |
CellRef.setCol(int col) |
CellRef |
CellRef.setCol(int col) |
CellRef |
CellRef.setIgnoreSheetNameInFormat(boolean ignoreSheetNameInFormat) |
CellRef |
CellRef.setIgnoreSheetNameInFormat(boolean ignoreSheetNameInFormat) |
CellRef |
CellRef.setIsColAbs(boolean isColAbs) |
CellRef |
CellRef.setIsColAbs(boolean isColAbs) |
CellRef |
CellRef.setIsRowAbs(boolean isRowAbs) |
CellRef |
CellRef.setIsRowAbs(boolean isRowAbs) |
CellRef |
CellRef.setRow(int row) |
CellRef |
CellRef.setRow(int row) |
CellRef |
CellRef.setSheetName(String sheetName) |
CellRef |
CellRef.setSheetName(String sheetName) |
Modifier and Type | Method and Description |
---|---|
List<CellRef> |
CellData.getTargetPos() |
List<CellRef> |
CellData.getTargetPos() |
Modifier and Type | Method and Description |
---|---|
boolean |
CellData.addTargetPos(CellRef cellRef) |
boolean |
CellData.addTargetPos(CellRef cellRef) |
void |
AreaListener.afterApplyAtCell(CellRef cellRef,
Context context) |
void |
AreaListener.afterApplyAtCell(CellRef cellRef,
Context context) |
void |
AreaListener.afterTransformCell(CellRef srcCell,
CellRef targetCell,
Context context) |
void |
AreaListener.afterTransformCell(CellRef srcCell,
CellRef targetCell,
Context context) |
void |
AreaListener.beforeApplyAtCell(CellRef cellRef,
Context context) |
void |
AreaListener.beforeApplyAtCell(CellRef cellRef,
Context context) |
void |
AreaListener.beforeTransformCell(CellRef srcCell,
CellRef targetCell,
Context context) |
void |
AreaListener.beforeTransformCell(CellRef srcCell,
CellRef targetCell,
Context context) |
int |
CellRefColPrecedenceComparator.compare(CellRef cellRef1,
CellRef cellRef2) |
int |
CellRefRowPrecedenceComparator.compare(CellRef cellRef1,
CellRef cellRef2) |
int |
CellRefRowPrecedenceComparator.compare(CellRef cellRef1,
CellRef cellRef2) |
int |
CellRefColPrecedenceComparator.compare(CellRef cellRef1,
CellRef cellRef2) |
int |
CellRef.compareTo(CellRef that) |
int |
CellRef.compareTo(CellRef that) |
boolean |
AreaRef.contains(CellRef cellRef) |
boolean |
AreaRef.contains(CellRef cellRef) |
boolean |
CellRange.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
boolean |
CellRange.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
Constructor and Description |
---|
AreaRef(CellRef firstCellRef,
CellRef lastCellRef) |
AreaRef(CellRef firstCellRef,
CellRef lastCellRef) |
AreaRef(CellRef cellRef,
Size size) |
AreaRef(CellRef cellRef,
Size size) |
CellData(CellRef cellRef) |
CellData(CellRef cellRef) |
CellData(CellRef cellRef,
CellData.CellType cellType,
Object cellValue) |
CellData(CellRef cellRef,
CellData.CellType cellType,
Object cellValue) |
CellRange(CellRef startCell,
int width,
int height) |
CellRange(CellRef startCell,
int width,
int height) |
Modifier and Type | Method and Description |
---|---|
boolean |
AdjacentCellShiftStrategy.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
boolean |
CellShiftStrategy.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
boolean |
InnerCellShiftStrategy.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
boolean |
InnerCellShiftStrategy.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
boolean |
CellShiftStrategy.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
boolean |
AdjacentCellShiftStrategy.requiresColShifting(CellRef cell,
int startRow,
int endRow,
int startColShift) |
boolean |
AdjacentCellShiftStrategy.requiresRowShifting(CellRef cell,
int startCol,
int endCol,
int startRowShift) |
boolean |
CellShiftStrategy.requiresRowShifting(CellRef cell,
int startCol,
int endCol,
int startRowShift) |
boolean |
InnerCellShiftStrategy.requiresRowShifting(CellRef cell,
int startCol,
int endCol,
int startRowShift) |
boolean |
InnerCellShiftStrategy.requiresRowShifting(CellRef cell,
int startCol,
int endCol,
int startRowShift) |
boolean |
CellShiftStrategy.requiresRowShifting(CellRef cell,
int startCol,
int endCol,
int startRowShift) |
boolean |
AdjacentCellShiftStrategy.requiresRowShifting(CellRef cell,
int startCol,
int endCol,
int startRowShift) |
Modifier and Type | Method and Description |
---|---|
protected Map<String,List<CellRef>> |
AbstractFormulaProcessor.buildJointedCellRefMap(Transformer transformer,
CellData formulaCellData) |
protected Map<String,List<CellRef>> |
AbstractFormulaProcessor.buildJointedCellRefMap(Transformer transformer,
CellData formulaCellData) |
protected Map<CellRef,List<CellRef>> |
AbstractFormulaProcessor.buildTargetCellRefMap(Transformer transformer,
Area area,
CellData formulaCellData) |
protected Map<CellRef,List<CellRef>> |
AbstractFormulaProcessor.buildTargetCellRefMap(Transformer transformer,
Area area,
CellData formulaCellData) |
protected Map<CellRef,List<CellRef>> |
AbstractFormulaProcessor.buildTargetCellRefMap(Transformer transformer,
Area area,
CellData formulaCellData) |
protected Map<CellRef,List<CellRef>> |
AbstractFormulaProcessor.buildTargetCellRefMap(Transformer transformer,
Area area,
CellData formulaCellData) |
Modifier and Type | Method and Description |
---|---|
List<CellRef> |
AbstractTransformer.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
Transformer.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
TransformerDelegator.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
TransformerDelegator.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
Transformer.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
AbstractTransformer.getTargetCellRef(CellRef cellRef) |
Modifier and Type | Method and Description |
---|---|
void |
AbstractTransformer.adjustTableSize(CellRef ref,
Size size) |
void |
Transformer.adjustTableSize(CellRef ref,
Size size) |
void |
TransformerDelegator.adjustTableSize(CellRef ref,
Size size) |
void |
TransformerDelegator.adjustTableSize(CellRef ref,
Size size) |
void |
Transformer.adjustTableSize(CellRef ref,
Size size) |
void |
AbstractTransformer.adjustTableSize(CellRef ref,
Size size) |
void |
Transformer.clearCell(CellRef cellRef) |
void |
TransformerDelegator.clearCell(CellRef cellRef) |
void |
TransformerDelegator.clearCell(CellRef cellRef) |
void |
Transformer.clearCell(CellRef cellRef) |
CellData |
AbstractTransformer.getCellData(CellRef cellRef) |
CellData |
Transformer.getCellData(CellRef cellRef) |
CellData |
TransformerDelegator.getCellData(CellRef cellRef) |
CellData |
TransformerDelegator.getCellData(CellRef cellRef) |
CellData |
Transformer.getCellData(CellRef cellRef) |
CellData |
AbstractTransformer.getCellData(CellRef cellRef) |
List<CellRef> |
AbstractTransformer.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
Transformer.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
TransformerDelegator.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
TransformerDelegator.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
Transformer.getTargetCellRef(CellRef cellRef) |
List<CellRef> |
AbstractTransformer.getTargetCellRef(CellRef cellRef) |
void |
AbstractTransformer.mergeCells(CellRef ref,
int rows,
int cols) |
void |
Transformer.mergeCells(CellRef ref,
int rows,
int cols) |
void |
TransformerDelegator.mergeCells(CellRef ref,
int rows,
int cols) |
void |
TransformerDelegator.mergeCells(CellRef ref,
int rows,
int cols) |
void |
Transformer.mergeCells(CellRef ref,
int rows,
int cols) |
void |
AbstractTransformer.mergeCells(CellRef ref,
int rows,
int cols) |
void |
Transformer.setFormula(CellRef cellRef,
String formulaString) |
void |
TransformerDelegator.setFormula(CellRef cellRef,
String formulaString) |
void |
TransformerDelegator.setFormula(CellRef cellRef,
String formulaString) |
void |
Transformer.setFormula(CellRef cellRef,
String formulaString) |
void |
Transformer.transform(CellRef srcCellRef,
CellRef targetCellRef,
Context context,
boolean updateRowHeight) |
void |
TransformerDelegator.transform(CellRef srcCellRef,
CellRef targetCellRef,
Context context,
boolean updateRowHeight) |
void |
TransformerDelegator.transform(CellRef srcCellRef,
CellRef targetCellRef,
Context context,
boolean updateRowHeight) |
void |
Transformer.transform(CellRef srcCellRef,
CellRef targetCellRef,
Context context,
boolean updateRowHeight) |
Modifier and Type | Method and Description |
---|---|
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
static List<List<CellRef>> |
Util.groupByColRange(List<CellRef> cellRefList)
Groups a list of cell references in a column into a list of ranges
|
List<List<CellRef>> |
UtilWrapper.groupByColRange(List<CellRef> cellRefList) |
List<List<CellRef>> |
UtilWrapper.groupByColRange(List<CellRef> cellRefList) |
static List<List<CellRef>> |
Util.groupByColRange(List<CellRef> cellRefList)
Groups a list of cell references in a column into a list of ranges
|
static List<List<CellRef>> |
Util.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount)
Groups a list of cell references into a list ranges which can be used in a formula substitution
|
List<List<CellRef>> |
UtilWrapper.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount) |
List<List<CellRef>> |
UtilWrapper.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount) |
static List<List<CellRef>> |
Util.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount)
Groups a list of cell references into a list ranges which can be used in a formula substitution
|
static List<List<CellRef>> |
Util.groupByRowRange(List<CellRef> cellRefList)
Groups a list of cell references in a row into a list of ranges
|
List<List<CellRef>> |
UtilWrapper.groupByRowRange(List<CellRef> cellRefList) |
List<List<CellRef>> |
UtilWrapper.groupByRowRange(List<CellRef> cellRefList) |
static List<List<CellRef>> |
Util.groupByRowRange(List<CellRef> cellRefList)
Groups a list of cell references in a row into a list of ranges
|
Modifier and Type | Method and Description |
---|---|
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
Modifier and Type | Method and Description |
---|---|
static String |
Util.createTargetCellRef(List<CellRef> targetCellDataList)
Combines a list of cell references into a range
E.g.
|
String |
UtilWrapper.createTargetCellRef(List<CellRef> targetCellDataList) |
String |
UtilWrapper.createTargetCellRef(List<CellRef> targetCellDataList) |
static String |
Util.createTargetCellRef(List<CellRef> targetCellDataList)
Combines a list of cell references into a range
E.g.
|
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
List<CellRef> |
UtilWrapper.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude) |
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
static List<CellRef> |
Util.createTargetCellRefListByColumn(CellRef targetFormulaCellRef,
List<CellRef> targetCells,
List<CellRef> cellRefsToExclude)
Creates a list of target formula cell references
|
static List<List<CellRef>> |
Util.groupByColRange(List<CellRef> cellRefList)
Groups a list of cell references in a column into a list of ranges
|
List<List<CellRef>> |
UtilWrapper.groupByColRange(List<CellRef> cellRefList) |
List<List<CellRef>> |
UtilWrapper.groupByColRange(List<CellRef> cellRefList) |
static List<List<CellRef>> |
Util.groupByColRange(List<CellRef> cellRefList)
Groups a list of cell references in a column into a list of ranges
|
static List<List<CellRef>> |
Util.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount)
Groups a list of cell references into a list ranges which can be used in a formula substitution
|
List<List<CellRef>> |
UtilWrapper.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount) |
List<List<CellRef>> |
UtilWrapper.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount) |
static List<List<CellRef>> |
Util.groupByRanges(List<CellRef> cellRefList,
int targetRangeCount)
Groups a list of cell references into a list ranges which can be used in a formula substitution
|
static List<List<CellRef>> |
Util.groupByRowRange(List<CellRef> cellRefList)
Groups a list of cell references in a row into a list of ranges
|
List<List<CellRef>> |
UtilWrapper.groupByRowRange(List<CellRef> cellRefList) |
List<List<CellRef>> |
UtilWrapper.groupByRowRange(List<CellRef> cellRefList) |
static List<List<CellRef>> |
Util.groupByRowRange(List<CellRef> cellRefList)
Groups a list of cell references in a row into a list of ranges
|
static String |
Util.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
static String |
Util.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
String |
UtilWrapper.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
String |
UtilWrapper.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
String |
UtilWrapper.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
String |
UtilWrapper.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
static String |
Util.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
static String |
Util.sheetNameRegex(Map.Entry<CellRef,List<CellRef>> cellRefEntry) |
Copyright © 2023. All rights reserved.