|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||
| Packages that use HSSFSheet | |
|---|---|
| org.apache.poi.hssf.converter | |
| 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.util | util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts. |
| Uses of HSSFSheet in org.apache.poi.hssf.converter |
|---|
| Methods in org.apache.poi.hssf.converter with parameters of type HSSFSheet | |
|---|---|
static CellRangeAddress[][] |
ExcelToHtmlUtils.buildMergedRangesMap(HSSFSheet sheet)
Creates a map (i.e. |
protected static int |
AbstractExcelConverter.getColumnWidth(HSSFSheet sheet,
int columnIndex)
|
protected static int |
AbstractExcelConverter.getDefaultColumnWidth(HSSFSheet sheet)
|
protected void |
ExcelToHtmlConverter.processColumnHeaders(HSSFSheet sheet,
int maxSheetColumns,
org.w3c.dom.Element table)
|
protected void |
ExcelToFoConverter.processColumnHeaders(HSSFSheet sheet,
int maxSheetColumns,
org.w3c.dom.Element table)
|
protected void |
ExcelToHtmlConverter.processColumnWidths(HSSFSheet sheet,
int maxSheetColumns,
org.w3c.dom.Element table)
Creates COLGROUP element with width specified for all columns. |
protected float |
ExcelToFoConverter.processColumnWidths(HSSFSheet sheet,
int maxSheetColumns,
org.w3c.dom.Element table)
Creates COLGROUP element with width specified for all columns. |
protected void |
ExcelToHtmlConverter.processSheet(HSSFSheet sheet)
|
protected float |
ExcelToFoConverter.processSheet(HSSFWorkbook workbook,
HSSFSheet sheet,
org.w3c.dom.Element flow)
|
protected void |
ExcelToHtmlConverter.processSheetHeader(org.w3c.dom.Element htmlBody,
HSSFSheet sheet)
|
protected void |
ExcelToFoConverter.processSheetName(HSSFSheet sheet,
org.w3c.dom.Element flow)
|
| Uses of HSSFSheet in org.apache.poi.hssf.record |
|---|
| Methods in org.apache.poi.hssf.record with parameters of type HSSFSheet | |
|---|---|
static CFRuleRecord |
CFRuleRecord.create(HSSFSheet sheet,
byte comparisonOperation,
java.lang.String formulaText1,
java.lang.String formulaText2)
Creates a new comparison operation rule |
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
byte comparisonOperation,
java.lang.String formulaText1,
java.lang.String formulaText2)
Creates a new comparison operation rule |
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
byte comparisonOperation,
java.lang.String formulaText1,
java.lang.String formulaText2,
java.lang.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,
java.lang.String formulaText)
Creates a new comparison operation rule |
static CFRule12Record |
CFRule12Record.create(HSSFSheet sheet,
java.lang.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(java.lang.String formula,
HSSFSheet sheet)
TODO - parse conditional format formulas properly i.e. |
| Uses of HSSFSheet in org.apache.poi.hssf.usermodel |
|---|
| Fields in org.apache.poi.hssf.usermodel with type parameters of type HSSFSheet | |
|---|---|
protected java.util.List<HSSFSheet> |
HSSFWorkbook._sheets
this holds the HSSFSheet objects attached to this workbook |
| Methods in org.apache.poi.hssf.usermodel that return HSSFSheet | |
|---|---|
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 a new sheet for this Workbook and return the high level representation. |
HSSFSheet |
HSSFRow.getSheet()
Returns the HSSFSheet this row belongs to |
HSSFSheet |
HSSFPicture.getSheet()
|
protected HSSFSheet |
HSSFPatriarch.getSheet()
|
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. |
| Methods in org.apache.poi.hssf.usermodel with parameters of type HSSFSheet | |
|---|---|
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. |
| Constructors in org.apache.poi.hssf.usermodel with parameters of type HSSFSheet | |
|---|---|
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. |
|
HSSFColorScaleFormatting(CFRule12Record cfRule12Record,
HSSFSheet sheet)
|
|
HSSFConditionalFormattingThreshold(Threshold threshold,
HSSFSheet sheet)
|
|
HSSFDataBarFormatting(CFRule12Record cfRule12Record,
HSSFSheet sheet)
|
|
HSSFDataValidationHelper(HSSFSheet sheet)
|
|
HSSFFormulaEvaluator(HSSFSheet sheet,
HSSFWorkbook workbook)
Deprecated. (Sep 2008) HSSFSheet parameter is ignored |
|
HSSFIconMultiStateFormatting(CFRule12Record cfRule12Record,
HSSFSheet sheet)
|
|
| Uses of HSSFSheet in org.apache.poi.hssf.util |
|---|
| Methods in org.apache.poi.hssf.util with parameters of type HSSFSheet | |
|---|---|
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 |
|
||||||||||
| PREV NEXT | FRAMES NO FRAMES | |||||||||