| Package | Description | 
|---|---|
| org.apache.poi.common.usermodel | |
| org.apache.poi.ddf | This package contains classes for decoding the Microsoft Office Drawing format otherwise
 known as escher henceforth known in POI as the Dreadful Drawing Format. | 
| org.apache.poi.hpsf | Processes streams in the Horrible Property Set Format (HPSF) in POI filesystems. | 
| org.apache.poi.hpsf.wellknown | Specific support for DocumentSummaryInformation, SummaryInformation types. | 
| org.apache.poi.hslf.extractor | |
| org.apache.poi.hslf.model | |
| org.apache.poi.hslf.model.textproperties | |
| org.apache.poi.hslf.record | |
| org.apache.poi.hslf.usermodel | |
| org.apache.poi.hsmf.datatypes | |
| org.apache.poi.hsmf.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.record.chart | |
| org.apache.poi.hssf.record.common | |
| org.apache.poi.hssf.usermodel | The usermodel package maps HSSF low level structures to familiar workbook/sheet model | 
| org.apache.poi.hssf.util | The util package contains tools needed for writing HSSF files that are not necesarily "real" HSSF concepts. | 
| org.apache.poi.hwpf.model | |
| org.apache.poi.hwpf.sprm | |
| org.apache.poi.hwpf.usermodel | |
| org.apache.poi.ooxml | |
| org.apache.poi.ooxml.extractor | |
| org.apache.poi.ooxml.util | |
| org.apache.poi.openxml4j.util | |
| org.apache.poi.poifs.filesystem | filesystem package maps OLE 2 Compound document files to a more familiar filesystem interface. | 
| org.apache.poi.ss.format | This package contains classes that implement cell formatting | 
| org.apache.poi.ss.formula | This package contains common internal POI code for manipulating formulas. | 
| org.apache.poi.ss.usermodel | |
| org.apache.poi.ss.usermodel.charts | |
| org.apache.poi.util | Top-level util package are classes that are useful throughout the project. | 
| org.apache.poi.xdgf.geom | |
| org.apache.poi.xslf.extractor | |
| org.apache.poi.xslf.usermodel | |
| org.apache.poi.xssf.binary | The org.apache.poi.xssf.binary package includes necessary underlying components
 for streaming/read-only processing of xlsb files. | 
| org.apache.poi.xssf.eventusermodel | |
| org.apache.poi.xssf.model | |
| org.apache.poi.xssf.streaming | |
| org.apache.poi.xssf.usermodel | |
| org.apache.poi.xssf.usermodel.charts | |
| org.apache.poi.xssf.usermodel.helpers | |
| org.apache.poi.xwpf.usermodel | 
| Modifier and Type | Method and Description | 
|---|---|
| HyperlinkType | Hyperlink. getTypeEnum()Deprecated. 
 use  getType()instead | 
| Modifier and Type | Interface and Description | 
|---|---|
| interface  | EscherPropertiesDeprecated. 
 use  EscherPropertyTypesenum instead | 
| Modifier and Type | Method and Description | 
|---|---|
| EscherRecord | EscherRecord. clone()Deprecated. 
 | 
| static boolean | DefaultEscherRecordFactory. isContainer(short options,
           short recordId)Deprecated. 
 this method is not used anymore to identify container records | 
| void | AbstractEscherOptRecord. removeEscherProperty(int num)Deprecated.  | 
| Constructor and Description | 
|---|
| EscherArrayProperty(short propertyNumber,
                   boolean isBlipId,
                   byte[] complexData) | 
| EscherArrayProperty(short id,
                   byte[] complexData) | 
| EscherComplexProperty(short propertyNumber,
                     boolean isBlipId,
                     byte[] complexData)Deprecated.  | 
| EscherComplexProperty(short id,
                     byte[] complexData)Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| Section | PropertySet. getSingleSection()Deprecated. 
 superfluous convenience method | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | SectionIDMapDeprecated. 
 in 4.0.0, there's no way to create custom PropertyIDMaps, therefore
   this class is obsolete | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | PowerPointExtractorDeprecated. 
 in POI 4.0.0, use  SlideShowExtractorinstead | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | PPGraphics2DDeprecated. 
 since 4.0.0 - use SLGraphics | 
| Modifier and Type | Method and Description | 
|---|---|
| TextProp | TextProp. clone()Deprecated.  | 
| BitMaskTextProp | BitMaskTextProp. clone()Deprecated.  | 
| HSLFTabStop | HSLFTabStop. clone()Deprecated.  | 
| HSLFTabStopPropCollection | HSLFTabStopPropCollection. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| int | DocumentAtom. getSlideSizeType()Deprecated. 
 to be replaced by enum | 
| void | RecordContainer. moveChildBefore(Record child,
               Record before)Deprecated. 
 method is not used within POI and will be removed | 
