Class and 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.
|
Class and Description |
---|
HeaderFooter |
Class and Description |
---|
SheetVisibility
Specifies sheet visibility
|
Workbook
High level representation of a Excel workbook.
|
Class and Description |
---|
FormulaError
Enumerates error values in SpreadsheetML formula calculations.
|
IconMultiStateFormatting.IconSet |
Class and Description |
---|
FormulaError
Enumerates error values in SpreadsheetML formula calculations.
|
Class and Description |
---|
IconMultiStateFormatting.IconSet |
Class and Description |
---|
AutoFilter
Represents autofiltering for the specified worksheet.
|
BorderFormatting
High level representation for Border Formatting component
of Conditional Formatting settings
|
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.
|
CellBase
Common implementation-independent logic shared by all implementations of
Cell . |
CellRange
Represents a rectangular region of a
Sheet |
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 settings
|
Comment |
ConditionalFormatting
The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
|
ConditionalFormattingRule
Represents a description of a conditional formatting rule
|
ConditionalFormattingThreshold
The Threshold / CFVO / Conditional Formatting Value Object.
|
ConditionalFormattingThreshold.RangeType |
ConditionFilterData
These values are needed by various conditional formatting evaluation filter types
|
ConditionFilterType
Used primarily for XSSF conditions, which defines a multitude of additional "filter" types
for conditional formatting.
|
ConditionType
Represents a type of a conditional formatting rule
|
CreationHelper
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 settings
|
DataFormat |
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 evaluations
|
ExtendedColor
Represents a XSSF-style color (based on either a
XSSFColor or a
ExtendedColor |
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 settings
|
Footer
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 settings
|
IconMultiStateFormatting.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 document
|
PictureData |
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 cells
|
Shape
Common interface for all drawing shapes
|
ShapeContainer
A common interface for shape groups.
|
Sheet
High level representation of a Excel worksheet.
|
SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet
|
SheetVisibility
Specifies sheet visibility
|
SimpleShape
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 it
HSSFWorkbook or XSSFWorkbook),
by auto-detecting from the supplied input. |
Class and Description |
---|
Color |
Class and Description |
---|
Workbook
High level representation of a Excel workbook.
|
Class and Description |
---|
Picture
Repersents a picture in a SpreadsheetML document
|
Shape
Common interface for all drawing shapes
|
ShapeContainer
A common interface for shape groups.
|
Sheet
High level representation of a Excel worksheet.
|
Class and Description |
---|
Cell
High level representation of a cell in a row of a spreadsheet.
|
CellType |
Class and 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 rule
|
ConditionType
Represents a type of a conditional formatting rule
|
DataValidation |
ExcelNumberFormat
Object to hold a number format index and string, for various formatting evaluations
|
FormulaEvaluator
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.
|
Class and Description |
---|
Workbook
High level representation of a Excel workbook.
|
Class and Description |
---|
DataFormatter
DataFormatter contains methods for formatting the value stored in an
Cell.
|
Class and Description |
---|
AutoFilter
Represents autofiltering for the specified worksheet.
|
BorderExtent
The enumeration value indicating which borders to draw in a Property Template
|
BorderFormatting
High level representation for Border Formatting component
of Conditional Formatting settings
|
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.
|
CellCopyPolicy |
CellCopyPolicy.Builder |
CellRange
Represents a rectangular region of a
Sheet |
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 settings
|
Comment |
ConditionalFormatting
The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
|
ConditionalFormattingRule
Represents a description of a conditional formatting rule
|
ConditionalFormattingThreshold
The Threshold / CFVO / Conditional Formatting Value Object.
|
ConditionalFormattingThreshold.RangeType |
ConditionFilterData
These values are needed by various conditional formatting evaluation filter types
|
ConditionFilterType
Used primarily for XSSF conditions, which defines a multitude of additional "filter" types
for conditional formatting.
|
ConditionType
Represents a type of a conditional formatting rule
|
CreationHelper
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 settings
|
DataConsolidateFunction
Enum mapping the values of STDataConsolidateFunction
|
DataFormat |
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 evaluations
|
ExtendedColor
Represents a XSSF-style color (based on either a
XSSFColor or a
ExtendedColor |
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.FontCharset
|
FontFamily
The font family this font belongs to.
|
FontFormatting
High level representation for Font Formatting component
of Conditional Formatting settings
|
FontScheme
Defines the font scheme to which this font belongs.
|
FontUnderline
the different types of possible underline formatting
|
Footer
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 settings
|
IconMultiStateFormatting.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 sheet
|
PatternFormatting |
Picture
Repersents a picture in a SpreadsheetML document
|
PictureData |
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 Left
|
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 cells
|
Shape
Common interface for all drawing shapes
|
ShapeContainer
A common interface for shape groups.
|
Sheet
High level representation of a Excel worksheet.
|
SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet
|
SheetVisibility
Specifies sheet visibility
|
SimpleShape
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.CreateWorkbook0 |
WorkbookFactory.CreateWorkbook1 |
WorkbookFactory.CreateWorkbook2 |
Class and Description |
---|
Chart
Deprecated.
|
Sheet
High level representation of a Excel worksheet.
|
Class and Description |
---|
Sheet
High level representation of a Excel worksheet.
|
Class and Description |
---|
BorderExtent
The enumeration value indicating which borders to draw in a Property Template
|
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.
|
CellRange
Represents a rectangular region of a
Sheet |
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 document
|
Row
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.
|
Class and Description |
---|
Cell
High level representation of a cell in a row of a spreadsheet.
|
Sheet
High level representation of a Excel worksheet.
|
Class and Description |
---|
Workbook
High level representation of a Excel workbook.
|
Class and Description |
---|
DataFormatter
DataFormatter contains methods for formatting the value stored in an
Cell.
|
RichTextString
Rich text unicode string.
|
Class and Description |
---|
DataFormatter
DataFormatter contains methods for formatting the value stored in an
Cell.
|
RichTextString
Rich text unicode string.
|
Class and Description |
---|
Color |
Name
Represents a defined name for a range of cells.
|
RichTextString
Rich text unicode string.
|
TableStyle
Data table style definition.
|
Class and Description |
---|
AutoFilter
Represents autofiltering for the specified worksheet.
|
Cell
High level representation of a cell in a row of a spreadsheet.
|
CellBase
Common implementation-independent logic shared by all implementations of
Cell . |
CellRange
Represents a rectangular region of a
Sheet |
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 a
XSSFColor or a
ExtendedColor |
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 document
|
PictureData |
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 cells
|
Shape
Common interface for all drawing shapes
|
ShapeContainer
A common interface for shape groups.
|
Sheet
High level representation of a Excel worksheet.
|
SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet
|
SheetVisibility
Specifies sheet visibility
|
Workbook
High level representation of a Excel workbook.
|
Class and Description |
---|
AutoFilter
Represents autofiltering for the specified worksheet.
|
BorderFormatting
High level representation for Border Formatting component
of Conditional Formatting settings
|
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.
|
CellBase
Common implementation-independent logic shared by all implementations of
Cell . |
CellCopyPolicy |
CellRange
Represents a rectangular region of a
Sheet |
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 settings
|
Comment |
ConditionalFormatting
The ConditionalFormatting class encapsulates all settings of Conditional Formatting.
|
ConditionalFormattingRule
Represents a description of a conditional formatting rule
|
ConditionalFormattingThreshold
The Threshold / CFVO / Conditional Formatting Value Object.
|
ConditionalFormattingThreshold.RangeType |
ConditionFilterData
These values are needed by various conditional formatting evaluation filter types
|
ConditionFilterType
Used primarily for XSSF conditions, which defines a multitude of additional "filter" types
for conditional formatting.
|
ConditionType
Represents a type of a conditional formatting rule
|
CreationHelper
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 settings
|
DataConsolidateFunction
Enum mapping the values of STDataConsolidateFunction
|
DataFormat |
DataValidation |
DataValidationConstraint |
DataValidationHelper |
Date1904Support |
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 evaluations
|
ExtendedColor
Represents a XSSF-style color (based on either a
XSSFColor or a
ExtendedColor |
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.FontCharset
|
FontFamily
The font family this font belongs to.
|
FontFormatting
High level representation for Font Formatting component
of Conditional Formatting settings
|
FontScheme
Defines the font scheme to which this font belongs.
|
FontUnderline
the different types of possible underline formatting
|
Footer
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 settings
|
IconMultiStateFormatting.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 sheet
|
PatternFormatting |
Picture
Repersents a picture in a SpreadsheetML document
|
PictureData |
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 Left
|
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 cells
|
Shape
Common interface for all drawing shapes
|
ShapeContainer
A common interface for shape groups.
|
Sheet
High level representation of a Excel worksheet.
|
SheetConditionalFormatting
The 'Conditional Formatting' facet of Sheet
|
SheetVisibility
Specifies sheet visibility
|
SimpleShape
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 it
HSSFWorkbook or XSSFWorkbook),
by auto-detecting from the supplied input. |
Class and Description |
---|
Chart
Deprecated.
|
Class and 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 Left
|
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.
|
Class and Description |
---|
CellStyle |
IgnoredErrorType
Types of ignored workbook and worksheet error.
|
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.