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

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 CFRuleRecord	CFRuleRecord.create(HSSFSheet sheet, java.lang.String formulaText) Creates a new comparison operation rule

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	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.

HSSFDataValidationHelper(HSSFSheet sheet)

HSSFFormulaEvaluator(HSSFSheet sheet, HSSFWorkbook workbook)
Deprecated. (Sep 2008) HSSFSheet parameter is ignored

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