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 intInternalWorkbook. 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 classHSSFWorkbookHigh level representation of a workbook.Methods in org.apache.poi.hssf.usermodel with parameters of type Workbook Modifier and Type Method Description static voidHSSFFormulaEvaluator. evaluateAllFormulaCells(Workbook wb)Loops over all cells in all sheets of the supplied workbook.java.lang.StringHSSFCellStyle. getDataFormatString(Workbook workbook)Get the contents of the format string, by looking up the DataFormat against the supplied workbookHSSFFontHSSFCellStyle. getFont(Workbook parentWorkbook)gets the font for this styleintHSSFWorkbook. 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 classSXSSFWorkbookWithCustomZipEntrySource -
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 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 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 voidForkedEvaluator. 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 Workbook Modifier and Type Method Description static WorkbookWorkbookFactory. create(boolean xssf)Create a new empty Workbook, either XSSF or HSSF depending on the parameterstatic WorkbookWorkbookFactory. create(java.io.File file)Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable.static WorkbookWorkbookFactory. 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 WorkbookWorkbookFactory. 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 WorkbookWorkbookFactory. create(java.io.InputStream inp)Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given InputStream.static WorkbookWorkbookFactory. create(java.io.InputStream inp, java.lang.String password)Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given InputStream, which may be password protected.static WorkbookWorkbookFactory. create(java.lang.Object pkg)Deprecated.use XSSFWorkbookFactory.createstatic WorkbookWorkbookFactory. create(DirectoryNode root)Creates a Workbook from the given NPOIFSFileSystem.static WorkbookWorkbookFactory. create(DirectoryNode root, java.lang.String password)Creates a Workbook from the given NPOIFSFileSystem, which may be password protectedstatic WorkbookWorkbookFactory. create(POIFSFileSystem fs)Creates a HSSFWorkbook from the given NPOIFSFileSystemWorkbookSheet. getWorkbook()Return the parent workbookMethods in org.apache.poi.ss.usermodel with parameters of type Workbook Modifier and Type Method Description intWorkbook. 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 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 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 voidIOUtils. write(Workbook doc, java.io.OutputStream out)Deprecated.since 4.0, use try-with-resources, will be removed in 4.2static voidIOUtils. 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 classSXSSFWorkbookStreaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming with parameters of type Workbook Modifier and Type Method Description intSXSSFWorkbook. 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 classXSSFWorkbookHigh level representation of a SpreadsheetML workbook.Methods in org.apache.poi.xssf.usermodel with parameters of type Workbook Modifier and Type Method Description AreaReferenceXSSFPivotCacheDefinition. getPivotArea(Workbook wb)Find the 2D base data area for the pivot table, either from its direct reference or named table/range.intXSSFWorkbook. 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.
-