Package | Description |
---|---|
org.apache.poi.hssf.model |
Provides low level API structures for reading, writing, modifying XLS files.
|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.ss.formula.eval.forked | |
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.util | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel |
Modifier and Type | Method and Description |
---|---|
int |
InternalWorkbook.linkExternalWorkbook(java.lang.String name,
Workbook externalWorkbook) |
Modifier and Type | Class and Description |
---|---|
class |
HSSFWorkbook
High level representation of a workbook.
|
Modifier and Type | Method and Description |
---|---|
static void |
HSSFFormulaEvaluator.evaluateAllFormulaCells(Workbook wb)
Loops over all cells in all sheets of the supplied
workbook.
|
java.lang.String |
HSSFCellStyle.getDataFormatString(Workbook workbook)
Get the contents of the format string, by looking up
the DataFormat against the supplied workbook
|
HSSFFont |
HSSFCellStyle.getFont(Workbook parentWorkbook)
gets the font for this style
|
int |
HSSFWorkbook.linkExternalWorkbook(java.lang.String name,
Workbook workbook)
Adds the LinkTable records required to allow formulas referencing
the specified external workbook to be added to this one.
|
Modifier and Type | Method and Description |
---|---|
void |
ForkedEvaluator.copyUpdatedCells(Workbook workbook)
Copies the values of all updated cells (modified by calls to
ForkedEvaluator.updateCell(String, int, int, ValueEval) ) to the supplied workbook.Typically, the supplied workbook is a writable copy of the 'master workbook', but at the very least it must contain sheets with the same names. |
static ForkedEvaluator |
ForkedEvaluator.create(Workbook wb,
IStabilityClassifier stabilityClassifier)
Deprecated.
(Sep 2009) (reduce overloading) use
ForkedEvaluator.create(Workbook, IStabilityClassifier, UDFFinder) |
static ForkedEvaluator |
ForkedEvaluator.create(Workbook wb,
IStabilityClassifier stabilityClassifier,
UDFFinder udfFinder) |
Modifier and Type | Method and Description |
---|---|
static Workbook |
WorkbookFactory.create(java.io.File file)
Creates the appropriate HSSFWorkbook / XSSFWorkbook from
the given File, which must exist and be readable.
|
static Workbook |
WorkbookFactory.create(java.io.File file,
java.lang.String password)
Creates the appropriate HSSFWorkbook / XSSFWorkbook from
the given File, which must exist and be readable, and
may be password protected
|
static Workbook |
WorkbookFactory.create(java.io.InputStream inp)
Creates the appropriate HSSFWorkbook / XSSFWorkbook from
the given InputStream.
|
static Workbook |
WorkbookFactory.create(java.io.InputStream inp,
java.lang.String password)
Creates the appropriate HSSFWorkbook / XSSFWorkbook from
the given InputStream, which may be password protected.
|
static Workbook |
WorkbookFactory.create(NPOIFSFileSystem fs)
Creates a HSSFWorkbook from the given NPOIFSFileSystem
|
static Workbook |
WorkbookFactory.create(OPCPackage pkg)
Creates a XSSFWorkbook from the given OOXML Package
|
static Workbook |
WorkbookFactory.create(POIFSFileSystem fs)
Creates a HSSFWorkbook from the given POIFSFileSystem
|
Workbook |
Sheet.getWorkbook()
Return the parent workbook
|
Modifier and Type | Method and Description |
---|---|
int |
Workbook.linkExternalWorkbook(java.lang.String name,
Workbook workbook)
Adds the linking required to allow formulas referencing
the specified external workbook to be added to this one.
|
Modifier and Type | Method and Description |
---|---|
static void |
CellUtil.setAlignment(Cell cell,
Workbook workbook,
short align)
Take a cell, and align it.
|
static void |
RegionUtil.setBorderBottom(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the borderBottom attribute of the RegionUtil object
|
static void |
RegionUtil.setBorderLeft(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the left border for a region of cells by manipulating the cell style of the individual
cells on the left
|
static void |
RegionUtil.setBorderRight(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the borderRight attribute of the RegionUtil object
|
static void |
RegionUtil.setBorderTop(int border,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the borderBottom attribute of the RegionUtil object
|
static void |
RegionUtil.setBottomBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the bottomBorderColor attribute of the RegionUtil object
|
static void |
CellUtil.setCellStyleProperty(Cell cell,
Workbook workbook,
java.lang.String propertyName,
java.lang.Object propertyValue)
This method attempt to find an already existing CellStyle that matches what you want the
style to be.
|
static void |
CellUtil.setFont(Cell cell,
Workbook workbook,
Font font)
Take a cell, and apply a font to it
|
static void |
RegionUtil.setLeftBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the leftBorderColor attribute of the RegionUtil object
|
static void |
RegionUtil.setRightBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the rightBorderColor attribute of the RegionUtil object
|
static void |
RegionUtil.setTopBorderColor(int color,
CellRangeAddress region,
Sheet sheet,
Workbook workbook)
Sets the topBorderColor attribute of the RegionUtil object
|
Constructor and Description |
---|
SheetBuilder(Workbook workbook,
java.lang.Object[][] cells) |
Modifier and Type | Class and Description |
---|---|
class |
SXSSFWorkbook
Streaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.
|
Modifier and Type | Method and Description |
---|---|
Workbook |
SXSSFSheet.getWorkbook()
Return the parent workbook
|
Modifier and Type | Method and Description |
---|---|
int |
SXSSFWorkbook.linkExternalWorkbook(java.lang.String name,
Workbook workbook)
Adds the LinkTable records required to allow formulas referencing
the specified external workbook to be added to this one.
|
Modifier and Type | Class and Description |
---|---|
class |
XSSFWorkbook
High level representation of a SpreadsheetML workbook.
|
Modifier and Type | Method and Description |
---|---|
int |
XSSFWorkbook.linkExternalWorkbook(java.lang.String name,
Workbook workbook)
Adds the External Link Table part and relations required to allow formulas
referencing the specified external workbook to be added to this one.
|
Copyright 2015 The Apache Software Foundation or its licensors, as applicable.