|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
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. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |