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

Packages that use Sheet

Package	Description
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.helpers
org.apache.poi.ss.util
org.apache.poi.ss.util.cellwalk

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
Iterator<Sheet>	HSSFWorkbook.sheetIterator() Returns an iterator of the sheets in the workbook in sheet order.
Spliterator<Sheet>	HSSFWorkbook.spliterator() Returns a spliterator 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 sheet)
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
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
List<EvaluationConditionalFormatRule>	ConditionalFormattingEvaluator.getFormatRulesForSheet(Sheet sheet) Retrieve all formatting rules for the given sheet.
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 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 a 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(String sheetname) Create a new sheet for this Workbook and return the high level representation.
Sheet	Cell.getSheet() Returns the sheet this cell belongs to
Sheet	Picture.getSheet()
Sheet	Row.getSheet() Returns the Sheet this row belongs to
Sheet	Workbook.getSheet(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
default Iterator<Sheet>	Workbook.iterator() Alias for Workbook.sheetIterator() to allow foreach loops
Iterator<Sheet>	Workbook.sheetIterator() Returns an iterator of the sheets in the workbook in sheet order.
default Spliterator<Sheet>	Workbook.spliterator() Returns a spliterator 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.helpers

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

Modifier and Type	Field and Description
protected Sheet	ColumnShifter.sheet
protected Sheet	RowShifter.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)