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

Packages that use HSSFSheet

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

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	Description
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, String formulaText)	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, byte comparisonOperation, String formulaText1, String formulaText2)	Creates a new comparison operation rule
static CFRuleRecord	CFRuleRecord.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.

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

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

Modifier and Type	Method	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	Description
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.
HSSFCell(HSSFWorkbook book, HSSFSheet sheet, CellValueRecordInterface cval)	Creates an HSSFCell from a CellValueRecordInterface.
HSSFChart(HSSFSheet sheet, ChartRecord chart, LegendRecord legend, ChartTitleFormatRecord chartTitleFormat, SeriesTextRecord chartTitleText, List<Object[]> seriesList, List<ValueRangeRecord> valueRanges, Record chartType, Chart3DRecord chart3d, TextRecord titleTextRecord)
HSSFColorScaleFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet)
HSSFDataBarFormatting(CFRule12Record cfRule12Record, HSSFSheet sheet)
HSSFDataValidationHelper(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	Description
HSSFColumnShifter(HSSFSheet sh)
HSSFRowShifter(HSSFSheet sh)