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

Packages that use Workbook

Package	Description
org.zkoss.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model Related Documentation For overviews, tutorials, examples, guides, and tool documentation, please see: Apache POI Project
org.zkoss.poi.ss.formula.eval.forked
org.zkoss.poi.ss.usermodel
org.zkoss.poi.ss.util
org.zkoss.poi.xssf.streaming
org.zkoss.poi.xssf.usermodel
org.zkoss.poi.xssf.usermodel.helpers
org.zkoss.zpoiex.ss.usermodel.helpers
org.zkoss.zss.range.impl.imexp	ZK Spreadsheet Internal Range API Implementation classes.

Uses of Workbook in org.zkoss.poi.hssf.usermodel

Classes in org.zkoss.poi.hssf.usermodel that implement Workbook

Modifier and Type	Class and Description
class	HSSFWorkbook High level representation of a workbook.

Methods in org.zkoss.poi.hssf.usermodel with parameters of type Workbook

Modifier and Type	Method and 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 workbook
HSSFFont	HSSFCellStyle.getFont(Workbook parentWorkbook) gets the font for this style

Uses of Workbook in org.zkoss.poi.ss.formula.eval.forked

Methods in org.zkoss.poi.ss.formula.eval.forked with parameters of type Workbook

Modifier and Type	Method and Description
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.
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.zkoss.poi.ss.usermodel

Methods in org.zkoss.poi.ss.usermodel that return Workbook

Modifier and Type	Method and Description
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.InputStream inp) Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given InputStream.
static Workbook	WorkbookFactory.create(NPOIFSFileSystem fs) Creates an HSSFWorkbook from the given NPOIFSFileSystem
static Workbook	WorkbookFactory.create(OPCPackage pkg) Creates an XSSFWorkbook from the given OOXML Package
static Workbook	WorkbookFactory.create(POIFSFileSystem fs) Creates an HSSFWorkbook from the given POIFSFileSystem
Workbook	Sheet.getWorkbook() Return the parent workbook
Workbook	PivotCache.getWorkbook() Return the parent workbook

Methods in org.zkoss.poi.ss.usermodel with parameters of type Workbook

Modifier and Type	Method and Description
PivotCache	PivotTableHelper.createPivotCache(AreaReference sourceRef, Workbook book)
java.util.List<PivotCache>	PivotTableHelper.initPivotCaches(Workbook book)

Uses of Workbook in org.zkoss.poi.ss.util

Methods in org.zkoss.poi.ss.util with parameters of type Workbook

Modifier and Type	Method and Description
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 attempt to find an already existing CellStyle that matches what you want the style to be.
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.zkoss.poi.ss.util with parameters of type Workbook

Constructor and Description
SheetBuilder(Workbook workbook, java.lang.Object[][] cells)

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

Classes in org.zkoss.poi.xssf.streaming that implement Workbook

Modifier and Type	Class and Description
class	SXSSFWorkbook Streaming version of XSSFWorkbook implementing the "BigGridDemo" strategy.

Methods in org.zkoss.poi.xssf.streaming that return Workbook

Modifier and Type	Method and Description
Workbook	SXSSFSheet.getWorkbook() Return the parent workbook

Uses of Workbook in org.zkoss.poi.xssf.usermodel

Classes in org.zkoss.poi.xssf.usermodel that implement Workbook

Modifier and Type	Class and Description
class	XSSFWorkbook High level representation of a SpreadsheetML workbook.

Methods in org.zkoss.poi.xssf.usermodel that return Workbook

Modifier and Type	Method and Description
Workbook	XSSFPivotCache.getWorkbook()

Uses of Workbook in org.zkoss.poi.xssf.usermodel.helpers

Methods in org.zkoss.poi.xssf.usermodel.helpers with parameters of type Workbook

Modifier and Type	Method and Description
PivotCache	XSSFPivotTableHelper.createPivotCache(AreaReference sourceRef, Workbook book)
java.util.List<PivotCache>	XSSFPivotTableHelper.initPivotCaches(Workbook book)

Uses of Workbook in org.zkoss.zpoiex.ss.usermodel.helpers

Methods in org.zkoss.zpoiex.ss.usermodel.helpers with parameters of type Workbook

Modifier and Type	Method and Description
PivotCache	PivotTableHelper.createPivotCache(AreaReference sourceRef, Workbook book)
java.util.List<PivotCache>	PivotTableHelper.initPivotCaches(Workbook book)

Uses of Workbook in org.zkoss.zss.range.impl.imexp

Fields in org.zkoss.zss.range.impl.imexp declared as Workbook

Modifier and Type	Field and Description
protected Workbook	AbstractExcelImporter.workbook source POI book
protected Workbook	AbstractExcelExporter.workbook Exporting destination, POI book model

Methods in org.zkoss.zss.range.impl.imexp that return Workbook

Modifier and Type	Method and Description
protected Workbook	ExcelXlsxExporter.createPoiBook()
protected Workbook	ExcelXlsExporter.createPoiBook()
protected abstract Workbook	AbstractExcelExporter.createPoiBook()
protected Workbook	ExcelXlsxImporter.createPoiBook(java.io.InputStream is)
protected Workbook	ExcelXlsImporter.createPoiBook(java.io.InputStream is)
protected abstract Workbook	AbstractExcelImporter.createPoiBook(java.io.InputStream is)

Methods in org.zkoss.zss.range.impl.imexp with parameters of type Workbook

Modifier and Type	Method and Description
static java.lang.String	BookHelper.colorToBackgroundHTML(Workbook book, Color color)
static java.lang.String	BookHelper.colorToBorderHTML(Workbook book, Color color)
static java.lang.String	BookHelper.colorToForegroundHTML(Workbook book, Color color)
static java.lang.String	BookHelper.colorToHTML(Workbook book, Color color)
static java.lang.String	BookHelper.getFontHTMLColor(Workbook book, Font font)
protected Font	AbstractExcelImporter.getPoiFontFromRichText(Workbook book, Cell cell, RichTextString rstr, int run)
static Color	BookHelper.HTMLToColor(Workbook book, java.lang.String color)
static void	BookHelper.setFontColor(Workbook book, Font font, Color color)