Uses of Package
org.apache.poi.ss.usermodel
-
Packages that use org.apache.poi.ss.usermodel Package Description io.keikai.model Keikai Spreadsheet Internal Book Model classes.io.keikai.model.impl Keikai Spreadsheet Internal Book Model Implementation classes.io.keikai.model.impl.sys.formula Keikai Spreadsheet Internal Book Model Implementation classes.io.keikai.range.impl.imexp Keikai Spreadsheet Internal Range API Implementation classes.io.keikaiex.model.sys org.apache.poi.hssf.extractor org.apache.poi.hssf.model Provides low level API structures for reading, writing, modifying XLS files.org.apache.poi.hssf.record Record package contains class representations for XLS binary strutures.org.apache.poi.hssf.record.aggregates The record aggregates are not real "records" but collections of records that act as a single record.org.apache.poi.hssf.record.cf org.apache.poi.hssf.usermodel The usermodel package maps HSSF low level structures to familiar workbook/sheet modelorg.apache.poi.hssf.util The util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.org.apache.poi.ss.extractor org.apache.poi.ss.format This package contains classes that implement cell formattingorg.apache.poi.ss.formula This package contains common internal POI code for manipulating formulas.org.apache.poi.ss.formula.eval org.apache.poi.ss.formula.eval.forked org.apache.poi.ss.formula.functions org.apache.poi.ss.usermodel org.apache.poi.ss.usermodel.helpers org.apache.poi.ss.util org.apache.poi.ss.util.cellwalk org.apache.poi.xssf.model org.apache.poi.xssf.usermodel -
Classes in org.apache.poi.ss.usermodel used by io.keikai.model Class Description Table XSSF Only! High level abstraction of table in a workbook.TableStyle Data table style definition.TableStyleInfo style information for a specific table instance, referencing the document style and indicating which optional portions of the style to apply. -
Classes in org.apache.poi.ss.usermodel used by io.keikai.model.impl Class Description DifferentialStyleProvider Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.Table XSSF Only! High level abstraction of table in a workbook.TableStyle Data table style definition.TableStyleInfo style information for a specific table instance, referencing the document style and indicating which optional portions of the style to apply.TableStyleType Ordered list of table style elements, for both data tables and pivot tables. -
Classes in org.apache.poi.ss.usermodel used by io.keikai.model.impl.sys.formula Class Description Name Represents a defined name for a range of cells.Table XSSF Only! High level abstraction of table in a workbook. -
Classes in org.apache.poi.ss.usermodel used by io.keikai.range.impl.imexp Class Description AutoFilter Represents autofiltering for the specified worksheet.BorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is bordered dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.Cell High level representation of a cell in a row of a spreadsheet.CellStyle ClientAnchor A client anchor is attached to an excel worksheet.Color ColorFilter CustomFilters DynamicFilter FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.Font HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.Name Represents a defined name for a range of cells.NamedStyle CellStyle with a name.Picture Repersents a picture in a SpreadsheetML documentPictureData RichTextString Rich text unicode string.Row High level representation of a row of a spreadsheet.Sheet High level representation of a Excel worksheet.TableStyle Data table style definition.Top10Filter VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.Workbook High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by io.keikaiex.model.sys Class Description TableStyle Data table style definition. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.extractor Class Description HeaderFooter -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.model Class Description SheetVisibility Specifies sheet visibilityWorkbook High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record Class Description CellType FormulaError Enumerates error values in SpreadsheetML formula calculations.IconMultiStateFormatting.IconSet -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record.aggregates Class Description FormulaError Enumerates error values in SpreadsheetML formula calculations. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record.cf Class Description IconMultiStateFormatting.IconSet -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.usermodel Class Description AutoFilter Represents autofiltering for the specified worksheet.BorderFormatting High level representation for Border Formatting component of Conditional Formatting settingsBorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is bordered dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.Cell High level representation of a cell in a row of a spreadsheet.CellBase Common implementation-independent logic shared by all implementations ofCell
.CellCopyContext Used when the cells are being copied from one workbook to another.CellCopyPolicy CellRange Represents a rectangular region of aSheet
CellReferenceType Types of cell references.CellStyle CellType CellValue Mimics the 'data view' of a cell.ChildAnchor Common interface for anchors.ClientAnchor A client anchor is attached to an excel worksheet.ClientAnchor.AnchorType Color ColorScaleFormatting High level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settingsComment ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.ConditionalFormattingRule Represents a description of a conditional formatting ruleConditionalFormattingThreshold The Threshold / CFVO / Conditional Formatting Value Object.ConditionalFormattingThreshold.RangeType ConditionFilterData These values are needed by various conditional formatting evaluation filter typesConditionFilterType Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.ConditionType Represents a type of a conditional formatting ruleCreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.DataBarFormatting High level representation for the DataBar Formatting component of Conditional Formatting settingsDataFormat DataFormatter DataFormatter contains methods for formatting the value stored in a Cell.DataValidation DataValidationConstraint DataValidationHelper DifferentialStyleProvider Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.Drawing High level representation of spreadsheet drawing.ExcelNumberFormat Object to hold a number format index and string, for various formatting evaluationsExtendedColor Represents a XSSF-style color (based on either aXSSFColor
or aExtendedColor
FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.Font FontFormatting High level representation for Font Formatting component of Conditional Formatting settingsFooter Common definition of a HSSF or XSSF page footer.FormulaError Enumerates error values in SpreadsheetML formula calculations.FormulaEvaluator Evaluates formula cells.Header Common definition of a HSSF or XSSF page header.HeaderFooter HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.Hyperlink Represents an Excel hyperlink.IconMultiStateFormatting High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settingsIconMultiStateFormatting.IconSet Name Represents a defined name for a range of cells.ObjectData Common interface for OLE shapes, i.e.PageMargin Enumeration which represents the various margins which are present within an Excel worksheetPaneType Type of pane used in sheet.PatternFormatting Picture Repersents a picture in a SpreadsheetML documentPictureData PrintSetup RangeCopier RichTextString Rich text unicode string.Row High level representation of a row of a spreadsheet.Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cellsShape Common interface for all drawing shapesShapeContainer A common interface for shape groups.Sheet High level representation of a Excel worksheet.SheetConditionalFormatting The 'Conditional Formatting' facet ofSheet
SheetProtection Enhanced sheet protection.SheetVisibility Specifies sheet visibilitySimpleShape A common interface for simple shapes.Table XSSF Only! High level abstraction of table in a workbook.VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.Workbook High level representation of a Excel workbook.WorkbookProvider -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.util Class Description Color -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.extractor Class Description Picture Repersents a picture in a SpreadsheetML documentShape Common interface for all drawing shapesShapeContainer A common interface for shape groups.Sheet High level representation of a Excel worksheet. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.format Class Description Cell High level representation of a cell in a row of a spreadsheet.CellType -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula Class Description Cell High level representation of a cell in a row of a spreadsheet.CellType CellValue Mimics the 'data view' of a cell.ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.ConditionalFormattingRule Represents a description of a conditional formatting ruleConditionType Represents a type of a conditional formatting ruleDataValidation ExcelNumberFormat Object to hold a number format index and string, for various formatting evaluationsFormulaEvaluator Evaluates formula cells.Hyperlink Represents an Excel hyperlink.Name Represents a defined name for a range of cells.RichTextString Rich text unicode string.Sheet High level representation of a Excel worksheet.Table XSSF Only! High level abstraction of table in a workbook.Workbook High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.eval Class Description Hyperlink Represents an Excel hyperlink. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.eval.forked Class Description Workbook High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.functions Class Description DataFormatter DataFormatter contains methods for formatting the value stored in a Cell. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodel Class Description AutoFilter Represents autofiltering for the specified worksheet.BorderExtent The enumeration value indicating which borders to draw in a Property TemplateBorderFormatting High level representation for Border Formatting component of Conditional Formatting settingsBorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is bordered dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.Cell High level representation of a cell in a row of a spreadsheet.CellCopyPolicy CellCopyPolicy.Builder CellRange Represents a rectangular region of aSheet
CellReferenceType Types of cell references.CellStyle CellType CellValue Mimics the 'data view' of a cell.ChildAnchor Common interface for anchors.ClientAnchor A client anchor is attached to an excel worksheet.ClientAnchor.AnchorType Color ColorFilter ColorScaleFormatting High level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settingsComment ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.ConditionalFormattingRule Represents a description of a conditional formatting ruleConditionalFormattingThreshold The Threshold / CFVO / Conditional Formatting Value Object.ConditionalFormattingThreshold.RangeType ConditionFilterData These values are needed by various conditional formatting evaluation filter typesConditionFilterType Used primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.ConditionType Represents a type of a conditional formatting ruleCreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.CustomFilter CustomFilterCustomFilter.Operator CustomFilters DataBarFormatting High level representation for the DataBar Formatting component of Conditional Formatting settingsDataConsolidateFunction Enum mapping the values of STDataConsolidateFunctionDataFormat DataValidation DataValidationConstraint DataValidationHelper DifferentialStyleProvider Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.Drawing High level representation of spreadsheet drawing.DxfCellStyle Cell style for DxfsDynamicFilter ExcelNumberFormat Object to hold a number format index and string, for various formatting evaluationsExtendedColor Represents a XSSF-style color (based on either aXSSFColor
or aExtendedColor
FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.Font FontCharset Deprecated.enum will be replaced by common version org.apache.poi.common.usermodel.FontCharsetFontFamily The font family this font belongs to.FontFormatting High level representation for Font Formatting component of Conditional Formatting settingsFontScheme Defines the font scheme to which this font belongs.FontUnderline the different types of possible underline formattingFooter Common definition of a HSSF or XSSF page footer.FormulaError Enumerates error values in SpreadsheetML formula calculations.FormulaEvaluator Evaluates formula cells.Header Common definition of a HSSF or XSSF page header.HeaderFooter HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.Hyperlink Represents an Excel hyperlink.IconMultiStateFormatting High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settingsIconMultiStateFormatting.IconSet IgnoredErrorType Types of ignored workbook and worksheet error.IndexedColors A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats.Name Represents a defined name for a range of cells.ObjectData Common interface for OLE shapes, i.e.PageMargin Enumeration which represents the various margins which are present within an Excel worksheetPageOrder Specifies printed page order.PaneType Type of pane used in sheet.PaperSize The enumeration value indicating the possible paper size for a sheetPatternFormatting Picture Repersents a picture in a SpreadsheetML documentPictureData PrintCellComments These enumerations specify how cell comments shall be displayed for paper printing purposes.PrintOrientation The enumeration value indicating the print orientation for a sheet.PrintSetup ReadingOrder The enumeration value indicating reading order of a cell, i.e., whether the reading order is Context(Default), Left To Right or Right To LeftRichTextString Rich text unicode string.Row High level representation of a row of a spreadsheet.Row.MissingCellPolicy Used to specify the different possible policies if for the case of null and blank cellsShape Common interface for all drawing shapesShapeContainer A common interface for shape groups.Sheet High level representation of a Excel worksheet.SheetConditionalFormatting The 'Conditional Formatting' facet ofSheet
SheetVisibility Specifies sheet visibilitySimpleShape A common interface for simple shapes.Table XSSF Only! High level abstraction of table in a workbook.TableStyle Data table style definition.TableStyleInfo style information for a specific table instance, referencing the document style and indicating which optional portions of the style to apply.TableStyleType Ordered list of table style elements, for both data tables and pivot tables.Top10Filter VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.Workbook High level representation of a Excel workbook.WorkbookProvider ZssContext Keikai Spreadsheet context for cell evaluation, etc. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodel.helpers Class Description Sheet High level representation of a Excel worksheet. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.util Class Description BorderExtent The enumeration value indicating which borders to draw in a Property TemplateBorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is bordered dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.Cell High level representation of a cell in a row of a spreadsheet.CellCopyContext Used when the cells are being copied from one workbook to another.CellCopyPolicy CellRange Represents a rectangular region of aSheet
CellStyle DataFormatter DataFormatter contains methods for formatting the value stored in a Cell.Font HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.PaneType Type of pane used in sheet.Picture Repersents a picture in a SpreadsheetML documentRow High level representation of a row of a spreadsheet.Sheet High level representation of a Excel worksheet.VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.Workbook High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.util.cellwalk Class Description Cell High level representation of a cell in a row of a spreadsheet.Sheet High level representation of a Excel worksheet. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.model Class Description TableStyle Data table style definition. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel Class Description BorderStyle The enumeration value indicating the line style of a border in a cell, i.e., whether it is bordered dash dot, dash dot dot, dashed, dotted, double, hair, medium, medium dash dot, medium dash dot dot, medium dashed, none, slant dash dot, thick or thin.CellStyle Color ColorFilter ConditionalFormatting The ConditionalFormatting class encapsulates all settings of Conditional Formatting.CustomFilter CustomFilterCustomFilter.Operator CustomFilters DxfCellStyle Cell style for DxfsDynamicFilter FillPatternType The enumeration value indicating the style of fill pattern being used for a cell format.FilterColumn Represent a filtered column.Font HorizontalAlignment The enumeration value indicating horizontal alignment of a cell, i.e., whether it is aligned general, left, right, horizontally centered, filled (replicated), justified, centered across multiple cells, or distributed.NamedStyle CellStyle with a name.SheetProtection Enhanced sheet protection.Top10Filter VerticalAlignment This enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.