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 TypeMethodDescriptionintInternalWorkbook.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 classHigh level representation of a workbook.Methods in org.apache.poi.hssf.usermodel with parameters of type WorkbookModifier and TypeMethodDescriptionstatic voidHSSFFormulaEvaluator.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 styleintHSSFWorkbook.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 voidBaseFormulaEvaluator.evaluateAllFormulaCells(Workbook wb) Loops over all cells in all sheets of the supplied workbook.protected static voidBaseFormulaEvaluator.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 TypeMethodDescriptionvoidForkedEvaluator.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 ForkedEvaluatorForkedEvaluator.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 WorkbookWorkbookFactory.create(boolean xssf) Create a new empty Workbook, either XSSF or HSSF depending on the parameterstatic WorkbookCreates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable.static WorkbookCreates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable, and may be password protectedstatic WorkbookCreates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable, and may be password protectedstatic WorkbookWorkbookFactory.create(InputStream inp) Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given InputStream.static WorkbookWorkbookFactory.create(InputStream inp, String password) Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given InputStream, which may be password protected.static WorkbookDeprecated.use XSSFWorkbookFactory.createstatic WorkbookWorkbookFactory.create(DirectoryNode root) Creates a Workbook from the given NPOIFSFileSystem.static WorkbookWorkbookFactory.create(DirectoryNode root, String password) Creates a Workbook from the given NPOIFSFileSystem, which may be password protectedstatic WorkbookWorkbookFactory.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 TypeMethodDescriptionintWorkbook.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 intSheetUtil.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 voidIOUtils.write(Workbook doc, OutputStream out) Deprecated.since 4.0, use try-with-resources, will be removed in 4.2static voidIOUtils.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 TypeClassDescriptionclassStreaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming with parameters of type WorkbookModifier and TypeMethodDescriptionintSXSSFWorkbook.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 TypeClassDescriptionclassHigh 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.intXSSFWorkbook.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.