Uses of Interface
org.apache.poi.ss.usermodel.Sheet

Packages that use Sheet

Package	Description
org.apache.poi.hssf.converter
org.apache.poi.hssf.usermodel	The usermodel package maps HSSF low level structures to familiar workbook/sheet model
org.apache.poi.ss.extractor
org.apache.poi.ss.formula	This package contains common internal POI code for manipulating formulas.
org.apache.poi.ss.usermodel
org.apache.poi.ss.usermodel.charts
org.apache.poi.ss.usermodel.helpers
org.apache.poi.ss.util
org.apache.poi.ss.util.cellwalk
org.apache.poi.xssf.streaming
org.apache.poi.xssf.usermodel

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

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

Modifier and Type	Method and Description
static CellRangeAddress[][]	ExcelToHtmlUtils.buildMergedRangesMap(Sheet sheet) Creates a map (i.e.

Uses of Sheet in org.apache.poi.hssf.usermodel

Classes in org.apache.poi.hssf.usermodel that implement Sheet

Modifier and Type	Class and Description
class	HSSFSheet High level representation of a worksheet.

Methods in org.apache.poi.hssf.usermodel that return types with arguments of type Sheet

Modifier and Type	Method and Description
java.util.Iterator<Sheet>	HSSFWorkbook.iterator() Alias for HSSFWorkbook.sheetIterator() to allow foreach loops
java.util.Iterator<Sheet>	HSSFWorkbook.sheetIterator() Returns an iterator of the sheets in the workbook in sheet order.

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

Modifier and Type	Method and Description
protected void	HSSFRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY)
int	HSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

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

Constructor and Description
HSSFRangeCopier(Sheet sourceSheet, Sheet destSheet)

Uses of Sheet in org.apache.poi.ss.extractor

Methods in org.apache.poi.ss.extractor with parameters of type Sheet

Modifier and Type	Method and Description
java.util.List<EmbeddedData>	EmbeddedExtractor.extractAll(Sheet sheet)

Uses of Sheet in org.apache.poi.ss.formula

Methods in org.apache.poi.ss.formula that return Sheet

Modifier and Type	Method and Description
Sheet	EvaluationConditionalFormatRule.getSheet()

Methods in org.apache.poi.ss.formula with parameters of type Sheet

Modifier and Type	Method and Description
java.util.List<EvaluationConditionalFormatRule>	ConditionalFormattingEvaluator.getFormatRulesForSheet(Sheet sheet) Retrieve all formatting rules for the given sheet.
java.util.List<Cell>	ConditionalFormattingEvaluator.getMatchingCells(Sheet sheet, int conditionalFormattingIndex, int ruleIndex) Conditional formatting rules can apply only to cells in the sheet to which they are attached.
protected java.util.List<EvaluationConditionalFormatRule>	ConditionalFormattingEvaluator.getRules(Sheet sheet) lazy load by sheet since reading can be expensive

Constructors in org.apache.poi.ss.formula with parameters of type Sheet

Constructor and Description
EvaluationConditionalFormatRule(WorkbookEvaluator workbookEvaluator, Sheet sheet, ConditionalFormatting formatting, int formattingIndex, ConditionalFormattingRule rule, int ruleIndex, CellRangeAddress[] regions)

Uses of Sheet in org.apache.poi.ss.usermodel

Methods in org.apache.poi.ss.usermodel that return Sheet

Modifier and Type	Method and Description
Sheet	Workbook.cloneSheet(int sheetNum) Create an Sheet from an existing sheet in the Workbook.
Sheet	Workbook.createSheet() Create a Sheet for this Workbook, adds it to the sheets and returns the high level representation.
Sheet	Workbook.createSheet(java.lang.String sheetname) Create a new sheet for this Workbook and return the high level representation.
Sheet	Row.getSheet() Returns the Sheet this row belongs to
Sheet	Cell.getSheet() Returns the sheet this cell belongs to
Sheet	Picture.getSheet()
Sheet	Workbook.getSheet(java.lang.String name) Get sheet with the given name
Sheet	Workbook.getSheetAt(int index) Get the Sheet object at the given index.