| void | RecordContainer. moveChildrenAfter(Record firstChild,
                 int number,
                 Record after)Deprecated. 
 method is not used within POI and will be removed | 
| void | RecordContainer. moveChildrenBefore(Record firstChild,
                  int number,
                  Record before)Deprecated. 
 method is not used within POI and will be removed | 
| Modifier and Type | Method and Description | 
|---|---|
| static <T extends EscherProperty> | HSLFShape. getEscherProperty(AbstractEscherOptRecord opt,
                 int propId)Deprecated. 
 use  HSLFShape.getEscherProperty(EscherPropertyTypes)instead | 
| int | HSLFShape. getEscherProperty(short propId,
                 int defaultValue)Deprecated. 
 | 
| HyperlinkType | HSLFHyperlink. getTypeEnum()Deprecated. 
 use  getTypeinstead | 
| static boolean | HSLFMasterSheet. isPlaceholder(HSLFShape shape)Deprecated. 
 | 
| static void | HSLFShape. setEscherProperty(AbstractEscherOptRecord opt,
                 short propId,
                 int value) | 
| void | HSLFShape. setEscherProperty(short propId,
                 int value)Deprecated. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
| MAPIMessage | DirectoryChunk. getAsEmbededMessage()Deprecated. 
 use  DirectoryChunk.getAsEmbeddedMessage()instead | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | OutlookTextExtactorDeprecated. 
 use @{link OutlookTextExtractor} instead | 
| Modifier and Type | Method and Description | 
|---|---|
| int | DrawingManager2. allocateShapeId(short drawingGroupId)Deprecated. 
 in POI 3.17-beta2, use allocateShapeId(EscherDgRecord) | 
| int | DrawingManager2. allocateShapeId(short drawingGroupId,
               EscherDgRecord dg)Deprecated. 
 in POI 3.17-beta2, use allocateShapeId(EscherDgRecord) | 
