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 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.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 Picture.getSheet()
           
 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 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.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 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 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.
 

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 Iterator iterator() was replaced with Iterator iterator() to make iterating over a container (Workbook, Sheet, Row) consistent across POI spreadsheets.
 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 and set area of source, source sheet and a position for pivot table
protected  void XSSFPivotTable.createSourceReferences(AreaReference source, CellReference position, Sheet sourceSheet)
          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
 



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