Uses of Interface
org.apache.poi.ss.usermodel.Cell
Packages that use Cell
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains classes that implement cell formatting
This package contains common internal POI code for manipulating formulas.
-
Uses of Cell in org.apache.poi.hssf.usermodel
Classes in org.apache.poi.hssf.usermodel that implement CellModifier and TypeClassDescriptionclassHigh level representation of a cell in a row of a spreadsheet.Methods in org.apache.poi.hssf.usermodel that return types with arguments of type CellModifier and TypeMethodDescriptionHSSFRow.cellIterator()HSSFRow.iterator()Alias forHSSFRow.cellIterator()to allow foreach loopsMethods in org.apache.poi.hssf.usermodel with parameters of type CellModifier and TypeMethodDescriptionprotected voidHSSFRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY) protected CellValueHSSFFormulaEvaluator.evaluateFormulaCellValue(Cell cell) Returns a CellValue wrapper around the supplied ValueEval instance.HSSFFormulaEvaluator.evaluateInCell(Cell cell) voidHSSFFormulaEvaluator.notifyDeleteCell(Cell cell) voidHSSFFormulaEvaluator.notifySetFormula(Cell cell) Should be called to tell the cell value cache that the specified (value or formula) cell has changed.voidHSSFFormulaEvaluator.notifyUpdateCell(Cell cell) HSSFSheet.removeArrayFormula(Cell cell) voidHSSFRow.removeCell(Cell cell) remove the HSSFCell from this row. -
Uses of Cell in org.apache.poi.ss.format
Methods in org.apache.poi.ss.format with parameters of type CellModifier and TypeMethodDescriptionFetches the appropriate value from the cell, and uses the result, setting the text and color of a label before returning the result.Fetches the appropriate value from the cell, and returns the result of applying it to the appropriate format.static CellTypeCellFormat.ultimateType(Cell cell) Returns the ultimate cell type, following the results of formulas.static CellTypeCellFormat.ultimateTypeEnum(Cell cell) Deprecated. -
Uses of Cell in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return CellModifier and TypeMethodDescriptionBaseFormulaEvaluator.evaluateInCell(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.Methods in org.apache.poi.ss.formula that return types with arguments of type CellModifier and TypeMethodDescriptionConditionalFormattingEvaluator.getMatchingCells(EvaluationConditionalFormatRule rule) Retrieve all cells where the given formatting rule evaluates to true.ConditionalFormattingEvaluator.getMatchingCells(Sheet sheet, int conditionalFormattingIndex, int ruleIndex) Conditional formatting rules can apply only to cells in the sheet to which they are attached.Methods in org.apache.poi.ss.formula with parameters of type CellModifier and TypeMethodDescriptionIf cell contains a formula, the formula is evaluated and returned, else the CellValue simply copies the appropriate cell value from the cell and also its cell type.BaseFormulaEvaluator.evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.BaseFormulaEvaluator.evaluateFormulaCellEnum(Cell cell) Deprecated.useevaluateFormulaCell(cell)insteadprotected abstract CellValueBaseFormulaEvaluator.evaluateFormulaCellValue(Cell cell) BaseFormulaEvaluator.evaluateInCell(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.ConditionalFormattingEvaluator.getConditionalFormattingForCell(Cell cell) This checks all applicableConditionalFormattingRules for the cell's sheet, in defined "priority" order, returning the matches if any.static CellReferencestatic booleanNote that this assumes the cell cached value is up to date and in sync with data editsstatic booleanDataValidationEvaluator.ValidationEnum.isValid(Cell cell, DataValidationEvaluator.DataValidationContext context) Validates against the type defined in context, as an index of the enum values array.protected booleanDataValidationEvaluator.ValidationEnum.isValidNumericCell(Cell cell, DataValidationEvaluator.DataValidationContext context) Uses the cell value, which may be the cached formula result value.booleanDataValidationEvaluator.ValidationEnum.isValidValue(Cell cell, DataValidationEvaluator.DataValidationContext context) protected voidBaseFormulaEvaluator.setCellType(Cell cell, CellType cellType) Override if a different variation is needed, e.g.protected voidBaseFormulaEvaluator.setCellType(Cell cell, CellValue cv) set the cell typeprotected voidBaseFormulaEvaluator.setCellValue(Cell cell, CellValue cv) -
Uses of Cell in org.apache.poi.ss.usermodel
Classes in org.apache.poi.ss.usermodel with type parameters of type CellMethods in org.apache.poi.ss.usermodel that return CellModifier and TypeMethodDescriptionRow.createCell(int column) Use this to create new cells within the row and return it.Row.createCell(int column, CellType type) Use this to create new cells within the row and return it.FormulaEvaluator.evaluateInCell(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.Row.getCell(int cellnum) Get the cell representing a given column (logical cell) 0-based.Row.getCell(int cellnum, Row.MissingCellPolicy policy) Returns the cell at the given (0 based) index, with the specifiedRow.MissingCellPolicyC[][]CellRange.getCells()C[]CellRange.getFlattenedCells()Methods in org.apache.poi.ss.usermodel that return types with arguments of type CellModifier and TypeMethodDescriptionRow.cellIterator()Sheet.removeArrayFormula(Cell cell) Remove a Array Formula from this sheet.Sheet.setArrayFormula(String formula, CellRangeAddress range) Sets array formula to specified region for result.Methods in org.apache.poi.ss.usermodel with parameters of type CellModifier and TypeMethodDescriptionprotected abstract voidRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY) A range is returned only for the part of the table matching this enum instance and containing the given cell.static voiddefault booleanchecks if the given cell is part of the table.DataFormatter.createFormat(Cell cell) Create and return a Format based on the format string from a cell's style.If cell contains a formula, the formula is evaluated and returned, else the CellValue simply copies the appropriate cell value from the cell and also its cell type.FormulaEvaluator.evaluateFormulaCell(Cell cell) If cell contains formula, it evaluates the formula, and saves the result of the formula.FormulaEvaluator.evaluateFormulaCellEnum(Cell cell) Deprecated.useevaluateFormulaCell(cell)FormulaEvaluator.evaluateInCell(Cell cell) If cell contains formula, it evaluates the formula, and puts the formula result back into the cell, in place of the old formula.DataFormatter.formatCellValue(Cell cell) Returns the formatted value of a cell as a String regardless of the cell type.DataFormatter.formatCellValue(Cell cell, FormulaEvaluator evaluator) Returns the formatted value of a cell as a String regardless of the cell type.DataFormatter.formatCellValue(Cell cell, FormulaEvaluator evaluator, ConditionalFormattingEvaluator cfEvaluator) Returns the formatted value of a cell as a String regardless of the cell type.static ExcelNumberFormatExcelNumberFormat.from(Cell cell, ConditionalFormattingEvaluator cfEvaluator) DataFormatter.getDefaultFormat(Cell cell) Returns a default format for a cell.final CellRangeAddressBasestatic booleanDateUtil.isCellDateFormatted(Cell cell) Check if a cell contains a date Since dates are stored internally in Excel as double values we infer it is a date if it is formatted as such.static booleanDateUtil.isCellDateFormatted(Cell cell, ConditionalFormattingEvaluator cfEvaluator) Check if a cell contains a date Since dates are stored internally in Excel as double values we infer it is a date if it is formatted as such.static booleanDateUtil.isCellInternalDateFormatted(Cell cell) Check if a cell contains a date, checking only for internal excel date formats.voidFormulaEvaluator.notifyDeleteCell(Cell cell) Should be called to tell the cell value cache that the specified cell has just become a formula cell, or the formula text has changedvoidFormulaEvaluator.notifySetFormula(Cell cell) Should be called to tell the cell value cache that the specified (value or formula) cell has changed.voidFormulaEvaluator.notifyUpdateCell(Cell cell) Should be called to tell the cell value cache that the specified (value or formula) cell has changed.Sheet.removeArrayFormula(Cell cell) Remove a Array Formula from this sheet.voidRow.removeCell(Cell cell) Remove the Cell from this row. -
Uses of Cell in org.apache.poi.ss.util
Classes in org.apache.poi.ss.util with type parameters of type CellModifier and TypeClassDescriptionfinal classSSCellRange<K extends Cell>For POI internal use onlyMethods in org.apache.poi.ss.util with type parameters of type CellModifier and TypeMethodDescriptionstatic <B extends Cell>
SSCellRange<B>SSCellRange.create(int firstRow, int firstColumn, int height, int width, List<B> flattenedList, Class<B> cellClass) Methods in org.apache.poi.ss.util that return CellModifier and TypeMethodDescriptionstatic CellCellUtil.createCell(Row row, int column, String value) Create a cell, and give it a value.static CellCellUtil.createCell(Row row, int column, String value, CellStyle style) Creates a cell, gives it a value, and applies a style if providedstatic CellGet a specific cell from a row.static CellReturn the cell, without taking account of merged regions.K[][]SSCellRange.getCells()static CellSheetUtil.getCellWithMerges(Sheet sheet, int rowIx, int colIx) Return the cell, taking account of merged regions.K[]SSCellRange.getFlattenedCells()static CellCellUtil.translateUnicodeValues(Cell cell) Looks for text in the cell that should be unicode, like α and provides the unicode version of it.Methods in org.apache.poi.ss.util with parameters of type CellModifier and TypeMethodDescriptionstatic doubleSheetUtil.getCellWidth(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells) Compute width of a single cellbooleanDetermines if the givenCelllies within the bounds of this range.static voidCellUtil.setAlignment(Cell cell, HorizontalAlignment align) Take a cell, and align it.static voidCellUtil.setCellStyleProperties(Cell cell, Map<String, Object> properties) This method attempts to find an existing CellStyle that matches thecell's current style plus styles properties inproperties.static voidCellUtil.setCellStyleProperty(Cell cell, String propertyName, Object propertyValue) This method attempts to find an existing CellStyle that matches thecell's current style plus a single style propertypropertyNamewith valuepropertyValue.static voidTake a cell, and apply a font to itstatic voidCellUtil.setVerticalAlignment(Cell cell, VerticalAlignment align) Take a cell, and vertically align it.static CellCellUtil.translateUnicodeValues(Cell cell) Looks for text in the cell that should be unicode, like α and provides the unicode version of it.Constructors in org.apache.poi.ss.util with parameters of type CellModifierConstructorDescriptionCellAddress(Cell cell) Create a new CellAddress object.CellReference(Cell cell) -
Uses of Cell in org.apache.poi.ss.util.cellwalk
Methods in org.apache.poi.ss.util.cellwalk with parameters of type Cell -
Uses of Cell in org.apache.poi.xssf.streaming
Classes in org.apache.poi.xssf.streaming that implement CellModifier and TypeClassDescriptionclassStreaming version of XSSFCell implementing the "BigGridDemo" strategy.Methods in org.apache.poi.xssf.streaming that return CellModifier and TypeMethodDescriptionSXSSFRow.CellIterator.next()SXSSFRow.FilledCellIterator.next()Methods in org.apache.poi.xssf.streaming that return types with arguments of type CellModifier and TypeMethodDescriptionSXSSFRow.allCellsIterator()SXSSFRow.cellIterator()SXSSFRow.iterator()SXSSFSheet.removeArrayFormula(Cell cell) Remove a Array Formula from this sheet.SXSSFSheet.setArrayFormula(String formula, CellRangeAddress range) Sets array formula to specified region for result.Methods in org.apache.poi.xssf.streaming with parameters of type CellModifier and TypeMethodDescriptionSXSSFFormulaEvaluator.evaluateInCell(Cell cell) voidSXSSFFormulaEvaluator.notifyDeleteCell(Cell cell) voidSXSSFFormulaEvaluator.notifySetFormula(Cell cell) voidSXSSFFormulaEvaluator.notifyUpdateCell(Cell cell) SXSSFSheet.removeArrayFormula(Cell cell) Remove a Array Formula from this sheet.voidSXSSFRow.removeCell(Cell cell) Remove the Cell from this row.protected EvaluationCellSXSSFFormulaEvaluator.toEvaluationCell(Cell cell) Turns a SXSSFCell into a SXSSFEvaluationCellvoid -
Uses of Cell in org.apache.poi.xssf.usermodel
Classes in org.apache.poi.xssf.usermodel that implement CellModifier and TypeClassDescriptionfinal classHigh level representation of a cell in a row of a spreadsheet.Methods in org.apache.poi.xssf.usermodel that return types with arguments of type CellModifier and TypeMethodDescriptionXSSFRow.cellIterator()Cell iterator over the physically defined cells:XSSFRow.iterator()Alias forXSSFRow.cellIterator()to allow foreach loops:Methods in org.apache.poi.xssf.usermodel with parameters of type CellModifier and TypeMethodDescriptionprotected voidXSSFRangeCopier.adjustCellReferencesInsideFormula(Cell cell, Sheet destSheet, int deltaX, int deltaY) voidXSSFCell.copyCellFrom(Cell srcCell, CellCopyPolicy policy) Copy cell value, formula and style, from srcCell per cell copy policy If srcCell is null, clears the cell value and cell style per cell copy policy This does not shift references in formulas.protected CellValueBaseXSSFFormulaEvaluator.evaluateFormulaCellValue(Cell cell) Returns a CellValue wrapper around the supplied ValueEval instance.XSSFFormulaEvaluator.evaluateInCell(Cell cell) voidXSSFFormulaEvaluator.notifyDeleteCell(Cell cell) voidXSSFFormulaEvaluator.notifySetFormula(Cell cell) voidXSSFFormulaEvaluator.notifyUpdateCell(Cell cell) XSSFSheet.removeArrayFormula(Cell cell) voidXSSFRow.removeCell(Cell cell) Remove the Cell from this row.protected voidBaseXSSFFormulaEvaluator.setCellType(Cell cell, CellType cellType) protected abstract EvaluationCellBaseXSSFFormulaEvaluator.toEvaluationCell(Cell cell) Turns a XSSFCell / SXSSFCell into a XSSFEvaluationCellprotected EvaluationCellXSSFFormulaEvaluator.toEvaluationCell(Cell cell) Turns a XSSFCell into a XSSFEvaluationCell
ultimateTypeinstead