| Modifier and Type | Method and Description | 
|---|---|
| FooterRecord | FooterRecord. clone()Deprecated.  | 
| SharedFormulaRecord | SharedFormulaRecord. clone()Deprecated.  | 
| DVRecord | DVRecord. clone()Deprecated.  | 
| ColumnInfoRecord | ColumnInfoRecord. clone()Deprecated.  | 
| PrintSetupRecord | PrintSetupRecord. clone()Deprecated.  | 
| LbsDataSubRecord | LbsDataSubRecord. clone()Deprecated.  | 
| NumberRecord | NumberRecord. clone()Deprecated.  | 
| ObjectProtectRecord | ObjectProtectRecord. clone()Deprecated.  | 
| WSBoolRecord | WSBoolRecord. clone()Deprecated.  | 
| IndexRecord | IndexRecord. clone()Deprecated.  | 
| PasswordRecord | PasswordRecord. clone()Deprecated.  | 
| LeftMarginRecord | LeftMarginRecord. clone()Deprecated.  | 
| FeatRecord | FeatRecord. clone()Deprecated.  | 
| UserSViewBegin | UserSViewBegin. clone()Deprecated.  | 
| CalcCountRecord | CalcCountRecord. clone()Deprecated.  | 
| ProtectRecord | ProtectRecord. clone()Deprecated.  | 
| ObjRecord | ObjRecord. clone()Deprecated.  | 
| UnknownRecord | UnknownRecord. clone()Deprecated.  | 
| DBCellRecord | DBCellRecord. clone()Deprecated.  | 
| SCLRecord | SCLRecord. clone()Deprecated.  | 
| IterationRecord | IterationRecord. clone()Deprecated.  | 
| RefModeRecord | RefModeRecord. clone()Deprecated.  | 
| DVALRecord | DVALRecord. clone()Deprecated.  | 
| RKRecord | RKRecord. clone()Deprecated.  | 
| SelectionRecord | SelectionRecord. clone()Deprecated.  | 
| WindowProtectRecord | WindowProtectRecord. clone()Deprecated.  | 
| RightMarginRecord | RightMarginRecord. clone()Deprecated.  | 
| GridsetRecord | GridsetRecord. clone()Deprecated.  | 
| DeltaRecord | DeltaRecord. clone()Deprecated.  | 
| LabelRecord | LabelRecord. clone()Deprecated.  | 
| BottomMarginRecord | BottomMarginRecord. clone()Deprecated.  | 
| FileSharingRecord | FileSharingRecord. clone()Deprecated.  | 
| GutsRecord | GutsRecord. clone()Deprecated.  | 
| PageBreakRecord | HorizontalPageBreakRecord. clone()Deprecated.  | 
| CFHeaderRecord | CFHeaderRecord. clone()Deprecated.  | 
| ArrayRecord | ArrayRecord. clone()Deprecated.  | 
| RowRecord | RowRecord. clone()Deprecated.  | 
| StringRecord | StringRecord. clone()Deprecated.  | 
| FtPioGrbitSubRecord | FtPioGrbitSubRecord. clone()Deprecated.  | 
| PrintHeadersRecord | PrintHeadersRecord. clone()Deprecated.  | 
| FtCfSubRecord | FtCfSubRecord. clone()Deprecated.  | 
| UserSViewEnd | UserSViewEnd. clone()Deprecated.  | 
| DefaultRowHeightRecord | DefaultRowHeightRecord. clone()Deprecated.  | 
| HeaderFooterRecord | HeaderFooterRecord. clone()Deprecated.  | 
| FormatRecord | FormatRecord. clone()Deprecated.  | 
| UseSelFSRecord | UseSelFSRecord. clone()Deprecated.  | 
| DrawingSelectionRecord | DrawingSelectionRecord. clone()Deprecated.  | 
| RefreshAllRecord | RefreshAllRecord. clone()Deprecated.  | 
| ContinueRecord | ContinueRecord. clone()Deprecated.  | 
| abstract CFHeaderBase | CFHeaderBase. clone()Deprecated.  | 
| DrawingRecord | DrawingRecord. clone()Deprecated.  | 
| CFRule12Record | CFRule12Record. clone()Deprecated.  | 
| EmbeddedObjectRefSubRecord | EmbeddedObjectRefSubRecord. clone()Deprecated.  | 
| MulBlankRecord | MulBlankRecord. clone()Deprecated.  | 
| PaneRecord | PaneRecord. clone()Deprecated.  | 
| TopMarginRecord | TopMarginRecord. clone()Deprecated.  | 
| LabelSSTRecord | LabelSSTRecord. clone()Deprecated.  | 
| PrintGridlinesRecord | PrintGridlinesRecord. clone()Deprecated.  | 
| GroupMarkerSubRecord | GroupMarkerSubRecord. clone()Deprecated.  | 
| FilePassRecord | FilePassRecord. clone()Deprecated.  | 
| NoteStructureSubRecord | NoteStructureSubRecord. clone()Deprecated.  | 
| AutoFilterInfoRecord | AutoFilterInfoRecord. clone()Deprecated.  | 
| VCenterRecord | VCenterRecord. clone()Deprecated.  | 
| BOFRecord | BOFRecord. clone()Deprecated.  | 
| abstract SubRecord | SubRecord. clone()Deprecated.  | 
| EOFRecord | EOFRecord. clone()Deprecated.  | 
| VerticalPageBreakRecord | VerticalPageBreakRecord. clone()Deprecated.  | 
| BlankRecord | BlankRecord. clone()Deprecated.  | 
| HyperlinkRecord | HyperlinkRecord. clone()Deprecated.  | 
| DimensionsRecord | DimensionsRecord. clone()Deprecated.  | 
| DefaultColWidthRecord | DefaultColWidthRecord. clone()Deprecated.  | 
| CFRuleRecord | CFRuleRecord. clone()Deprecated.  | 
| FormulaRecord | FormulaRecord. clone()Deprecated.  | 
| FeatHdrRecord | FeatHdrRecord. clone()Deprecated.  | 
| abstract CFRuleBase | CFRuleBase. clone()Deprecated.  | 
| ScenarioProtectRecord | ScenarioProtectRecord. clone()Deprecated.  | 
| HeaderRecord | HeaderRecord. clone()Deprecated.  | 
| CommonObjectDataSubRecord | CommonObjectDataSubRecord. clone()Deprecated.  | 
| WindowTwoRecord | WindowTwoRecord. clone()Deprecated.  | 
| SaveRecalcRecord | SaveRecalcRecord. clone()Deprecated.  | 
| NoteRecord | NoteRecord. clone()Deprecated.  | 
| BoolErrRecord | BoolErrRecord. clone()Deprecated.  | 
| CalcModeRecord | CalcModeRecord. clone()Deprecated.  | 
| EndSubRecord | EndSubRecord. clone()Deprecated.  | 
| HCenterRecord | HCenterRecord. clone()Deprecated.  | 
| FtCblsSubRecord | FtCblsSubRecord. clone()Deprecated.  | 
| CFHeader12Record | CFHeader12Record. clone()Deprecated.  | 
| MergeCellsRecord | MergeCellsRecord. clone()Deprecated.  | 
| AbstractEscherHolderRecord | AbstractEscherHolderRecord. clone()Deprecated.  | 
| TextObjectRecord | TextObjectRecord. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| java.lang.Object | ValueRecordsAggregate. clone()Deprecated.  | 
| ColumnInfoRecordsAggregate | ColumnInfoRecordsAggregate. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| ColorGradientFormatting | ColorGradientFormatting. clone()Deprecated.  | 
| DataBarThreshold | DataBarThreshold. clone()Deprecated.  | 
| IconMultiStateThreshold | IconMultiStateThreshold. clone()Deprecated.  | 
| IconMultiStateFormatting | IconMultiStateFormatting. clone()Deprecated.  | 
| FontFormatting | FontFormatting. clone()Deprecated.  | 
| ColorGradientThreshold | ColorGradientThreshold. clone()Deprecated.  | 
| BorderFormatting | BorderFormatting. clone()Deprecated.  | 
| PatternFormatting | PatternFormatting. clone()Deprecated.  | 
| DataBarFormatting | DataBarFormatting. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| UnitsRecord | UnitsRecord. clone()Deprecated.  | 
| NumberFormatIndexRecord | NumberFormatIndexRecord. clone()Deprecated.  | 
| AxisLineFormatRecord | AxisLineFormatRecord. clone()Deprecated.  | 
| SeriesChartGroupIndexRecord | SeriesChartGroupIndexRecord. clone()Deprecated.  | 
| SeriesListRecord | SeriesListRecord. clone()Deprecated.  | 
| LegendRecord | LegendRecord. clone()Deprecated.  | 
| ValueRangeRecord | ValueRangeRecord. clone()Deprecated.  | 
| FontBasisRecord | FontBasisRecord. clone()Deprecated.  | 
| DefaultDataLabelTextPropertiesRecord | DefaultDataLabelTextPropertiesRecord. clone()Deprecated.  | 
| AxisUsedRecord | AxisUsedRecord. clone()Deprecated.  | 
| SheetPropertiesRecord | SheetPropertiesRecord. clone()Deprecated.  | 
| SeriesIndexRecord | SeriesIndexRecord. clone()Deprecated.  | 
| ChartEndBlockRecord | ChartEndBlockRecord. clone()Deprecated.  | 
| ObjectLinkRecord | ObjectLinkRecord. clone()Deprecated.  | 
| FrameRecord | FrameRecord. clone()Deprecated.  | 
| ChartRecord | ChartRecord. clone()Deprecated.  | 
| AreaRecord | AreaRecord. clone()Deprecated.  | 
| LineFormatRecord | LineFormatRecord. clone()Deprecated.  | 
| TickRecord | TickRecord. clone()Deprecated.  | 
| DatRecord | DatRecord. clone()Deprecated.  | 
| SeriesRecord | SeriesRecord. clone()Deprecated.  | 
| SeriesLabelsRecord | SeriesLabelsRecord. clone()Deprecated.  | 
| AxisOptionsRecord | AxisOptionsRecord. clone()Deprecated.  | 
| AxisParentRecord | AxisParentRecord. clone()Deprecated.  | 
| BeginRecord | BeginRecord. clone()Deprecated.  | 
| SeriesToChartGroupRecord | SeriesToChartGroupRecord. clone()Deprecated.  | 
| SeriesTextRecord | SeriesTextRecord. clone()Deprecated.  | 
| BarRecord | BarRecord. clone()Deprecated.  | 
| TextRecord | TextRecord. clone()Deprecated.  | 
| PlotAreaRecord | PlotAreaRecord. clone()Deprecated.  | 
| PlotGrowthRecord | PlotGrowthRecord. clone()Deprecated.  | 
| ChartStartBlockRecord | ChartStartBlockRecord. clone()Deprecated.  | 
| FontIndexRecord | FontIndexRecord. clone()Deprecated.  | 
| AreaFormatRecord | AreaFormatRecord. clone()Deprecated.  | 
| DataFormatRecord | DataFormatRecord. clone()Deprecated.  | 
| AxisRecord | AxisRecord. clone()Deprecated.  | 
| EndRecord | EndRecord. clone()Deprecated.  | 
| CategorySeriesAxisRecord | CategorySeriesAxisRecord. clone()Deprecated.  | 
| LinkedDataRecord | LinkedDataRecord. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| UnicodeString | UnicodeString. clone()Deprecated.  | 
| FtrHeader | FtrHeader. clone()Deprecated.  | 
| ExtendedColor | ExtendedColor. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| CellType | HSSFCell. getCachedFormulaResultTypeEnum()Deprecated. 
 use  getCachedFormulaResultTypeWill be deleted when we make the CellType enum transition. See bug 59791. | 
