Uses of Package
org.apache.poi.ss.usermodel
Packages that use org.apache.poi.ss.usermodel
Package
Description
Provides low level API structures for reading, writing, modifying XLS files.
Record package contains class representations for XLS binary strutures.
The record aggregates are not real "records" but collections of records that act as a single record.
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
The util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts.
This package contains classes that implement cell formatting
This package contains common internal POI code for manipulating formulas.
The org.apache.poi.xssf.binary package includes necessary underlying components
for streaming/read-only processing of xlsb files.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.converterClassDescriptionThe 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.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.extractor
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.modelClassDescriptionSpecifies sheet visibilityHigh level representation of a Excel workbook.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.recordClassDescriptionEnumerates error values in SpreadsheetML formula calculations.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record.aggregates
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.record.cf
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.usermodelClassDescriptionRepresents autofiltering for the specified worksheet.High level representation for Border Formatting component of Conditional Formatting settingsThe 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.High level representation of a cell in a row of a spreadsheet.Common implementation-independent logic shared by all implementations of
Cell.Used when the cells are being copied from one workbook to another.The CellPropertyType enum represents the different types of cell properties that can be applied to a cell.Represents a rectangular region of aSheetTypes of cell references.Mimics the 'data view' of a cell.Common interface for anchors.A client anchor is attached to an excel worksheet.High level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settingsThe ConditionalFormatting class encapsulates all settings of Conditional Formatting.Represents a description of a conditional formatting ruleThe Threshold / CFVO / Conditional Formatting Value Object.These values are needed by various conditional formatting evaluation filter typesUsed primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.Represents a type of a conditional formatting ruleAn object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.High level representation for the DataBar Formatting component of Conditional Formatting settingsDataFormatter contains methods for formatting the value stored in a Cell.Interface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.High level representation of spreadsheet drawing.Object to hold a number format index and string, for various formatting evaluationsRepresents a XSSF-style color (based on either a org.apache.poi.xssf.usermodel.XSSFColor or aExtendedColorThe enumeration value indicating the style of fill pattern being used for a cell format.High level representation for Font Formatting component of Conditional Formatting settingsCommon definition of a HSSF or XSSF page footer.Enumerates error values in SpreadsheetML formula calculations.Evaluates formula cells.Common definition of a HSSF or XSSF page header.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.Represents an Excel hyperlink.High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settingsRepresents a defined name for a range of cells.Common interface for OLE shapes, i.e.Enumeration which represents the various margins which are present within an Excel worksheetType of pane used in sheet.Repersents a picture in a SpreadsheetML documentRich text unicode string.High level representation of a row of a spreadsheet.Used to specify the different possible policies if for the case of null and blank cellsCommon interface for all drawing shapesA common interface for shape groups.High level representation of a Excel worksheet.The 'Conditional Formatting' facet ofSheetSpecifies sheet visibilityA common interface for simple shapes.XSSF Only! High level abstraction of table in a workbook.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.High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.util
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.poifs.crypt.temp
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.excelant
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.excelant.utilClassDescriptionEvaluates formula cells.High level representation of a Excel workbook.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.extractorClassDescriptionRepersents a picture in a SpreadsheetML documentCommon interface for all drawing shapesA common interface for shape groups.High level representation of a Excel worksheet.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.format
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formulaClassDescriptionHigh level representation of a cell in a row of a spreadsheet.Mimics the 'data view' of a cell.The ConditionalFormatting class encapsulates all settings of Conditional Formatting.Represents a description of a conditional formatting ruleRepresents a type of a conditional formatting ruleObject to hold a number format index and string, for various formatting evaluationsEvaluates formula cells.Represents a defined name for a range of cells.Rich text unicode string.High level representation of a Excel worksheet.XSSF Only! High level abstraction of table in a workbook.High level representation of a Excel workbook.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.eval.forked
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.formula.functionsClassDescriptionDataFormatter contains methods for formatting the value stored in a Cell.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodelClassDescriptionRepresents autofiltering for the specified worksheet.The enumeration value indicating which borders to draw in a Property TemplateHigh level representation for Border Formatting component of Conditional Formatting settingsThe 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.High level representation of a cell in a row of a spreadsheet.The CellPropertyCategory enum represents the different categories of cell properties.The CellPropertyType enum represents the different types of cell properties that can be applied to a cell.Represents a rectangular region of a
SheetTypes of cell references.Mimics the 'data view' of a cell.Common interface for anchors.A client anchor is attached to an excel worksheet.High level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settingsThe ConditionalFormatting class encapsulates all settings of Conditional Formatting.Represents a description of a conditional formatting ruleThe Threshold / CFVO / Conditional Formatting Value Object.These values are needed by various conditional formatting evaluation filter typesUsed primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.Represents a type of a conditional formatting ruleAn object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.High level representation for the DataBar Formatting component of Conditional Formatting settingsEnum mapping the values of STDataConsolidateFunctionInterface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.High level representation of spreadsheet drawing.Object to hold a number format index and string, for various formatting evaluationsRepresents a XSSF-style color (based on either a org.apache.poi.xssf.usermodel.XSSFColor or aExtendedColorThe enumeration value indicating the style of fill pattern being used for a cell format.The font family this font belongs to.High level representation for Font Formatting component of Conditional Formatting settingsDefines the font scheme to which this font belongs.the different types of possible underline formattingCommon definition of a HSSF or XSSF page footer.Enumerates error values in SpreadsheetML formula calculations.Evaluates formula cells.Common definition of a HSSF or XSSF page header.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.Represents an Excel hyperlink.High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settingsTypes of ignored workbook and worksheet error.A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats.Represents a defined name for a range of cells.Common interface for OLE shapes, i.e.Enumeration which represents the various margins which are present within an Excel worksheetSpecifies printed page order.Type of pane used in sheet.The enumeration value indicating the possible paper size for a sheetRepersents a picture in a SpreadsheetML documentThese enumerations specify how cell comments shall be displayed for paper printing purposes.The enumeration value indicating the print orientation for a sheet.The enumeration value indicating reading order of a cell, i.e., whether the reading order is Context(Default), Left To Right or Right To LeftRich text unicode string.High level representation of a row of a spreadsheet.Used to specify the different possible policies if for the case of null and blank cellsCommon interface for all drawing shapesA common interface for shape groups.High level representation of a Excel worksheet.The 'Conditional Formatting' facet ofSheetSpecifies sheet visibilityA common interface for simple shapes.XSSF Only! High level abstraction of table in a workbook.Data table style definition.style information for a specific table instance, referencing the document style and indicating which optional portions of the style to apply.Ordered list of table style elements, for both data tables and pivot tables.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.High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.usermodel.helpers
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.utilClassDescriptionThe enumeration value indicating which borders to draw in a Property TemplateThe 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.High level representation of a cell in a row of a spreadsheet.Used when the cells are being copied from one workbook to another.The CellPropertyType enum represents the different types of cell properties that can be applied to a cell.Represents a rectangular region of a
SheetA client anchor is attached to an excel worksheet.DataFormatter contains methods for formatting the value stored in a Cell.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.Type of pane used in sheet.Repersents a picture in a SpreadsheetML documentHigh level representation of a row of a spreadsheet.High level representation of a Excel worksheet.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.High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.ss.util.cellwalk
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.binaryClassDescriptionA client anchor is attached to an excel worksheet.DataFormatter contains methods for formatting the value stored in a Cell.Object to hold a number format index and string, for various formatting evaluationsEnumerates error values in SpreadsheetML formula calculations.Rich text unicode string.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.eventusermodelClassDescriptionDataFormatter contains methods for formatting the value stored in a Cell.Rich text unicode string.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.extractor
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.modelClassDescriptionA client anchor is attached to an excel worksheet.Represents a defined name for a range of cells.Rich text unicode string.High level representation of a Excel worksheet.Data table style definition.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.streamingClassDescriptionRepresents autofiltering for the specified worksheet.High level representation of a cell in a row of a spreadsheet.Common implementation-independent logic shared by all implementations of
Cell.Represents a rectangular region of aSheetTypes of cell references.A client anchor is attached to an excel worksheet.An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.High level representation of spreadsheet drawing.Represents a XSSF-style color (based on either a org.apache.poi.xssf.usermodel.XSSFColor or aExtendedColorCommon definition of a HSSF or XSSF page footer.Evaluates formula cells.Common definition of a HSSF or XSSF page header.Represents an Excel hyperlink.Represents a defined name for a range of cells.Common interface for OLE shapes, i.e.Enumeration which represents the various margins which are present within an Excel worksheetType of pane used in sheet.Repersents a picture in a SpreadsheetML documentRich text unicode string.High level representation of a row of a spreadsheet.Used to specify the different possible policies if for the case of null and blank cellsCommon interface for all drawing shapesA common interface for shape groups.High level representation of a Excel worksheet.The 'Conditional Formatting' facet ofSheetSpecifies sheet visibilityHigh level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodelClassDescriptionRepresents autofiltering for the specified worksheet.High level representation for Border Formatting component of Conditional Formatting settingsThe 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.High level representation of a cell in a row of a spreadsheet.Common implementation-independent logic shared by all implementations of
Cell.Used when the cells are being copied from one workbook to another.The CellPropertyType enum represents the different types of cell properties that can be applied to a cell.Represents a rectangular region of aSheetTypes of cell references.Mimics the 'data view' of a cell.Common interface for anchors.A client anchor is attached to an excel worksheet.High level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settingsThe ConditionalFormatting class encapsulates all settings of Conditional Formatting.Represents a description of a conditional formatting ruleThe Threshold / CFVO / Conditional Formatting Value Object.These values are needed by various conditional formatting evaluation filter typesUsed primarily for XSSF conditions, which defines a multitude of additional "filter" types for conditional formatting.Represents a type of a conditional formatting ruleAn object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.High level representation for the DataBar Formatting component of Conditional Formatting settingsEnum mapping the values of STDataConsolidateFunctionInterface for classes providing differential style definitions, such as conditional format rules and table/pivot table styles.High level representation of spreadsheet drawing.Object to hold a number format index and string, for various formatting evaluationsRepresents a XSSF-style color (based on either a org.apache.poi.xssf.usermodel.XSSFColor or aExtendedColorThe enumeration value indicating the style of fill pattern being used for a cell format.The font family this font belongs to.High level representation for Font Formatting component of Conditional Formatting settingsDefines the font scheme to which this font belongs.the different types of possible underline formattingCommon definition of a HSSF or XSSF page footer.Enumerates error values in SpreadsheetML formula calculations.Evaluates formula cells.Common definition of a HSSF or XSSF page header.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.Represents an Excel hyperlink.High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settingsTypes of ignored workbook and worksheet error.A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats.Represents a defined name for a range of cells.Common interface for OLE shapes, i.e.Enumeration which represents the various margins which are present within an Excel worksheetSpecifies printed page order.Type of pane used in sheet.The enumeration value indicating the possible paper size for a sheetRepersents a picture in a SpreadsheetML documentThese enumerations specify how cell comments shall be displayed for paper printing purposes.The enumeration value indicating the print orientation for a sheet.The enumeration value indicating reading order of a cell, i.e., whether the reading order is Context(Default), Left To Right or Right To LeftRich text unicode string.High level representation of a row of a spreadsheet.Used to specify the different possible policies if for the case of null and blank cellsCommon interface for all drawing shapesA common interface for shape groups.High level representation of a Excel worksheet.The 'Conditional Formatting' facet ofSheetSpecifies sheet visibilityA common interface for simple shapes.XSSF Only! High level abstraction of table in a workbook.Data table style definition.style information for a specific table instance, referencing the document style and indicating which optional portions of the style to apply.Ordered list of table style elements, for both data tables and pivot tables.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.High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.extensionsClassDescriptionThe 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.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.The enumeration value indicating reading order of a cell, i.e., whether the reading order is Context(Default), Left To Right or Right To LeftThis enumeration value indicates the type of vertical alignment for a cell, i.e., whether it is aligned top, bottom, vertically centered, justified or distributed.
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.helpers