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 voidHSSFRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY) intHSSFWorkbook.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 voidRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY) intWorkbook.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 SheetColumnShifter.sheetprotected final SheetRowShifter.sheetConstructors 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 TypeMethodDescriptionvoidPropertyTemplate.applyBorders(Sheet sheet) Applies the drawn borders to a Sheet.static CellReturn the cell, without taking account of merged regions.static CellSheetUtil.getCellWithMerges(Sheet sheet, int rowIx, int colIx) Return the cell, taking account of merged regions.static doubleSheetUtil.getColumnWidth(Sheet sheet, int column, boolean useMergedCells) Compute width of a column and return the resultstatic doubleSheetUtil.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 RowGet a row from the spreadsheet, and create it if it doesn't exist.static doubleImageUtils.getRowHeightInPixels(Sheet sheet, int rowNum) static voidRegionUtil.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 voidRegionUtil.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 voidRegionUtil.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 voidRegionUtil.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 voidRegionUtil.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 voidRegionUtil.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 voidRegionUtil.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 voidRegionUtil.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 TypeClassDescriptionclassStreaming 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 TypeMethodDescriptionintSXSSFWorkbook.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 TypeClassDescriptionclassHigh level representation of Sheet Parts that are of type 'chartsheet'.classclassHigh 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 voidXSSFRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY) protected voidXSSFPivotCacheDefinition.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 voidXSSFPivotTable.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 tableintXSSFWorkbook.getSheetIndex(Sheet sheet) Returns the index of the given sheetConstructors in org.apache.poi.xssf.usermodel with parameters of type Sheet