Uses of Class
org.apache.poi.hssf.usermodel.HSSFSheet

Packages that use HSSFSheet

Package	Description
org.apache.poi.hssf.converter
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

Uses of HSSFSheet in org.apache.poi.hssf.converter

Methods in org.apache.poi.hssf.converter with parameters of type HSSFSheet

Modifier and Type	Method and Description
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

Modifier and Type	Method and Description
static CFRule12Record	CFRule12Record.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, 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 CFRule12Record	CFRule12Record.create(HSSFSheet sheet, java.lang.String formulaText) Creates a new comparison operation rule
static CFRuleRecord	CFRuleRecord.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

Modifier and Type	Field and Description
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

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 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()
HSSFSheet	HSSFCell.getSheet() Returns the HSSFSheet this cell belongs to
protected HSSFSheet	HSSFPatriarch.getSheet()
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

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.

Constructors in org.apache.poi.hssf.usermodel with parameters of type HSSFSheet

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)
HSSFConditionalFormattingThreshold(Threshold threshold, HSSFSheet sheet)
HSSFDataBarFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet)
HSSFDataValidationHelper(HSSFSheet sheet)
HSSFIconMultiStateFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet)

Uses of HSSFSheet in org.apache.poi.hssf.usermodel.helpers

Constructors in org.apache.poi.hssf.usermodel.helpers with parameters of type HSSFSheet

Constructor and Description
HSSFColumnShifter(HSSFSheet sh)
HSSFRowShifter(HSSFSheet sh)