| HyperlinkType | HSSFHyperlink. getTypeEnum()Deprecated. 
 use  getType()instead | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | HSSFRegionUtilDeprecated. 
 POI 4.0.0 | 
| Modifier and Type | Method and Description | 
|---|---|
| protected PropertyModifier | PropertyModifier. clone()Deprecated.  | 
| T | PropertyNode. clone()Deprecated.  | 
| Colorref | Colorref. clone()Deprecated.  | 
| Hyphenation | Hyphenation. clone()Deprecated.  | 
| protected BookmarkFirstDescriptor | BookmarkFirstDescriptor. clone()Deprecated.  | 
| protected FootnoteReferenceDescriptor | FootnoteReferenceDescriptor. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| SprmBuffer | SprmBuffer. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| SectionProperties | SectionProperties. clone()Deprecated.  | 
| TableAutoformatLookSpecifier | TableAutoformatLookSpecifier. clone()Deprecated.  | 
| CharacterProperties | CharacterProperties. clone()Deprecated.  | 
| ShadingDescriptor80 | ShadingDescriptor80. clone()Deprecated.  | 
| CharacterRun | CharacterRun. clone()Deprecated.  | 
| Paragraph | Paragraph. clone()Deprecated.  | 
| DateAndTime | DateAndTime. clone()Deprecated.  | 
| ParagraphProperties | ParagraphProperties. clone()Deprecated.  | 
| Section | Section. clone()Deprecated.  | 
| LineSpacingDescriptor | LineSpacingDescriptor. clone()Deprecated.  | 
| BorderCode | BorderCode. clone()Deprecated.  | 
| TableProperties | TableProperties. clone()Deprecated.  | 
| TableCellDescriptor | TableCellDescriptor. clone()Deprecated.  | 
| DropCapSpecifier | DropCapSpecifier. clone()Deprecated.  | 
| ShadingDescriptor | ShadingDescriptor. clone()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| java.util.List<PackagePart> | POIXMLDocument. getAllEmbedds()Deprecated. 
 use  getAllEmbeddedPartsinstead | 
