|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use Workbook | |
---|---|
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.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 |
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.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 |
Uses of Workbook in org.apache.poi.ss.util |
---|
Methods in org.apache.poi.ss.util with parameters of type Workbook | |
---|---|
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.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 that return Workbook | |
---|---|
Workbook |
SXSSFSheet.getWorkbook()
Return the parent workbook |
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. |
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |