Uses of Interface
org.apache.poi.ss.usermodel.Workbook
-
Packages that use Workbook 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 modelorg.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 -
-
Uses of Workbook in org.apache.poi.hssf.model
Methods in org.apache.poi.hssf.model with parameters of type Workbook Modifier and Type Method Description int
InternalWorkbook. linkExternalWorkbook(java.lang.String name, Workbook externalWorkbook)
-
Uses of Workbook in org.apache.poi.hssf.usermodel
Classes in org.apache.poi.hssf.usermodel that implement Workbook Modifier and Type Class Description class
HSSFWorkbook
High level representation of a workbook.Methods in org.apache.poi.hssf.usermodel with parameters of type Workbook Modifier and Type Method 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 workbookHSSFFont
HSSFCellStyle. getFont(Workbook parentWorkbook)
gets the font for this styleint
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. -
Uses of Workbook in org.apache.poi.poifs.crypt.temp
Classes in org.apache.poi.poifs.crypt.temp that implement Workbook Modifier and Type Class Description class
SXSSFWorkbookWithCustomZipEntrySource
-
Uses of Workbook in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula with parameters of type Workbook Modifier and Type Method 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)
Constructors in org.apache.poi.ss.formula with parameters of type Workbook Constructor 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 -
Uses of Workbook in org.apache.poi.ss.formula.eval.forked
Methods in org.apache.poi.ss.formula.eval.forked with parameters of type Workbook Modifier and Type Method Description void
ForkedEvaluator. copyUpdatedCells(Workbook workbook)
Copies the values of all updated cells (modified by calls toForkedEvaluator.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)
-
Uses of Workbook in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return Workbook Modifier and Type Method Description static Workbook
WorkbookFactory. create(boolean xssf)
Create a new empty Workbook, either XSSF or HSSF depending on the parameterstatic 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 protectedstatic 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 protectedstatic 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 XSSFWorkbookFactory.createstatic Workbook
WorkbookFactory. create(DirectoryNode root)
Creates a Workbook from the given NPOIFSFileSystem.static Workbook
WorkbookFactory. create(DirectoryNode root, java.lang.String password)
Creates a Workbook from the given NPOIFSFileSystem, which may be password protectedstatic Workbook
WorkbookFactory. create(POIFSFileSystem fs)
Creates a HSSFWorkbook from the given NPOIFSFileSystemWorkbook
Sheet. getWorkbook()
Return the parent workbookMethods in org.apache.poi.ss.usermodel with parameters of type Workbook Modifier and Type Method 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. -
Uses of Workbook in org.apache.poi.ss.util
Methods in org.apache.poi.ss.util with parameters of type Workbook Modifier and Type Method Description static int
SheetUtil. getDefaultCharWidth(Workbook wb)
Get default character width using the Workbook's default fontConstructors in org.apache.poi.ss.util with parameters of type Workbook Constructor Description SheetBuilder(Workbook workbook, java.lang.Object[][] cells)
-
Uses of Workbook in org.apache.poi.util
Methods in org.apache.poi.util with parameters of type Workbook Modifier and Type Method Description static void
IOUtils. write(Workbook doc, java.io.OutputStream out)
Deprecated.since 4.0, use try-with-resources, will be removed in 4.2static void
IOUtils. writeAndClose(Workbook doc, java.io.OutputStream out)
Deprecated.since 4.0, use try-with-resources, will be removed in 4.2 -
Uses of Workbook in org.apache.poi.xssf.streaming
Classes in org.apache.poi.xssf.streaming that implement Workbook Modifier and Type Class Description class
SXSSFWorkbook
Streaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming with parameters of type Workbook Modifier and Type Method 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. -
Uses of Workbook in org.apache.poi.xssf.usermodel
Classes in org.apache.poi.xssf.usermodel that implement Workbook Modifier and Type Class Description class
XSSFWorkbook
High level representation of a SpreadsheetML workbook.Methods in org.apache.poi.xssf.usermodel with parameters of type Workbook Modifier and Type Method 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.
-