| boolean | POIXMLDocumentPart. isCommited()Deprecated. 
 use @link{#isCommitted()} | 
| void | POIXMLDocumentPart. setCommited(boolean isCommitted)Deprecated. 
 use @link{#setCommitted(isCommitted)} | 
| Modifier and Type | Method and Description | 
|---|---|
| static POITextExtractor[] | ExtractorFactory. getEmbededDocsTextExtractors(POIOLE2TextExtractor ext)Deprecated. 
 Use the method with correct "embedded" | 
| static POITextExtractor[] | ExtractorFactory. getEmbededDocsTextExtractors(POIXMLTextExtractor ext)Deprecated. 
 Use the method with correct "embedded" | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | SAXHelperDeprecated. 
 use  XMLHelper | 
| class  | TransformerHelperDeprecated. 
 use  XMLHelper | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | Nullable<E>Deprecated. 
 No longer used in POI code base, use  Optionalinstead | 
| Modifier and Type | Method and Description | 
|---|---|
| static boolean | DocumentFactoryHelper. hasOOXMLHeader(java.io.InputStream inp)Deprecated. 
 in 3.17-beta2, use  FileMagic.valueOf(InputStream)== FileMagic.OOXML instead | 
| Modifier and Type | Method and Description | 
|---|---|
| static CellType | CellFormat. ultimateTypeEnum(Cell cell)Deprecated. 
 use  ultimateTypeinstead | 
| Modifier and Type | Method and Description | 
|---|---|
| static void | SheetNameFormatter. appendFormat(java.lang.StringBuffer out,
            java.lang.String rawSheetName)Deprecated. 
 Only kept for binary compatibility, will be replaced by the version with Appendable as parameter | 
| static void | SheetNameFormatter. appendFormat(java.lang.StringBuffer out,
            java.lang.String workbookName,
            java.lang.String rawSheetName)Deprecated. 
 Only kept for binary compatibility, will be replaced by the version with Appendable as parameter | 
| static void | SheetNameFormatter. appendFormat(java.lang.StringBuilder out,
            java.lang.String rawSheetName)Only kept for binary compatibility, will be replaced by the version with Appendable as parameter | 
| static void | SheetNameFormatter. appendFormat(java.lang.StringBuilder out,
            java.lang.String workbookName,
            java.lang.String rawSheetName)Only kept for binary compatibility, will be replaced by the version with Appendable as parameter | 
| CellType | BaseFormulaEvaluator. evaluateFormulaCellEnum(Cell cell)Deprecated. 
 use  evaluateFormulaCell(cell)instead | 
| CellType | EvaluationCell. getCachedFormulaResultTypeEnum()Deprecated. 
 POI 3.15 beta 3.
 Will be deleted when we make the CellType enum transition. See bug 59791. | 
| CellType | EvaluationCell. getCellTypeEnum()Deprecated. 
 POI 3.15 beta 3. | 
| Modifier and Type | Interface and Description | 
|---|---|
| interface  | ChartDeprecated.   | 
| class  | FontCharsetDeprecated. 
 enum will be replaced by common version org.apache.poi.common.usermodel.FontCharset | 
| Modifier and Type | Method and Description | 
|---|---|
| static Workbook | WorkbookFactory. create(java.lang.Object pkg)Deprecated. 
 use  WorkbookFactory.create(File),WorkbookFactory.create(InputStream)or
          XSSFWorkbookFactory.create(OPCPackage) instead. | 
| CellType | FormulaEvaluator. evaluateFormulaCellEnum(Cell cell)Deprecated. 
 use  evaluateFormulaCell(cell) | 
| HorizontalAlignment | CellStyle. getAlignmentEnum()Deprecated. 
 use  getAlignment()instead | 
| BorderStyle | CellStyle. getBorderBottomEnum()Deprecated. 
 use  getBorderBottom()instead | 
| BorderStyle | BorderFormatting. getBorderBottomEnum()Deprecated. 
 use  getBorderBottominstead | 
| BorderStyle | BorderFormatting. getBorderDiagonalEnum()Deprecated. 
 use  getBorderDiagonalinstead | 
| BorderStyle | BorderFormatting. getBorderHorizontalEnum()Deprecated. 
 use  getBorderHorizontalinstead | 
| BorderStyle | CellStyle. getBorderLeftEnum()Deprecated. 
 use  getBorderLeft()instead | 
| BorderStyle | BorderFormatting. getBorderLeftEnum()Deprecated. 
 use  getBorderLeftinstead | 
| BorderStyle | CellStyle. getBorderRightEnum()Deprecated. 
 use  getBorderRight()instead | 
| BorderStyle | BorderFormatting. getBorderRightEnum()Deprecated. 
 use  getBorderRightinstead | 
| BorderStyle | CellStyle. getBorderTopEnum()Deprecated. 
 use  getBorderTop()instead | 
| BorderStyle | BorderFormatting. getBorderTopEnum()Deprecated. 
 use  getBorderTopinstead | 
| BorderStyle | BorderFormatting. getBorderVerticalEnum()Deprecated. 
 use  getBorderVerticalinstead | 
| CellType | Cell. getCachedFormulaResultTypeEnum()Deprecated. 
 will be removed in 4.2
 Will be renamed to  getCachedFormulaResultType()when we make the CellType enum transition in POI 4.0. See bug 59791. | 
| CellType | Cell. getCellTypeEnum()Deprecated. 
 will be removed in 4.2
 Will be renamed to  getCellType()when we make the CellType enum transition in POI 4.0. See bug 59791. | 
| CellType | CellBase. getCellTypeEnum()Deprecated.  | 
| CellType | CellValue. getCellTypeEnum()Deprecated. 
 use  getCellTypeinstead | 
| FillPatternType | CellStyle. getFillPatternEnum()Deprecated. 
 use  getFillPattern()instead | 
| Font | Workbook. getFontAt(short idx)Deprecated. 
 use  getFontAt(int) | 
| short | CellStyle. getFontIndex()Deprecated. 
 use  getFontIndexAsInt()instead | 
| short | Font. getIndex()Deprecated. 
 use  getIndexAsInt()instead | 
| Name | Workbook. getNameAt(int nameIndex)Deprecated. 
 4.0.0. New projects should avoid accessing named ranges by index. | 
| int | Workbook. getNameIndex(java.lang.String name)Deprecated. 
 3.18. New projects should avoid accessing named ranges by index.
 Use  Workbook.getName(String)instead. | 
| short | Workbook. getNumberOfFonts()Deprecated. 
 use  getNumberOfFontsAsInt()instead | 
| VerticalAlignment | CellStyle. getVerticalAlignmentEnum()Deprecated. 
 use  getVerticalAlignment()instead | 
| void | Workbook. removeName(int index)Deprecated. 
 3.18. New projects should use  Workbook.removeName(Name). | 
| void | Workbook. removeName(java.lang.String name)Deprecated. 
 3.18. New projects should use  Workbook.removeName(Name). | 
| void | Cell. setCellType(CellType cellType)Deprecated. 
 This method is deprecated and will be removed in POI 5.0.
 Use explicit  Cell.setCellFormula(String),setCellValue(...)orCell.setBlank()to get the desired result. | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | AxisCrossBetweenDeprecated. 
 use XDDF AxisCrossBetween | 
| class  | AxisCrossesDeprecated. 
 use XDDF AxisCrosses instead | 
| class  | AxisOrientationDeprecated. 
 use XDDF AxisOrientation | 
| class  | AxisPositionDeprecated. 
 use XDDF AxisPosition instead | 
| class  | AxisTickMarkDeprecated. 
 use XDDF AxisTickMark instead | 
| interface  | ChartAxisDeprecated. 
 use XDDFChartAxis instead | 
| interface  | ChartAxisFactoryDeprecated.   | 
| interface  | ChartDataDeprecated. 
 use XDDFChartData instead | 
| interface  | ChartDataFactoryDeprecated.   | 
| interface  | ChartDataSource<T>Deprecated. 
 use XDDFDataSource instead | 
| interface  | ChartLegendDeprecated. 
 use XDDFChartLegend instead | 
| interface  | ChartSeriesDeprecated.   | 
| class  | DataSourcesDeprecated. 
 use XDDFDataSourcesFactory instead | 
| class  | LayoutModeDeprecated.  | 
| class  | LayoutTargetDeprecated. 
 use XDDF LayoutTarget instead | 
| class  | LegendPositionDeprecated. 
 use XDDF LayoutPosition instead | 
| interface  | LineChartDataDeprecated. 
 use XDDFLineChartData instead | 
| interface  | LineChartSeriesDeprecated. 
 use XDDFLineChartData.Series instead | 
| interface  | ManualLayoutDeprecated. 
 use XDDFManualLayout instead | 
| interface  | ManuallyPositionableDeprecated.   | 
| interface  | ScatterChartDataDeprecated. 
 use XDDFScatterChartData instead | 
| interface  | ScatterChartSeriesDeprecated. 
 use XDFFScatterChartData.Series instead | 
| class  | TitleTypeDeprecated.   | 
| interface  | ValueAxisDeprecated. 
 use XDDFValueAxis instead | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | StaxHelperDeprecated. 
 use  XMLHelper | 
| Modifier and Type | Method and Description | 
|---|---|
| static void | IOUtils. write(POIDocument doc,
     java.io.OutputStream out)Deprecated. 
 since 4.0, use try-with-resources, will be removed in 4.2 | 
| static void | IOUtils. write(Workbook doc,
     java.io.OutputStream out)Deprecated. 
 since 4.0, use try-with-resources, will be removed in 4.2 | 
| static void | IOUtils. writeAndClose(POIDocument doc)Deprecated. 
 since 4.0, use try-with-resources, will be removed in 4.2 | 
| static void | IOUtils. writeAndClose(POIDocument doc,
             java.io.File out)Deprecated. 
 since 4.0, use try-with-resources, will be removed in 4.2 | 
| static void | IOUtils. writeAndClose(POIDocument doc,
             java.io.OutputStream out)Deprecated. 
 since 4.0, use try-with-resources, will be removed in 4.2 | 
| static void | IOUtils. writeAndClose(Workbook doc,
             java.io.OutputStream out)Deprecated. 
 since 4.0, use try-with-resources, will be removed in 4.2 | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | Dimension2dDoubleDeprecated. 
 in 4.1.0 - use org.apache.poi.util.Dimension2DDouble | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | XSLFPowerPointExtractorDeprecated. 
 | 
| Modifier and Type | Method and Description | 
|---|---|
| HyperlinkType | XSLFHyperlink. getTypeEnum()Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| java.lang.String | XSSFBSharedStringsTable. getEntryAt(int idx)Deprecated. 
 use  getItemAtinstead | 
| java.util.List<java.lang.String> | XSSFBSharedStringsTable. getItems()Deprecated. 
 use  getItemAtinstead | 
| Modifier and Type | Method and Description | 
|---|---|
| java.lang.String | ReadOnlySharedStringsTable. getEntryAt(int idx)Deprecated. 
 use  getItemAtinstead | 
| java.util.List<java.lang.String> | ReadOnlySharedStringsTable. getItems()Deprecated. 
 use  getItemAtinstead | 
| Modifier and Type | Method and Description | 
|---|---|
| int | SharedStringsTable. addEntry(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRst st)Deprecated. 
 use  addSharedStringItem(RichTextString string)instead | 
| java.util.Map<CellAddress,XSSFComment> | CommentsTable. getCellComments()Deprecated. 
 use  getCellAddressesinstead | 
| org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRst | SharedStringsTable. getEntryAt(int idx)Deprecated. 
 use  getItemAt(int idx)instead | 
| java.util.List<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRst> | SharedStringsTable. getItems()Deprecated. 
 use  getSharedStringItemsinstead | 
| Modifier and Type | Method and Description | 
|---|---|
| CellType | SXSSFCell. getCachedFormulaResultTypeEnum()Deprecated. 
 use  getCachedFormulaResultTypeinstead | 
| Name | SXSSFWorkbook. getNameAt(int nameIndex)Deprecated. 
 3.16. New projects should avoid accessing named ranges by index. | 
| int | SXSSFWorkbook. getNameIndex(java.lang.String name)Deprecated. 
 3.16. New projects should avoid accessing named ranges by index.
 Use  SXSSFWorkbook.getName(String)instead. | 
| void | SXSSFWorkbook. removeName(int index)Deprecated. 
 3.16. New projects should use  SXSSFWorkbook.removeName(Name). | 
| void | SXSSFWorkbook. removeName(java.lang.String name)Deprecated. 
 3.16. New projects should use  SXSSFWorkbook.removeName(Name). | 
| Modifier and Type | Field and Description | 
|---|---|
| static float | XSSFWorkbook. DEFAULT_CHARACTER_WIDTHDeprecated. 
 POI 3.17 beta 1 | 
| Modifier and Type | Method and Description | 
|---|---|
| XSSFCellStyle | XSSFCellStyle. clone()Deprecated.  | 
| XSSFCategoryAxis | XSSFChart. createCategoryAxis(AxisPosition pos)Deprecated.  | 
| XSSFDateAxis | XSSFChart. createDateAxis(AxisPosition pos)Deprecated.  | 
| XSSFTable | XSSFSheet. createTable()Deprecated. 
 Use  #createTable(AreaReference))instead | 
| XSSFValueAxis | XSSFChart. createValueAxis(AxisPosition pos)Deprecated.  | 
| java.util.List<? extends XSSFChartAxis> | XSSFChart. getAxis()Deprecated. 
 use  XDDFChart.getAxes()instead | 
| CellType | XSSFCell. getCachedFormulaResultTypeEnum()Deprecated. 
 use  getCachedFormulaResultTypeinstead
 Will be deleted when we make the CellType enum transition. See bug 59791. | 
| XSSFChart | XSSFChart. getChartAxisFactory()Deprecated.  | 
| XSSFChartDataFactory | XSSFChart. getChartDataFactory()Deprecated.  | 
| XSSFManualLayout | XSSFChart. getManualLayout()Deprecated.  | 
| long | XSSFTable. getNumberOfMappedColumns()Deprecated. 
 Use  XSSFTable.getColumnCount()instead. | 
| XSSFChartLegend | XSSFChart. getOrCreateLegend()Deprecated.  | 
| HyperlinkType | XSSFHyperlink. getTypeEnum()Deprecated. 
 use  getTypeinstead | 
| java.util.List<XSSFXmlColumnPr> | XSSFTable. getXmlColumnPrs()Deprecated. 
 Use  XSSFTableColumn.getXmlColumnPr()instead. | 
| void | XSSFChart. plot(ChartData data,
    ChartAxis... chartAxis)Deprecated.  | 
| Constructor and Description | 
|---|
| XSSFColor()Deprecated. 
 as of 4.0.0, we want to have the indexed map, and all calling contexts have access to it. | 
| XSSFColor(java.awt.Color clr)Deprecated. 
 3.17 beta 1 - pass the workbook styles indexed color map, if any | 
| XSSFColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)Deprecated. 
 3.17 beta 1 - pass the workbook styles indexed color map, if any | 
| XSSFColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color,
         IndexedColorMap map)Deprecated. 
 4.0.0 - use the factory  XSSFColor.from(CTColor, IndexedColorMap)method instead to check for null CTColor instances.  Make private eventually | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | AbstractXSSFChartSeriesDeprecated. 
 use  XDDFChartData.Seriesinstead | 
