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

Packages that use Workbook

Package	Description
io.keikai.range.impl.imexp	Keikai Spreadsheet Internal Range API Implementation classes.
org.apache.poi.hssf.model	Provides low level API structures for reading, writing, modifying XLS files.
org.apache.poi.hssf.usermodel	The usermodel package maps HSSF low level structures to familiar workbook/sheet model
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

Uses of Workbook in io.keikai.range.impl.imexp

Fields in io.keikai.range.impl.imexp declared as Workbook

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

Methods in io.keikai.range.impl.imexp that return Workbook

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

Methods in io.keikai.range.impl.imexp with parameters of type Workbook

Modifier and Type	Method	Description
static String	BookHelper.colorToBackgroundHTML(Workbook book, Color color)
static String	BookHelper.colorToBorderHTML(Workbook book, Color color)
static String	BookHelper.colorToForegroundHTML(Workbook book, Color color)
static String	BookHelper.colorToHTML(Workbook book, Color color)
static 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, String color)
static void	BookHelper.setFontColor(Workbook book, Font font, Color color)

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
int	InternalWorkbook.linkExternalWorkbook(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
class	HSSFWorkbook	High level representation of a workbook.

Methods in org.apache.poi.hssf.usermodel that return Workbook

Modifier and Type	Method	Description
Workbook	HSSFWorkbookFactory.create(File file, String password, boolean readOnly)
Workbook	HSSFWorkbookFactory.create(InputStream inp)
Workbook	HSSFWorkbookFactory.create(InputStream inp, String password)

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

Modifier and Type	Method	Description
static void	HSSFFormulaEvaluator.evaluateAllFormulaCells(Workbook wb)	Loops over all cells in all sheets of the supplied workbook.
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(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

Methods in org.apache.poi.ss.formula with parameters of type Workbook

Modifier and Type	Method	Description
static 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 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
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, 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 Workbook	WorkbookFactory.create(boolean xssf)	Create a new empty Workbook, either XSSF or HSSF depending on the parameter
static Workbook	WorkbookFactory.create(File file)	Creates the appropriate HSSFWorkbook / XSSFWorkbook from the given File, which must exist and be readable.
static Workbook	WorkbookFactory.create(File file, 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(File file, 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(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	WorkbookFactory.create(DirectoryNode root)	Creates a Workbook from the given DirectoryNode.
static Workbook	WorkbookFactory.create(DirectoryNode root, String password)	Creates a Workbook from the given DirectoryNode, which may be password protected.
static Workbook	WorkbookFactory.create(POIFSFileSystem fs)	Creates a Workbook from the given POIFSFileSystem.
Workbook	WorkbookProvider.create()
Workbook	WorkbookProvider.create(File file, String password, boolean readOnly)
Workbook	WorkbookProvider.create(InputStream inp)
Workbook	WorkbookProvider.create(InputStream inp, String password)
Workbook	WorkbookProvider.create(DirectoryNode root, String password)
Workbook	Sheet.getWorkbook()	Return the parent workbook

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

Modifier and Type	Method	Description
int	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 Workbook

Modifier and Type	Method	Description
static int	SheetUtil.getDefaultCharWidth(Workbook wb)	Deprecated. since POI 5.2.5, it is recommended to switch to SheetUtil.getDefaultCharWidthAsFloat(Workbook).
static float	SheetUtil.getDefaultCharWidthAsFloat(Workbook wb)	Get default character width using the Workbook's default font.

Constructors in org.apache.poi.ss.util with parameters of type Workbook

Constructor	Description
SheetBuilder(Workbook workbook, Object[][] cells)