Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

## 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.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.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 that return types with arguments of type Sheet
`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
`int` | `HSSFWorkbook.getSheetIndex(Sheet sheet)` Returns the index of the given sheet

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

Methods in org.apache.poi.ss.extractor with parameters of type Sheet
`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
`Sheet` | `EvaluationConditionalFormatRule.getSheet()`

Methods in org.apache.poi.ss.formula with parameters of type Sheet
`java.util.List<EvaluationConditionalFormatRule>` | `ConditionalFormattingEvaluator.getFormatRulesForSheet(Sheet 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
`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
`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` | `Cell.getSheet()` Returns the sheet this cell belongs to
`Sheet` | `Row.getSheet()` Returns the Sheet this row 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
`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
`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.usermodel.helpers

Fields in org.apache.poi.ss.usermodel.helpers declared as Sheet
`protected Sheet` | `RowShifter.sheet`

Constructors in org.apache.poi.ss.usermodel.helpers with parameters of type Sheet
`RowShifter(Sheet sh)`

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
`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.setBorderBottom(int border, CellRangeAddress region, Sheet sheet)` Deprecated. POI 3.16 beta 1. Use `RegionUtil.setBorderBottom(BorderStyle, CellRangeAddress, Sheet)`.
`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.setBorderLeft(int border, CellRangeAddress region, Sheet sheet)` Deprecated. 3.16 beta 1. Use `RegionUtil.setBorderLeft(BorderStyle, CellRangeAddress, Sheet)`.
`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.setBorderRight(int border, CellRangeAddress region, Sheet sheet)` Deprecated. POI 3.16 beta 1. Use `RegionUtil.setBorderRight(BorderStyle, CellRangeAddress, Sheet)`.
`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.setBorderTop(int border, CellRangeAddress region, Sheet sheet)` Deprecated. 3.16 beta 1. Use `RegionUtil.setBorderTop(BorderStyle, CellRangeAddress, Sheet)`.
`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
`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)` 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
`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
`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 that return Sheet
`Sheet` | `XSSFPivotTable.getDataSheet()`
`Sheet` | `XSSFPivotTable.getParentSheet()`

Methods in org.apache.poi.xssf.usermodel that return types with arguments of type Sheet
`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
`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

Overview | Package | Class | Use | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

Copyright 2017 The Apache Software Foundation or its licensors, as applicable.