Uses of Interface
org.apache.poi.ss.usermodel.Sheet
-
Packages that use Sheet Package Description org.apache.poi.hssf.converter org.apache.poi.hssf.usermodel usermodel package maps HSSF low level strutures to familiar workbook/sheet modelorg.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.converter
Methods in org.apache.poi.hssf.converter with parameters of type Sheet Modifier and Type Method Description static 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 Sheet Modifier and Type Class Description class
HSSFSheet
High level representation of a worksheet.Methods in org.apache.poi.hssf.usermodel that return types with arguments of type Sheet Modifier and Type Method Description java.util.Iterator<Sheet>
HSSFWorkbook. iterator()
Alias forHSSFWorkbook.sheetIterator()
to allow foreach loopsjava.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 Modifier and Type Method Description protected 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 Constructor Description HSSFRangeCopier(Sheet sourceSheet, Sheet destSheet)
-
Uses of Sheet in org.apache.poi.ss.extractor
Methods in org.apache.poi.ss.extractor with parameters of type Sheet Modifier and Type Method Description 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 Modifier and Type Method Description Sheet
EvaluationConditionalFormatRule. getSheet()
Methods in org.apache.poi.ss.formula with parameters of type Sheet Modifier and Type Method Description java.util.List<EvaluationConditionalFormatRule>
ConditionalFormattingEvaluator. getFormatRulesForSheet(Sheet sheet)
Retrieve all formatting rules for the given 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 expensiveConstructors in org.apache.poi.ss.formula with parameters of type Sheet Constructor Description 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 Modifier and Type Method Description 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 toSheet
Picture. getSheet()
Sheet
Row. getSheet()
Returns the Sheet this row belongs toSheet
Workbook. getSheet(java.lang.String name)
Get sheet with the given nameSheet
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 Modifier and Type Method Description 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 Modifier and Type Method Description protected 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 Sheet Constructor Description RangeCopier(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 Sheet Modifier and Type Method Description static ChartDataSource<java.lang.Number>
DataSources. fromNumericCellRange(Sheet sheet, CellRangeAddress cellRangeAddress)
Deprecated.static ChartDataSource<java.lang.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 Sheet Modifier and Type Field Description protected Sheet
ColumnShifter. sheet
protected Sheet
RowShifter. sheet
Constructors in org.apache.poi.ss.usermodel.helpers with parameters of type Sheet Constructor Description ColumnShifter(Sheet sh)
RowShifter(Sheet sh)
-
Uses of Sheet in org.apache.poi.ss.util
Methods in org.apache.poi.ss.util that return Sheet Modifier and Type Method Description 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 Modifier and Type Method Description 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 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
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 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 Constructor Description CellWalk(Sheet sheet, CellRangeAddress range)
-
Uses of Sheet in org.apache.poi.xssf.streaming
Classes in org.apache.poi.xssf.streaming that implement Sheet Modifier and Type Class Description class
SXSSFSheet
Streaming version of XSSFSheet implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming that return Sheet Modifier and Type Method Description 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 Modifier and Type Method Description java.util.Iterator<Sheet>
SXSSFWorkbook. iterator()
Alias forSXSSFWorkbook.sheetIterator()
to allow foreach loopsjava.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 Modifier and Type Method Description 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 Modifier and Type Class Description 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 Modifier and Type Method Description Sheet
XSSFPivotTable. getDataSheet()
Sheet
XSSFPivotTable. getParentSheet()
Methods in org.apache.poi.xssf.usermodel that return types with arguments of type Sheet Modifier and Type Method Description java.util.Iterator<Sheet>
XSSFWorkbook. iterator()
Alias forXSSFWorkbook.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 Modifier and Type Method Description protected 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.XSSFPivotTable
XSSFSheet. createPivotTable(Name source, CellReference position, Sheet sourceSheet)
Create a pivot table using the Name range reference on sourceSheet, at the given position.XSSFPivotTable
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 Constructor Description XSSFRangeCopier(Sheet sourceSheet, Sheet destSheet)
-