| Package | Description |
|---|---|
| org.apache.poi.hssf.eventusermodel |
HSSF eventmodel Package provides an event-based API for reading HSSF files.
|
| org.apache.poi.hssf.extractor | |
| 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
|
| Modifier and Type | Method and Description |
|---|---|
HSSFWorkbook |
EventWorkbookBuilder.SheetRecordCollectingListener.getStubHSSFWorkbook() |
| Modifier and Type | Method and Description |
|---|---|
HSSFWorkbook |
ExcelExtractor.getDocument() |
HSSFWorkbook |
ExcelExtractor.getFilesystem() |
| Constructor and Description |
|---|
ExcelExtractor(HSSFWorkbook wb) |
| Modifier and Type | Method and Description |
|---|---|
static Ptg[] |
HSSFFormulaParser.parse(String formula,
HSSFWorkbook workbook)
Convenience method for parsing cell formulas.
|
static Ptg[] |
HSSFFormulaParser.parse(String formula,
HSSFWorkbook workbook,
FormulaType formulaType) |
static Ptg[] |
HSSFFormulaParser.parse(String formula,
HSSFWorkbook workbook,
FormulaType formulaType,
int sheetIndex) |
static String |
HSSFFormulaParser.toFormulaString(HSSFWorkbook book,
Ptg[] ptgs)
Static method to convert an array of
Ptgs in RPN order
to a human readable string format in infix mode. |
| Modifier and Type | Field and Description |
|---|---|
protected HSSFWorkbook |
HSSFSheet._workbook |
| Modifier and Type | Method and Description |
|---|---|
HSSFWorkbook |
HSSFWorkbookFactory.create()
Create a new empty Workbook
|
HSSFWorkbook |
HSSFWorkbookFactory.create(DirectoryNode root,
String password)
Creates a HSSFWorkbook from the given DirectoryNode
|
static HSSFWorkbook |
HSSFWorkbook.create(InternalWorkbook book) |
static HSSFWorkbook |
HSSFWorkbookFactory.createWorkbook(POIFSFileSystem fs)
Creates a HSSFWorkbook from the given
POIFSFileSystem |
HSSFWorkbook |
HSSFSheet.getWorkbook()
Return the parent workbook
|
| Modifier and Type | Method and Description |
|---|---|
static HSSFEvaluationWorkbook |
HSSFEvaluationWorkbook.create(HSSFWorkbook book) |
static HSSFFormulaEvaluator |
HSSFFormulaEvaluator.create(HSSFWorkbook workbook,
IStabilityClassifier stabilityClassifier,
UDFFinder udfFinder) |
void |
HSSFChart.createBarChart(HSSFWorkbook workbook,
HSSFSheet parentSheet)
Creates a bar chart.
|
static void |
HSSFFormulaEvaluator.evaluateAllFormulaCells(HSSFWorkbook wb)
Loops over all cells in all sheets of the supplied
workbook.
|
HSSFColor |
HSSFFont.getHSSFColor(HSSFWorkbook wb)
get the color value for the font
|
static void |
HSSFOptimiser.optimiseCellStyles(HSSFWorkbook workbook)
Goes through the Wokrbook, optimising the cell styles
by removing duplicate ones, and ones that aren't used.
|
static void |
HSSFOptimiser.optimiseFonts(HSSFWorkbook workbook)
Goes through the Workbook, optimising the fonts by
removing duplicate ones.
|
void |
HSSFCellStyle.verifyBelongsToWorkbook(HSSFWorkbook wb)
Verifies that this style belongs to the supplied Workbook.
|
| Constructor and Description |
|---|
EscherGraphics(HSSFShapeGroup escherGroup,
HSSFWorkbook workbook,
Color forecolor,
float verticalPointsPerPixel)
Construct an escher graphics object.
|
HSSFBorderFormatting(CFRuleBase cfRuleRecord,
HSSFWorkbook workbook) |
HSSFCell(HSSFWorkbook book,
HSSFSheet sheet,
CellValueRecordInterface cval)
Creates an HSSFCell from a CellValueRecordInterface.
|
HSSFCell(HSSFWorkbook book,
HSSFSheet sheet,
int row,
short col)
Creates new Cell - Should only be called by HSSFRow.
|
HSSFCell(HSSFWorkbook book,
HSSFSheet sheet,
int row,
short col,
CellType type)
Creates new Cell - Should only be called by HSSFRow.
|
HSSFCellStyle(short index,
ExtendedFormatRecord rec,
HSSFWorkbook workbook)
Creates new HSSFCellStyle why would you want to do this??
|
HSSFFormulaEvaluator(HSSFWorkbook workbook) |
HSSFFormulaEvaluator(HSSFWorkbook workbook,
IStabilityClassifier stabilityClassifier) |
HSSFPatternFormatting(CFRuleBase cfRuleRecord,
HSSFWorkbook workbook) |
HSSFSheet(HSSFWorkbook workbook)
Creates new HSSFSheet - called by HSSFWorkbook to create a sheet from
scratch.
|
HSSFSheet(HSSFWorkbook workbook,
InternalSheet sheet)
Creates an HSSFSheet representing the given Sheet object.
|