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.usermodel |
org.apache.poi.ss.usermodel.charts |
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
`class` | `HSSFSheet` High level representation of a worksheet.

Methods in org.apache.poi.hssf.usermodel that return Sheet
`Sheet` | `HSSFWorkbook.cloneSheet(int sheetIndex)` create an HSSFSheet from an existing sheet in the HSSFWorkbook.
`Sheet` | `HSSFWorkbook.createSheet()` create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation.
`Sheet` | `HSSFWorkbook.createSheet(java.lang.String sheetname)` Create a new sheet for this Workbook and return the high level representation.
`Sheet` | `HSSFRow.getSheet()` Returns the HSSFSheet this row belongs to
`Sheet` | `HSSFCell.getSheet()` Returns the HSSFSheet this cell belongs to
`Sheet` | `HSSFWorkbook.getSheet(java.lang.String name)` Get sheet with the given name (case insensitive match)
`Sheet` | `HSSFWorkbook.getSheetAt(int index)` Get the HSSFSheet object at the given index.

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` | `DataSources.fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)`
`static ChartDataSource` | `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)`

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