Uses of Interface
org.apache.poi.ss.usermodel.Sheet
Packages that use Sheet
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains common internal POI code for manipulating formulas.
-
Uses of Sheet in org.apache.poi.hssf.converter
Methods in org.apache.poi.hssf.converter with parameters of type SheetModifier and TypeMethodDescriptionstatic CellRangeAddress[][]
ExcelToHtmlUtils.buildMergedRangesMap
(Sheet sheet) Creates a map (i.e. -
Uses of Sheet in org.apache.poi.hssf.usermodel
Classes in org.apache.poi.hssf.usermodel that implement SheetMethods in org.apache.poi.hssf.usermodel that return types with arguments of type SheetModifier and TypeMethodDescriptionHSSFWorkbook.iterator()
Alias forHSSFWorkbook.sheetIterator()
to allow foreach loopsHSSFWorkbook.sheetIterator()
Returns an iterator of the sheets in the workbook in sheet order.Methods in org.apache.poi.hssf.usermodel with parameters of type SheetModifier and TypeMethodDescriptionprotected void
HSSFRangeCopier.adjustCellReferencesInsideFormula
(Cell cell, Sheet destSheet, int deltaX, int deltaY) int
HSSFWorkbook.getSheetIndex
(Sheet sheet) Returns the index of the given sheetConstructors in org.apache.poi.hssf.usermodel with parameters of type Sheet -
Uses of Sheet in org.apache.poi.ss.extractor
Methods in org.apache.poi.ss.extractor with parameters of type Sheet -
Uses of Sheet in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return SheetMethods in org.apache.poi.ss.formula with parameters of type SheetModifier and TypeMethodDescriptionConditionalFormattingEvaluator.getFormatRulesForSheet
(Sheet sheet) Retrieve all formatting rules for the given sheet.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 List
<EvaluationConditionalFormatRule> lazy load by sheet since reading can be expensiveConstructors in org.apache.poi.ss.formula with parameters of type SheetModifierConstructorDescriptionEvaluationConditionalFormatRule
(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 SheetModifier and TypeMethodDescriptionWorkbook.cloneSheet
(int sheetNum) Create an Sheet from an existing sheet in the Workbook.Workbook.createSheet()
Create a Sheet for this Workbook, adds it to the sheets and returns the high level representation.Workbook.createSheet
(String sheetname) Create a new sheet for this Workbook and return the high level representation.Cell.getSheet()
Returns the sheet this cell belongs toPicture.getSheet()
Row.getSheet()
Returns the Sheet this row belongs toGet sheet with the given nameWorkbook.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 SheetModifier and TypeMethodDescriptionWorkbook.sheetIterator()
Returns an iterator of the sheets in the workbook in sheet order.Methods in org.apache.poi.ss.usermodel with parameters of type SheetModifier and TypeMethodDescriptionprotected abstract void
RangeCopier.adjustCellReferencesInsideFormula
(Cell cell, Sheet destSheet, int deltaX, int deltaY) int
Workbook.getSheetIndex
(Sheet sheet) Returns the index of the given sheetConstructors in org.apache.poi.ss.usermodel with parameters of type SheetModifierConstructorDescriptionRangeCopier
(Sheet sheet) RangeCopier
(Sheet sourceSheet, Sheet destSheet) -
Uses of Sheet in org.apache.poi.ss.usermodel.charts
Methods in org.apache.poi.ss.usermodel.charts with parameters of type SheetModifier and TypeMethodDescriptionstatic ChartDataSource
<Number> DataSources.fromNumericCellRange
(Sheet sheet, CellRangeAddress cellRangeAddress) Deprecated.static ChartDataSource
<String> DataSources.fromStringCellRange
(Sheet sheet, CellRangeAddress cellRangeAddress) Deprecated. -
Uses of Sheet in org.apache.poi.ss.usermodel.helpers
Fields in org.apache.poi.ss.usermodel.helpers declared as SheetModifier and TypeFieldDescriptionprotected final Sheet
ColumnShifter.sheet
protected final Sheet
RowShifter.sheet
Constructors in org.apache.poi.ss.usermodel.helpers with parameters of type Sheet -
Uses of Sheet in org.apache.poi.ss.util
Methods in org.apache.poi.ss.util that return SheetModifier and TypeMethodDescriptionSheetBuilder.build()
Builds sheet from parent workbook and 2D array with cell values.Methods in org.apache.poi.ss.util with parameters of type SheetModifier and TypeMethodDescriptionvoid
PropertyTemplate.applyBorders
(Sheet sheet) Applies the drawn borders to a Sheet.static Cell
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 resultstatic 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 resultstatic Row
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 bottomstatic 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 leftstatic 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 rightstatic 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 topstatic 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 bottomstatic 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 leftstatic 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 rightstatic 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 -
Uses of Sheet in org.apache.poi.xssf.streaming
Classes in org.apache.poi.xssf.streaming that implement SheetModifier and TypeClassDescriptionclass
Streaming version of XSSFSheet implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming that return SheetModifier and TypeMethodDescriptionSXSSFWorkbook.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 SheetModifier and TypeMethodDescriptionSXSSFWorkbook.iterator()
Alias forSXSSFWorkbook.sheetIterator()
to allow foreach loopsSXSSFWorkbook.sheetIterator()
Returns an iterator of the sheets in the workbook in sheet order.Methods in org.apache.poi.xssf.streaming with parameters of type SheetModifier and TypeMethodDescriptionint
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 SheetModifier and TypeClassDescriptionclass
High level representation of Sheet Parts that are of type 'chartsheet'.class
class
High level representation of a SpreadsheetML worksheet.Methods in org.apache.poi.xssf.usermodel that return SheetMethods in org.apache.poi.xssf.usermodel that return types with arguments of type SheetModifier and TypeMethodDescriptionXSSFWorkbook.iterator()
Alias forXSSFWorkbook.sheetIterator()
to allow foreach loops Note: remove() is not supported on this iterator.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 SheetModifier and TypeMethodDescriptionprotected void
XSSFRangeCopier.adjustCellReferencesInsideFormula
(Cell cell, Sheet destSheet, int deltaX, int deltaY) protected void
XSSFPivotCacheDefinition.createCacheFields
(Sheet sheet) Generates a cache field for each column in the reference area for the pivot table.XSSFSheet.createPivotTable
(Name source, CellReference position, Sheet sourceSheet) Create a pivot table using the Name range reference on sourceSheet, at the given position.XSSFSheet.createPivotTable
(AreaReference source, CellReference position, Sheet sourceSheet) Create a pivot table using the AreaReference range 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 tableint
XSSFWorkbook.getSheetIndex
(Sheet sheet) Returns the index of the given sheetConstructors in org.apache.poi.xssf.usermodel with parameters of type Sheet