Uses of Interface
org.apache.poi.ss.usermodel.Workbook

Packages that use Workbook
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 model 
org.apache.poi.ss.formula.eval.forked   
org.apache.poi.ss.usermodel   
org.apache.poi.ss.util   
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
 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
 class HSSFWorkbook
          High level representation of a workbook.
 

Methods in org.apache.poi.hssf.usermodel with parameters of type Workbook
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.
 

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
 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)
          Deprecated. (Sep 2009) (reduce overloading) use ForkedEvaluator.create(Workbook, IStabilityClassifier, UDFFinder)
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
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(NPOIFSFileSystem fs)
          Creates a HSSFWorkbook from the given NPOIFSFileSystem
static Workbook WorkbookFactory.create(OPCPackage pkg)
          Creates a XSSFWorkbook from the given OOXML Package
static Workbook WorkbookFactory.create(POIFSFileSystem fs)
          Creates a HSSFWorkbook from the given POIFSFileSystem
 Workbook Sheet.getWorkbook()
          Return the parent workbook
 

Methods in org.apache.poi.ss.usermodel with parameters of type Workbook
 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
static int SheetUtil.getDefaultCharWidth(Workbook wb)
          Get default character width using the Workbook's default font
static void CellUtil.setAlignment(Cell cell, Workbook workbook, short align)
          Take a cell, and align it.
static void RegionUtil.setBorderBottom(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the borderBottom attribute of the RegionUtil object
static void RegionUtil.setBorderLeft(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
static void RegionUtil.setBorderRight(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the borderRight attribute of the RegionUtil object
static void RegionUtil.setBorderTop(int border, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the borderBottom attribute of the RegionUtil object
static void RegionUtil.setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the bottomBorderColor attribute of the RegionUtil object
static void CellUtil.setCellStyleProperty(Cell cell, Workbook workbook, java.lang.String propertyName, java.lang.Object propertyValue)
          This method attempts to find an existing CellStyle that matches the cell's current style plus a single style property propertyName with value propertyValue.
static void CellUtil.setFont(Cell cell, Workbook workbook, Font font)
          Take a cell, and apply a font to it
static void RegionUtil.setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the leftBorderColor attribute of the RegionUtil object
static void RegionUtil.setRightBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the rightBorderColor attribute of the RegionUtil object
static void RegionUtil.setTopBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook)
          Sets the topBorderColor attribute of the RegionUtil object
 

Constructors in org.apache.poi.ss.util with parameters of type Workbook
SheetBuilder(Workbook workbook, java.lang.Object[][] cells)
           
 

Uses of Workbook in org.apache.poi.xssf.streaming
 

Classes in org.apache.poi.xssf.streaming that implement Workbook
 class SXSSFWorkbook
          Streaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.
 

Methods in org.apache.poi.xssf.streaming with parameters of type Workbook
 int SXSSFWorkbook.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.xssf.usermodel
 

Classes in org.apache.poi.xssf.usermodel that implement Workbook
 class XSSFWorkbook
          High level representation of a SpreadsheetML workbook.
 

Methods in org.apache.poi.xssf.usermodel with parameters of type Workbook
 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 2016 The Apache Software Foundation or its licensors, as applicable.