Uses of Interface
org.apache.poi.ss.usermodel.Workbook
Packages that use Workbook
Package
Description
Provides low level API structures for reading, writing, modifying XLS files.
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains common internal POI code for manipulating formulas.
Top-level util package are classes that are useful throughout the project.
-
Uses of Workbook in org.apache.poi.hssf.model
Methods in org.apache.poi.hssf.model with parameters of type WorkbookModifier and TypeMethodDescriptionint
InternalWorkbook.linkExternalWorkbook
(String name, Workbook externalWorkbook) -
Uses of Workbook in org.apache.poi.hssf.usermodel
Classes in org.apache.poi.hssf.usermodel that implement WorkbookModifier and TypeClassDescriptionfinal class
High level representation of a workbook.Methods in org.apache.poi.hssf.usermodel with parameters of type WorkbookModifier and TypeMethodDescriptionstatic void
HSSFFormulaEvaluator.evaluateAllFormulaCells
(Workbook wb) Loops over all cells in all sheets of the supplied workbook.HSSFCellStyle.getDataFormatString
(Workbook workbook) Get the contents of the format string, by looking up the DataFormat against the supplied workbookgets the font for this styleint
HSSFWorkbook.linkExternalWorkbook
(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 -
Uses of Workbook in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula with parameters of type WorkbookModifier and TypeMethodDescriptionstatic 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 WorkbookModifierConstructorDescriptionConditionalFormattingEvaluator
(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 WorkbookModifier and TypeMethodDescriptionvoid
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 WorkbookModifier and TypeMethodDescriptionstatic Workbook
WorkbookFactory.create
(boolean xssf) Create a new empty Workbook, either XSSF or HSSF depending on the parameterstatic Workbook
Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable.static Workbook
Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable, and may be password protectedstatic Workbook
Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable, and may be password protectedstatic Workbook
WorkbookFactory.create
(InputStream inp) Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given InputStream.static Workbook
WorkbookFactory.create
(InputStream inp, String password) Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given InputStream, which may be password protected.static Workbook
Deprecated.use XSSFWorkbookFactory.createstatic Workbook
WorkbookFactory.create
(DirectoryNode root) Creates a Workbook from the given NPOIFSFileSystem.static Workbook
WorkbookFactory.create
(DirectoryNode root, 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 NPOIFSFileSystemSheet.getWorkbook()
Return the parent workbookMethods in org.apache.poi.ss.usermodel with parameters of type WorkbookModifier and TypeMethodDescriptionint
Workbook.linkExternalWorkbook
(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 WorkbookModifier and TypeMethodDescriptionstatic 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 -
Uses of Workbook in org.apache.poi.util
Methods in org.apache.poi.util with parameters of type WorkbookModifier and TypeMethodDescriptionstatic void
IOUtils.write
(Workbook doc, OutputStream out) Deprecated.since 4.0, use try-with-resources, will be removed in 4.2static void
IOUtils.writeAndClose
(Workbook doc, 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 WorkbookModifier and TypeClassDescriptionclass
Streaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming with parameters of type WorkbookModifier and TypeMethodDescriptionint
SXSSFWorkbook.linkExternalWorkbook
(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 WorkbookModifier and TypeClassDescriptionclass
High level representation of a SpreadsheetML workbook.Methods in org.apache.poi.xssf.usermodel with parameters of type WorkbookModifier and TypeMethodDescriptionXSSFPivotCacheDefinition.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
(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.