Uses of Package
org.apache.poi.ss.usermodel
-
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.hssf.converter 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 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.Sheet High level representation of a Excel worksheet. -
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 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.CellRange Represents a rectangular region of aSheet
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 an Cell.DataValidation DataValidationConstraint DataValidationHelper DateUtil Contains methods for dealing with Excel dates.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.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 of SheetSheetVisibility 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.WorkbookFactory Factory for creating the appropriate kind of Workbook (be itHSSFWorkbook
or XSSFWorkbook), by auto-detecting from the supplied input. -
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.poifs.crypt.temp Class Description Workbook High level representation of a Excel workbook. -
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.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.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 an 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
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 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.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.PageOrder Specifies printed page order.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 of SheetSheetVisibility 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.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.usermodel.charts Class Description Chart Deprecated.Sheet High level representation of a Excel worksheet. -
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.CellRange Represents a rectangular region of aSheet
CellStyle DataFormatter DataFormatter contains methods for formatting the value stored in an 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.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.util Class Description Workbook High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.binary Class Description DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.RichTextString Rich text unicode string. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.eventusermodel Class Description DataFormatter DataFormatter contains methods for formatting the value stored in an Cell.RichTextString Rich text unicode string. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.model Class Description Color Name Represents a defined name for a range of cells.RichTextString Rich text unicode string.TableStyle Data table style definition. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.streaming Class Description AutoFilter Represents autofiltering for the specified worksheet.Cell High level representation of a cell in a row of a spreadsheet.CellRange Represents a rectangular region of aSheet
CellStyle CellType ClientAnchor A client anchor is attached to an excel worksheet.Comment CreationHelper An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF.DataFormat DataValidation DataValidationHelper Drawing High level representation of spreadsheet drawing.ExtendedColor Represents a XSSF-style color (based on either aXSSFColor
or aExtendedColor
Font Footer Common definition of a HSSF or XSSF page footer.FormulaEvaluator Evaluates formula cells.Header Common definition of a HSSF or XSSF page header.Hyperlink Represents an Excel hyperlink.Name Represents a defined name for a range of cells.ObjectData Common interface for OLE shapes, i.e.Picture Repersents a picture in a SpreadsheetML documentPictureData PrintSetup 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 of SheetSheetVisibility Specifies sheet visibilityWorkbook High level representation of a Excel workbook. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.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.CellCopyPolicy CellRange Represents a rectangular region of aSheet
CellStyle CellType CellValue Mimics the 'data view' of a cell.Chart Deprecated.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 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.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.PageOrder Specifies printed page order.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 RangeCopier 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 of SheetSheetVisibility 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.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.WorkbookFactory Factory for creating the appropriate kind of Workbook (be itHSSFWorkbook
or XSSFWorkbook), by auto-detecting from the supplied input. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.charts Class Description Chart Deprecated. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.extensions 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.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.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 LeftVerticalAlignment 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. -
Classes in org.apache.poi.ss.usermodel used by org.apache.poi.xssf.usermodel.helpers Class Description CellStyle IgnoredErrorType Types of ignored workbook and worksheet error.