Methods in org.apache.poi.ss.usermodel that return types with arguments of type Sheet

Modifier and Type	Method and Description
java.util.Iterator<Sheet>	Workbook.sheetIterator() Returns an iterator of the sheets in the workbook in sheet order.

Methods in org.apache.poi.ss.usermodel with parameters of type Sheet

Modifier and Type	Method and Description
protected abstract void	RangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY)
int	Workbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

Constructors in org.apache.poi.ss.usermodel with parameters of type Sheet

Constructor and Description
RangeCopier(Sheet sheet)
RangeCopier(Sheet sourceSheet, Sheet destSheet)

Uses of Sheet in org.apache.poi.ss.usermodel.charts

Methods in org.apache.poi.ss.usermodel.charts with parameters of type Sheet

Modifier and Type	Method and Description
static ChartDataSource<java.lang.Number>	DataSources.fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress) Deprecated.
static ChartDataSource<java.lang.String>	DataSources.fromStringCellRange(Sheet sheet, CellRangeAddress cellRangeAddress) Deprecated.

Uses of Sheet in org.apache.poi.ss.usermodel.helpers

Fields in org.apache.poi.ss.usermodel.helpers declared as Sheet

Modifier and Type	Field and Description
protected Sheet	RowShifter.sheet
protected Sheet	ColumnShifter.sheet

Constructors in org.apache.poi.ss.usermodel.helpers with parameters of type Sheet

Constructor and Description
ColumnShifter(Sheet sh)
RowShifter(Sheet sh)

Uses of Sheet in org.apache.poi.ss.util

Methods in org.apache.poi.ss.util that return Sheet

Modifier and Type	Method and Description
Sheet	SheetBuilder.build() Builds sheet from parent workbook and 2D array with cell values.

Methods in org.apache.poi.ss.util with parameters of type Sheet

Modifier and Type	Method and Description
void	PropertyTemplate.applyBorders(Sheet sheet) Applies the drawn borders to a Sheet.
static Cell	SheetUtil.getCell(Sheet sheet, int rowIx, int colIx) Return the cell, without taking account of merged regions.
static Cell	SheetUtil.getCellWithMerges(Sheet sheet, int rowIx, int colIx) Return the cell, taking account of merged regions.
static double	SheetUtil.getColumnWidth(Sheet sheet, int column, boolean useMergedCells) Compute width of a column and return the result
static double	SheetUtil.getColumnWidth(Sheet sheet, int column, boolean useMergedCells, int firstRow, int lastRow) Compute width of a column based on a subset of the rows and return the result
static Row	CellUtil.getRow(int rowIndex, Sheet sheet) Get a row from the spreadsheet, and create it if it doesn't exist.
static double	ImageUtils.getRowHeightInPixels(Sheet sheet, int rowNum)
static void	RegionUtil.setBorderBottom(BorderStyle border, CellRangeAddress region, Sheet sheet) Sets the bottom border style for a region of cells by manipulating the cell style of the individual cells on the bottom
static void	RegionUtil.setBorderLeft(BorderStyle border, CellRangeAddress region, Sheet sheet) Sets the left border style for a region of cells by manipulating the cell style of the individual cells on the left
static void	RegionUtil.setBorderRight(BorderStyle border, CellRangeAddress region, Sheet sheet) Sets the right border style for a region of cells by manipulating the cell style of the individual cells on the right
static void	RegionUtil.setBorderTop(BorderStyle border, CellRangeAddress region, Sheet sheet) Sets the top border style for a region of cells by manipulating the cell style of the individual cells on the top
static void	RegionUtil.setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet) Sets the bottom border color for a region of cells by manipulating the cell style of the individual cells on the bottom
static void	RegionUtil.setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet) Sets the left border color for a region of cells by manipulating the cell style of the individual cells on the left
static void	RegionUtil.setRightBorderColor(int color, CellRangeAddress region, Sheet sheet) Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the right
static void	RegionUtil.setTopBorderColor(int color, CellRangeAddress region, Sheet sheet) Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top

