| Name | Description | Type | Package | Framework |
| AutoFilter | Represents autofiltering for the specified worksheet. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| AxisCrossBetween | enum AxisCrossBetweenSpecifies the possible crossing states of an axis. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| AxisCrosses | Specifies the possible crossing points for an axis. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| AxisOrientation | enum AxisOrientationSpecifies the possible ways to place a picture on a data point, series, wall, or floor. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| AxisPosition | Enumeration of all possible axis positions. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| AxisTickMark | Enumeration of possible axis tick marks. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| BorderFormatting | High level representation for Border Formatting component of Conditional Formatting settings | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| BorderStyle | The enumeration value indicating the line style of a border in a cell, i. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| BuiltinFormats | Utility to identify built-in formats. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Cell | High level representation of a cell in a row of a spreadsheet. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| CellCopyPolicy | | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| CellCopyPolicy .Builder | | Class | org.apache.poi.ss.usermodel.CellCopyPolicy | Apache POI |
|
| CellRange | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| CellStyle | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| CellValue | Mimics the 'data view' of a cell. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Chart | High level representation of a chart. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| ChartAxis | High level representation of chart axis. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ChartAxisFactory | A factory for different chart axis. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ChartData | A base for all charts data types. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ChartDataFactory | A factory for different charts data types. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ChartDataSource | Represents data model of the charts. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ChartLegend | High level representation of chart legend. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ChartSeries | Basic settings for all chart series. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ClientAnchor | A client anchor is attached to an excel worksheet. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| ClientAnchor .AnchorType | Do Not Move or Resize With Underlying Rows/Columns (3)Don't Move but do Resize With Anchor Cells (1) | Class | org.apache.poi.ss.usermodel.ClientAnchor | Apache POI |
|
| ColorScaleFormatting | High level representation for the Color Scale / Colour Scale / Color Gradient Formatting component of Conditional Formatting settings | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| Comment | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| ComparisonOperator | The conditional format operators used for "Highlight Cells That Contain. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| ConditionalFormatting | The ConditionalFormatting class encapsulates all settings of Conditional Formatting. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| ConditionalFormattingRule | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| ConditionalFormattingThreshold | The Threshold / CFVO / Conditional Formatting Value Object. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| ConditionalFormattingThreshold .RangeType | The maximum value from the rangeThe minimum value from the range | Class | org.apache.poi.ss.usermodel.ConditionalFormattingThreshold | Apache POI |
|
| ConditionType | | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| CreationHelper | An object that handles instantiating concrete classes of the various instances one needs for | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| DataBarFormatting | High level representation for the DataBar Formatting component of Conditional Formatting settings | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| DataConsolidateFunction | enum DataConsolidateFunctionEnum mapping the values of STDataConsolidateFunction | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| DataFormat | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| DataFormatter | DataFormatter contains methods for formatting the value stored in an Cell. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| DataSources | | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| DataValidation | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| DataValidation .ErrorStyle | | Class | org.apache.poi.ss.usermodel.DataValidation | Apache POI |
|
| DataValidationConstraint | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| DataValidationConstraint .OperatorType | | Class | org.apache.poi.ss.usermodel.DataValidationConstraint | Apache POI |
|
| DataValidationConstraint .ValidationType | | Class | org.apache.poi.ss.usermodel.DataValidationConstraint | Apache POI |
|
| DataValidationHelper | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| DateUtil | Contains methods for dealing with Excel dates. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Drawing | High level representation of spreadsheet drawing. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| ErrorConstants | Contains raw Excel error codes (as defined in OOO's excelfileformat. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| ExcelGeneralNumberFormat | A format that formats a double as Excel would, ignoring FieldPosition. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| ExcelStyleDateFormatter | A wrapper around a SimpleDateFormat instance, which handles a few Excel-style extensions that | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| ExtendedColor | | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| FillPatternType | enum FillPatternTypeThe enumeration value indicating the style of fill pattern being used for a cell format. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Font | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| FontCharset | Charset represents the basic set of characters associated with a font (that it can display), and corresponds to the ANSI codepage (8-bit or DBCS) of that character set used by a given language. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| FontFamily | The font family this font belongs to. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| FontFormatting | High level representation for Font Formatting component of Conditional Formatting settings | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| FontScheme | Defines the font scheme to which this font belongs. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| FontUnderline | the different types of possible underline formattingAuthor:Gisella Bronzetti | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Footer | Common definition of a HSSF or XSSF page footer. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| FormulaError | Enumerates error values in SpreadsheetML formula calculations. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| FormulaEvaluator | Evaluates formula cells. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| FractionFormat | Format class that handles Excel style fractions, such as "# #/#" and "#/###" As of this writing, this is still not 100% accurate, but it does a reasonable job | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Header | Common definition of a HSSF or XSSF page header. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| HeaderFooter | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| HorizontalAlignment | enum HorizontalAlignmentThe enumeration value indicating horizontal alignment of a cell, | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Hyperlink | Represents an Excel hyperlink. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| IconMultiStateFormatting | High level representation for the Icon / Multi-State Formatting component of Conditional Formatting settings | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| IconMultiStateFormatting .IconSet | Grey Up / Side / Down arrowsGrey Up / NE / SE / Down arrows | Class | org.apache.poi.ss.usermodel.IconMultiStateFormatting | Apache POI |
|
| IgnoredErrorType | enum IgnoredErrorTypeTypes of ignored workbook and worksheet error. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| IndexedColors | A deprecated indexing scheme for colours that is still required for some records, and for backwards compatibility with OLE2 formats. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| LayoutMode | Specifies the possible ways to store a chart element's position. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| LayoutTarget | Specifies whether to layout the plot area by its inside (not including axis and axis labels) or outside (including axis and axis labels). | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| LegendPosition | Enumeration of all possible chart legend positions. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| LineChartData | | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| LineChartSeries | Represents a line chart series. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ManualLayout | High level representation of chart element manual layout. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ManuallyPositionable | Abstraction of chart element that can be positioned with manualAuthor:Roman Kashitsyn | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| Name | Represents a defined name for a range of cells. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| PageOrder | Specifies printed page order. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| PaperSize | The enumeration value indicating the possible paper size for a sheetAuthor:Daniele Montagni | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| PatternFormatting | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| Picture | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| PictureData | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| PrintCellComments | enum PrintCellCommentsThese enumerations specify how cell comments shall be displayed for paper printing purposes. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| PrintOrientation | enum PrintOrientationThe enumeration value indicating the print orientation for a sheet. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| PrintSetup | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| RichTextString | Rich text unicode string. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| Row | High level representation of a row of a spreadsheet. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| Row .MissingCellPolicy | Used to specify the different possible policies if for the case of null and blank cells | Class | org.apache.poi.ss.usermodel.Row | Apache POI |
|
| ScatterChartData | | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ScatterChartSeries | Represents scatter charts series. | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ShapeTypes | | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Sheet | High level representation of a Excel worksheet. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| SheetConditionalFormatting | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| Textbox | | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| TitleType | Title types for charts. | Class | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| ValueAxis | | Interface | org.apache.poi.ss.usermodel.charts | Apache POI |
|
| VerticalAlignment | enum VerticalAlignmentThis enumeration value indicates the type of vertical alignment for a cell, i. | Class | org.apache.poi.ss.usermodel | Apache POI |
|
| Workbook | High level representation of a Excel workbook. | Interface | org.apache.poi.ss.usermodel | Apache POI |
|
| WorkbookFactory | Factory for creating the appropriate kind of Workbook (be it HSSFWorkbook or XSSFWorkbook), | Class | org.apache.poi.ss.usermodel | Apache POI |