| class  | XSSFCategoryAxisDeprecated. 
 use  XDDFCategoryAxisinstead | 
| class  | XSSFChartAxisDeprecated. 
 use  XDDFChartAxisinstead | 
| class  | XSSFChartDataFactoryDeprecated.   | 
| class  | XSSFChartLegendDeprecated. 
 use  XDDFChartLegendinstead | 
| class  | XSSFDateAxisDeprecated. 
 use  XDDFDateAxisinstead | 
| class  | XSSFLineChartDataDeprecated. 
 use  XDDFLineChartDatainstead | 
| class  | XSSFManualLayoutDeprecated. 
 use  instead | 
| class  | XSSFScatterChartDataDeprecated. 
 use  XDDFScatterChartDatainstead | 
| class  | XSSFValueAxisDeprecated. 
 use  XDDFValueAxisinstead | 
| Modifier and Type | Method and Description | 
|---|---|
| long | XSSFXmlColumnPr. getId()Deprecated. 
 Use  XSSFTableColumn.getId()instead. | 
| Constructor and Description | 
|---|
| XSSFXmlColumnPr(XSSFTable table,
               org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTableColumn ctTableColum,
               org.openxmlformats.schemas.spreadsheetml.x2006.main.CTXmlColumnPr ctXmlColumnPr)Deprecated.  | 
| Modifier and Type | Method and Description | 
|---|---|
| void | XWPFTable. addNewRowBetween(int start,
                int end)Deprecated. 
 4.0.0 due to lack of implementation. | 
| VerticalAlign | XWPFRun. getSubscript()Deprecated. 
 use  XWPFRun.getVerticalAlignment | 
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.