| Package | Description |
|---|---|
| org.apache.poi.hssf.record |
Record package contains class representations for XLS binary strutures.
|
| org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
| org.apache.poi.hssf.usermodel.helpers |
| Modifier and Type | Method and Description |
|---|---|
static CFRuleRecord |
CFRuleRecord.create(HSSFSheet sheet,
byte comparisonOperation,
String formulaText1,
String formulaText2)
Creates a new comparison operation rule
|
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
byte comparisonOperation,
String formulaText1,
String formulaText2)
Creates a new comparison operation rule
|
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
byte comparisonOperation,
String formulaText1,
String formulaText2,
String formulaTextScale)
Creates a new comparison operation rule
|
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
ExtendedColor color)
Creates a new Data Bar formatting
|
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
IconMultiStateFormatting.IconSet iconSet)
Creates a new Icon Set / Multi-State formatting
|
static CFRuleRecord |
CFRuleRecord.create(HSSFSheet sheet,
String formulaText)
Creates a new comparison operation rule
|
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
String formulaText)
Creates a new comparison operation rule
|
static CFRule12Record |
CFRule12Record.createColorScale(HSSFSheet sheet)
Creates a new Color Scale / Color Gradient formatting
|
static Ptg[] |
CFRuleBase.parseFormula(String formula,
HSSFSheet sheet)
TODO - parse conditional format formulas properly i.e.
|
| Modifier and Type | Field and Description |
|---|---|
protected List<HSSFSheet> |
HSSFWorkbook._sheets
this holds the HSSFSheet objects attached to this workbook
|
| Modifier and Type | Method and Description |
|---|---|
HSSFSheet |
HSSFWorkbook.cloneSheet(int sheetIndex)
create an HSSFSheet from an existing sheet in the HSSFWorkbook.
|
HSSFSheet |
HSSFWorkbook.createSheet()
create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns
the high level representation.
|
HSSFSheet |
HSSFWorkbook.createSheet(String sheetname)
Create a new sheet for this Workbook and return the high level representation.
|
protected HSSFSheet |
HSSFPatriarch.getSheet() |
HSSFSheet |
HSSFRow.getSheet()
Returns the HSSFSheet this row belongs to
|
HSSFSheet |
HSSFCell.getSheet()
Returns the HSSFSheet this cell belongs to
|
HSSFSheet |
HSSFPicture.getSheet() |
HSSFSheet |
HSSFWorkbook.getSheet(String name)
Get sheet with the given name (case insensitive match).
|
HSSFSheet |
HSSFWorkbook.getSheetAt(int index)
Get the HSSFSheet object at the given index.
|
| Modifier and Type | Method and Description |
|---|---|
void |
HSSFChart.createBarChart(HSSFWorkbook workbook,
HSSFSheet parentSheet)
Creates a bar chart.
|
DVRecord |
HSSFDataValidation.createDVRecord(HSSFSheet sheet) |
float |
HSSFClientAnchor.getAnchorHeightInPoints(HSSFSheet sheet)
Calculates the height of a client anchor in points.
|
static HSSFChart[] |
HSSFChart.getSheetCharts(HSSFSheet sheet)
Returns all the charts for the given sheet.
|
| Constructor and Description |
|---|
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.
|
HSSFColorScaleFormatting(CFRule12Record cfRule12Record,
HSSFSheet sheet) |
HSSFDataBarFormatting(CFRule12Record cfRule12Record,
HSSFSheet sheet) |
HSSFDataValidationHelper(HSSFSheet sheet) |
| Constructor and Description |
|---|
HSSFColumnShifter(HSSFSheet sh) |
HSSFRowShifter(HSSFSheet sh) |