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

Packages that use Sheet

org.apache.poi.hssf.usermodel	usermodel package maps HSSF low level strutures to familiar workbook/sheet model
org.apache.poi.ss.usermodel
org.apache.poi.ss.usermodel.charts
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.usermodel

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

class

HSSFSheet High level representation of a worksheet.

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

int	HSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

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

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

Sheet	Workbook.cloneSheet(int sheetNum) Create an Sheet from an existing sheet in the Workbook.
Sheet	Workbook.createSheet() Sreate an 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	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 with parameters of type Sheet

int	Workbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet

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

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

static ChartDataSource<java.lang.Number>	DataSources.fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)
static ChartDataSource<java.lang.String>	DataSources.fromStringCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)

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

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

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

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 void	RegionUtil.setBorderBottom(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the borderBottom attribute of the RegionUtil object
static void	RegionUtil.setBorderLeft(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the left border for a region of cells by manipulating the cell style of the individual cells on the left
static void	RegionUtil.setBorderRight(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the borderRight attribute of the RegionUtil object
static void	RegionUtil.setBorderTop(int border, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the borderBottom attribute of the RegionUtil object
static void	RegionUtil.setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the bottomBorderColor attribute of the RegionUtil object
static void	RegionUtil.setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the leftBorderColor attribute of the RegionUtil object
static void	RegionUtil.setRightBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the rightBorderColor attribute of the RegionUtil object
static void	RegionUtil.setTopBorderColor(int color, CellRangeAddress region, Sheet sheet, Workbook workbook) Sets the topBorderColor attribute of the RegionUtil object

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

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

CellWalk(Sheet sheet, CellRangeAddress range)

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

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

class

SXSSFSheet Streaming version of XSSFSheet implementing the "BigGridDemo" strategy.

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

Sheet	SXSSFWorkbook.cloneSheet(int sheetNum) Create an Sheet from an existing sheet in the Workbook.
Sheet	SXSSFWorkbook.createSheet() Sreate an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
Sheet	SXSSFWorkbook.createSheet(java.lang.String sheetname) Create an Sheet for this Workbook, adds it to the sheets and returns the high level representation.
Sheet	SXSSFRow.getSheet() Returns the Sheet this row belongs to
Sheet	SXSSFCell.getSheet() Returns the sheet this cell belongs to
Sheet	SXSSFWorkbook.getSheet(java.lang.String name) Get sheet with the given name
Sheet	SXSSFWorkbook.getSheetAt(int index) Get the Sheet object at the given index.

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

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

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 with parameters of type Sheet

int	XSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheet