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.