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

Packages that use Sheet

Package	Description
io.keikai.range.impl.imexp	Keikai Spreadsheet Internal Range API Implementation classes.
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 io.keikai.range.impl.imexp

Methods in io.keikai.range.impl.imexp with parameters of type Sheet

Modifier and Type	Method	Description
protected abstract void	AbstractExcelExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportAutoFilter(SSheet sheet, Sheet poiSheet)	See Javadoc at AbstractExcelImporter importAutoFilter().
protected abstract void	AbstractExcelExporter.exportChart(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportChart(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportChart(SSheet sheet, Sheet poiSheet)	reference DrawingManagerImpl.addChartX()
protected abstract void	AbstractExcelExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void	ExcelXlsExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected void	ExcelXlsxExporter.exportColumnArray(SSheet sheet, Sheet poiSheet, SColumnArray columnArr)
protected abstract void	AbstractExcelExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportExtLst(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportExtLst(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportExtLst(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportMergedRegions(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportPassword(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportPassword(SSheet sheet, Sheet poiSheet)	Export hashed password directly to poiSheet.
protected void	ExcelXlsxExporter.exportPassword(SSheet sheet, Sheet poiSheet)	Export hashed password directly to poiSheet.
protected abstract void	AbstractExcelExporter.exportPicture(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportPicture(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportPicture(SSheet sheet, Sheet poiSheet)	Reference DrawingManagerImpl.addPicture()
protected void	AbstractExcelExporter.exportRow(SSheet sheet, Sheet poiSheet, SRow row)
protected void	AbstractExcelExporter.exportRowColumn(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportRowColumn(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelExporter.exportSheetPr(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportSheetPr(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportSheetPr(SSheet sheet, Sheet poiSheet)
protected void	AbstractExcelExporter.exportSheetProtection(SSheet sheet, Sheet poiSheet)	POI SheetProtection.
protected abstract int	AbstractExcelExporter.exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected int	ExcelXlsExporter.exportTables(SSheet sheet, Sheet poiSheet, int tbId)
protected int	ExcelXlsxExporter.exportTables(SSheet sheet, Sheet poiSheet0, int tbId)
protected abstract void	AbstractExcelExporter.exportValidation(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsExporter.exportValidation(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsxExporter.exportValidation(SSheet sheet, Sheet poiSheet)	According to SDataValidation.ValidationType, FORMULA means custom validation.
protected abstract int	AbstractExcelImporter.getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet)
protected int	ExcelXlsImporter.getAnchorHeightInPx(ClientAnchor anchor, Sheet poiSheet)	reference DefaultBookWidgetLoader.getHSSFHeightInPx()
protected abstract int	AbstractExcelImporter.getAnchorWidthInPx(ClientAnchor anchor, Sheet poiSheet)	If in same column: anchorWidthInFirstColumn + anchor width in inter-columns + anchorWidthInLastColumn (dx2) no in same column: anchorWidthInLastColumn - offsetInFirstColumn (dx1)
protected int	ExcelXlsImporter.getAnchorWidthInPx(ClientAnchor anchor, Sheet sheet)	reference DefaultBookWidgetLoader.getHSSFWidthInPx()
static int	BookHelper.getColumnFreeze(Sheet sheet)	gets the column freeze, 1 base
static int	ImExpUtils.getHeightAny(Sheet poiSheet, int row)
protected int	ExcelXlsImporter.getLastChangedColumnIndex(Sheet poiSheet)
static int	BookHelper.getRowFreeze(Sheet sheet)	gets the row freeze, 1 base
static int	ImExpUtils.getRowHeightInPx(Sheet poiSheet, Row row)
static int	ImExpUtils.getWidthAny(Sheet poiSheet, int col, int charWidth)
protected abstract int	AbstractExcelImporter.getXoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected int	ExcelXlsImporter.getXoffsetInPixel(ClientAnchor anchor, Sheet poiSheet)
protected abstract int	AbstractExcelImporter.getYoffsetInPixel(ClientAnchor clientAnchor, Sheet poiSheet)
protected int	ExcelXlsImporter.getYoffsetInPixel(ClientAnchor anchor, Sheet poiSheet)
protected void	AbstractExcelImporter.importAutoFilter(Sheet poiSheet, SSheet sheet)	POI AutoFilter.getFilterColumn(i) sometimes returns null.
protected void	ExcelXlsImporter.importChart(List<HSSFChartShape> poiCharts, Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importColumn(Sheet poiSheet, SSheet sheet)	When a column is hidden with default width, we don't import the width for it's 0.
protected void	ExcelXlsImporter.importColumn(Sheet poiSheet, SSheet sheet)	When a column is hidden with default width, we don't import the width for it's 0.
protected abstract void	AbstractExcelImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected void	ExcelXlsImporter.importConditionalFormatting(SSheet sheet, Sheet poiSheet)
protected abstract void	AbstractExcelImporter.importDrawings(Sheet poiSheet, SSheet sheet)	Drawings includes charts and pictures.
protected void	ExcelXlsImporter.importDrawings(Sheet poiSheet, SSheet sheet)	reference DrawingManagerImpl.initHSSFDrawings()
protected void	AbstractExcelImporter.importMergedRegions(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importPassword(Sheet poiSheet, SSheet sheet)
protected void	AbstractExcelImporter.importPicture(List<Picture> poiPictures, Sheet poiSheet, SSheet sheet)
protected SSheet	AbstractExcelImporter.importSheet(Sheet poiSheet, int poiSheetIndex)
protected void	AbstractExcelImporter.importSheetDefaultColumnWidth(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importSheetProtection(Sheet poiSheet, SSheet sheet)	POI SheetProtection.
protected void	ExcelXlsImporter.importSheetProtection(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importTables(Sheet poiSheet, SSheet sheet)	POI sheet tables
protected void	ExcelXlsImporter.importTables(Sheet poiSheet, SSheet sheet)
protected abstract void	AbstractExcelImporter.importValidation(Sheet poiSheet, SSheet sheet)
protected void	ExcelXlsImporter.importValidation(Sheet poiSheet, SSheet sheet)
static boolean	BookHelper.isFreezePane(Sheet sheet)
protected ViewAnchor	AbstractExcelImporter.toViewAnchor(Sheet poiSheet, ClientAnchor clientAnchor)

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

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

Modifier and Type	Class	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	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	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	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	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	Description
Sheet	EvaluationConditionalFormatRule.getSheet()

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

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

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

Constructor	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	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	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	Description
CellWalk(Sheet sheet, CellRangeAddress range)