Package | Description |
---|---|
org.apache.poi.hssf.contrib.view | |
org.apache.poi.hssf.record |
Record package contains class representations for XLS binary strutures.
|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.hssf.usermodel.contrib |
Modifier and Type | Method and Description |
---|---|
protected javax.swing.JComponent |
SViewerPanel.makeSheetView(HSSFSheet sheet) |
Constructor and Description |
---|
SVRowHeader(HSSFSheet sheet,
javax.swing.JTable table,
int extraHeight) |
SVTableModel(HSSFSheet st) |
SVTableModel(HSSFSheet st,
int maxcol) |
Modifier and Type | Method and Description |
---|---|
static CFRuleRecord |
CFRuleRecord.create(HSSFSheet sheet,
byte comparisonOperation,
java.lang.String formulaText1,
java.lang.String formulaText2)
Creates a new comparison operation rule
|
static CFRuleRecord |
CFRuleRecord.create(HSSFSheet sheet,
java.lang.String formulaText)
Creates a new comparison operation rule
|
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(java.lang.String sheetname)
create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and
returns the high level representation.
|
HSSFSheet |
HSSFRow.getSheet()
Returns the HSSFSheet this row belongs to
|
HSSFSheet |
HSSFCell.getSheet()
Returns the HSSFSheet this cell belongs to
|
HSSFSheet |
HSSFWorkbook.getSheet(java.lang.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 sheet)
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,
int type)
Creates new Cell - Should only be called by HSSFRow.
|
HSSFFormulaEvaluator(HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Sep 2008) HSSFSheet parameter is ignored
|
Modifier and Type | Method and Description |
---|---|
static HSSFRow |
HSSFCellUtil.getRow(int rowIndex,
HSSFSheet sheet)
Get a row from the spreadsheet, and create it if it doesn't exist.
|
static void |
HSSFRegionUtil.setBorderBottom(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the borderBottom attribute of the HSSFRegionUtil object
|
static void |
HSSFRegionUtil.setBorderBottom(short border,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
static void |
HSSFRegionUtil.setBorderLeft(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the left border for a region of cells by manipulating the cell style
of the individual cells on the left
|
static void |
HSSFRegionUtil.setBorderLeft(short border,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
static void |
HSSFRegionUtil.setBorderRight(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the borderRight attribute of the HSSFRegionUtil object
|
static void |
HSSFRegionUtil.setBorderRight(short border,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
static void |
HSSFRegionUtil.setBorderTop(int border,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the borderBottom attribute of the HSSFRegionUtil object
|
static void |
HSSFRegionUtil.setBorderTop(short border,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
static void |
HSSFRegionUtil.setBottomBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the bottomBorderColor attribute of the HSSFRegionUtil object
|
static void |
HSSFRegionUtil.setBottomBorderColor(short color,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
static void |
HSSFRegionUtil.setLeftBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the leftBorderColor attribute of the HSSFRegionUtil object
|
static void |
HSSFRegionUtil.setLeftBorderColor(short color,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
static void |
HSSFRegionUtil.setRightBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the rightBorderColor attribute of the HSSFRegionUtil object
|
static void |
HSSFRegionUtil.setRightBorderColor(short color,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
static void |
HSSFRegionUtil.setTopBorderColor(int color,
CellRangeAddress region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Sets the topBorderColor attribute of the HSSFRegionUtil object
|
static void |
HSSFRegionUtil.setTopBorderColor(short color,
Region region,
HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated.
(Aug 2008) use
CellRangeAddress instead of Region |
Copyright 2014 The Apache Software Foundation or its licensors, as applicable.