Uses of Sheet in org.apache.poi.ss.util.cellwalk

Constructors in org.apache.poi.ss.util.cellwalk with parameters of type Sheet

Constructor and Description
CellWalk(Sheet sheet, CellRangeAddress range)

Uses of Sheet in org.apache.poi.xssf.streaming

Classes in org.apache.poi.xssf.streaming that implement Sheet

Modifier and Type	Class and Description
class	SXSSFSheet Streaming version of XSSFSheet implementing the "BigGridDemo" strategy.

Methods in org.apache.poi.xssf.streaming that return Sheet

Modifier and Type	Method and Description
Sheet	SXSSFWorkbook.cloneSheet(int sheetNum) Not implemented for SXSSFWorkbook Create an Sheet from an existing sheet in the Workbook.

Methods in org.apache.poi.xssf.streaming that return types with arguments of type Sheet

Modifier and Type	Method and Description
java.util.Iterator<Sheet>	SXSSFWorkbook.iterator() Alias for SXSSFWorkbook.sheetIterator() to allow foreach loops
java.util.Iterator<Sheet>	SXSSFWorkbook.sheetIterator() Returns an iterator of the sheets in the workbook in sheet order.

Methods in org.apache.poi.xssf.streaming with parameters of type Sheet

Modifier and Type	Method and Description
int	SXSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

Uses of Sheet in org.apache.poi.xssf.usermodel

Classes in org.apache.poi.xssf.usermodel that implement Sheet

Modifier and Type	Class and Description
class	XSSFChartSheet High level representation of Sheet Parts that are of type 'chartsheet'.
class	XSSFDialogsheet
class	XSSFSheet High level representation of a SpreadsheetML worksheet.

Methods in org.apache.poi.xssf.usermodel that return Sheet

Modifier and Type	Method and Description
Sheet	XSSFPivotTable.getDataSheet()
Sheet	XSSFPivotTable.getParentSheet()

Methods in org.apache.poi.xssf.usermodel that return types with arguments of type Sheet

Modifier and Type	Method and Description
java.util.Iterator<Sheet>	XSSFWorkbook.iterator() Alias for XSSFWorkbook.sheetIterator() to allow foreach loops Note: remove() is not supported on this iterator.
java.util.Iterator<Sheet>	XSSFWorkbook.sheetIterator() Returns an iterator of the sheets in the workbook in sheet order.

Methods in org.apache.poi.xssf.usermodel with parameters of type Sheet

Modifier and Type	Method and Description
protected void	XSSFRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY)
protected void	XSSFPivotCacheDefinition.createCacheFields(Sheet sheet) Generates a cache field for each column in the reference area for the pivot table.
XSSFPivotTable	XSSFSheet.createPivotTable(AreaReference source, CellReference position, Sheet sourceSheet) Create a pivot table using the AreaReference range on sourceSheet, at the given position.
XSSFPivotTable	XSSFSheet.createPivotTable(Name source, CellReference position, Sheet sourceSheet) Create a pivot table using the Name range reference on sourceSheet, at the given position.
protected void	XSSFPivotTable.createSourceReferences(CellReference position, Sheet sourceSheet, XSSFPivotTable.PivotTableReferenceConfigurator refConfig) Creates cacheSource and workSheetSource for pivot table and sets the source reference as well assets the location of the pivot table
int	XSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

Constructors in org.apache.poi.xssf.usermodel with parameters of type Sheet

Constructor and Description
XSSFRangeCopier(Sheet sourceSheet, Sheet destSheet)