Package | Description |
---|---|
org.apache.poi.hssf.model |
Provides low level API structures for reading, writing, modifying XLS files.
|
org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
org.apache.poi.poifs.crypt.temp | |
org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.apache.poi.ss.formula.eval.forked | |
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.util | |
org.apache.poi.util |
Top-level util package are classes that are useful throughout the project.
|
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 | Class and Description |
---|---|
class |
SXSSFWorkbookWithCustomZipEntrySource |
Modifier and Type | Method and Description |
---|---|
static void |
BaseFormulaEvaluator.evaluateAllFormulaCells(Workbook wb)
Loops over all cells in all sheets of the supplied
workbook.
|
protected static void |
BaseFormulaEvaluator.evaluateAllFormulaCells(Workbook wb,
FormulaEvaluator evaluator) |
Constructor and Description |
---|
ConditionalFormattingEvaluator(Workbook wb,
WorkbookEvaluatorProvider provider) |
DataValidationEvaluator(Workbook wb,
WorkbookEvaluatorProvider provider)
Use the same formula evaluation context used for other operations, so cell value
changes are automatically noticed
|
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,
UDFFinder udfFinder) |
Modifier and Type | Method and Description |
---|---|
Workbook |
WorkbookFactory.CreateWorkbook0.apply() |
Workbook |
WorkbookFactory.CreateWorkbook1.apply(T t) |
Workbook |
WorkbookFactory.CreateWorkbook2.apply(T t,
U u) |
static Workbook |
WorkbookFactory.create(boolean xssf)
Create a new empty Workbook, either XSSF or HSSF depending
on the parameter
|
static Workbook |
WorkbookFactory.create(DirectoryNode root)
Creates a Workbook from the given DirectoryNode.
|
static Workbook |
WorkbookFactory.create(DirectoryNode root,
java.lang.String password)
Creates a Workbook from the given DirectoryNode, which may
be password protected
|
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.File file,
java.lang.String password,
boolean readOnly)
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(java.lang.Object pkg)
Deprecated.
use
WorkbookFactory.create(File) , WorkbookFactory.create(InputStream) or
XSSFWorkbookFactory.create(OPCPackage) instead. |
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 int |
SheetUtil.getDefaultCharWidth(Workbook wb)
Get default character width using the Workbook's default font
|
Constructor and Description |
---|
SheetBuilder(Workbook workbook,
java.lang.Object[][] cells) |
Modifier and Type | Method and Description |
---|---|
static void |
IOUtils.write(Workbook doc,
java.io.OutputStream out)
Deprecated.
since 4.0, use try-with-resources, will be removed in 4.2
|
static void |
IOUtils.writeAndClose(Workbook doc,
java.io.OutputStream out)
Deprecated.
since 4.0, use try-with-resources, will be removed in 4.2
|
Modifier and Type | Class and Description |
---|---|
class |
SXSSFWorkbook
Streaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.
|
Modifier and Type | Method and Description |
---|---|
int |
SXSSFWorkbook.linkExternalWorkbook(java.lang.String name,
Workbook workbook)
Not implemented for SXSSFWorkbook
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 |
---|---|
AreaReference |
XSSFPivotCacheDefinition.getPivotArea(Workbook wb)
Find the 2D base data area for the pivot table, either from its direct reference or named table/range.
|
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 2020 The Apache Software Foundation or its licensors, as applicable.