Deprecated List (POI API Documentation)

Deprecated Classes
Class and Description
org.apache.poi.hssf.model.AbstractShape
org.apache.poi.hssf.util.CellRangeAddress use `CellRangeAddress`
org.apache.poi.hssf.util.CellRangeAddressList use `CellRangeAddressList`
org.apache.poi.hssf.model.ComboboxShape
org.apache.poi.hssf.model.CommentShape
org.apache.poi.hpsf.Constants Use `CodePageUtil` to lookup code pages
org.apache.poi.hssf.model.LineShape
org.apache.poi.hssf.model.PolygonShape
org.apache.poi.hssf.util.Region (Aug-2008) use `CellRangeAddress`
org.apache.poi.ss.util.Region (Aug-2008) use `CellRangeAddress`
org.apache.poi.hssf.model.SimpleFilledShape
org.apache.poi.hssf.model.TextboxShape
org.apache.poi.hssf.record.UnicodeString Use `UnicodeString` instead

Deprecated Fields
Field and Description
org.apache.poi.hssf.record.PaneRecord.ACTIVE_PANE_UPER_LEFT use ACTIVE_PANE_UPPER_LEFT
org.apache.poi.ss.formula.eval.BlankEval.INSTANCE (Nov 2009) use `BlankEval.instance`

Deprecated Methods
Method and Description
org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting.addConditionalFormatting(Region[], HSSFConditionalFormattingRule[]) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.usermodel.HSSFSheet.addMergedRegion(Region) (Aug-2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.usermodel.HSSFWorkbook.addSSTString(String) Do not call this method from your applications. Use the methods available in the HSSFRow to add string HSSFCells
org.apache.poi.hssf.record.ExternSheetRecord.adjustIndex(int, int) Was prevously used for removing sheets, which we now do differently
org.apache.poi.POIDocument.copyNodeRecursively(Entry, DirectoryEntry) Use `EntryUtils.copyNodeRecursively(Entry, DirectoryEntry)` instead
org.apache.poi.poifs.filesystem.EntryUtils.copyNodes(DirectoryEntry, DirectoryEntry, List) use `FilteringDirectoryNode` instead
org.apache.poi.POIDocument.copyNodes(DirectoryNode, DirectoryNode, List) Use `EntryUtils.copyNodes(DirectoryEntry, DirectoryEntry, List)` instead
org.apache.poi.POIDocument.copyNodes(POIFSFileSystem, POIFSFileSystem, List) Use `EntryUtils.copyNodes(DirectoryEntry, DirectoryEntry, List)` instead
org.apache.poi.ss.formula.eval.forked.ForkedEvaluator.create(Workbook, IStabilityClassifier) (Sep 2009) (reduce overloading) use `ForkedEvaluator.create(Workbook, IStabilityClassifier, UDFFinder)`
org.apache.poi.hssf.usermodel.HSSFRow.createCell(short) (Aug 2008) use `HSSFRow.createCell(int)`
org.apache.poi.hssf.usermodel.HSSFRow.createCell(short, int) (Aug 2008) use `HSSFRow.createCell(int, int)`
org.apache.poi.hssf.usermodel.HSSFWorkbook.findSheetNameFromExternSheet(int) for POI internal use only (formula rendering). This method is likely to be removed in future versions of POI.
org.apache.poi.hpsf.wellknown.SectionIDMap.get(Object) Use `SectionIDMap.get(byte[])` instead!
org.apache.poi.poifs.crypt.EncryptionHeader.getAlgorithm() use getCipherAlgorithm()
org.apache.poi.poifs.crypt.EncryptionVerifier.getAlgorithmName() use getCipherAlgorithm().jceId
org.apache.poi.ss.usermodel.BuiltinFormats.getBuiltinFormats() (May 2009) use `BuiltinFormats.getAll()`
org.apache.poi.hssf.usermodel.HSSFRow.getCell(short) (Aug 2008) use `HSSFRow.getCell(int)`
org.apache.poi.hssf.usermodel.HSSFCell.getCellNum() (Oct 2008) use `HSSFCell.getColumnIndex()`
org.apache.poi.poifs.crypt.EncryptionHeader.getCipherMode() use getChainingMode().ecmaId
org.apache.poi.hssf.usermodel.HSSFSheet.getColumnWidth(short) (Sep 2008) use `HSSFSheet.getColumnWidth(int)`
org.apache.poi.hssf.record.DrawingRecord.getData()
org.apache.poi.hssf.record.WindowOneRecord.getDisplayedTab() - Misleading name - use getFirstVisibleTab()
org.apache.poi.hssf.usermodel.HSSFWorkbook.getDisplayedTab() - Misleading name - use getFirstVisibleTab()
org.apache.poi.hssf.record.FilePassRecord.getDocId() use getRc4KeyData().getSalt()
org.apache.poi.hssf.usermodel.HSSFWorkbook.getExternalSheetIndex(int) for POI internal use only (formula parsing). This method is likely to be removed in future versions of POI.
org.apache.poi.POIOLE2TextExtractor.getFileSystem() Use `POIOLE2TextExtractor.getRoot()` instead
org.apache.poi.hssf.extractor.EventBasedExcelExtractor.getFileSystem() Use `POIOLE2TextExtractor.getRoot()` instead
org.apache.poi.hssf.usermodel.HSSFConditionalFormatting.getFormattingRegions() (Aug-2008) use `HSSFConditionalFormatting.getFormattingRanges()`
org.apache.poi.poifs.crypt.EncryptionHeader.getHashAlgorithm() use getHashAlgorithmEx()
org.apache.poi.hssf.usermodel.HSSFSheet.getMergedRegionAt(int) (Aug-2008) use `HSSFSheet.getMergedRegion(int)`
org.apache.poi.hssf.record.WindowTwoRecord.getPaged() use isActive()
org.apache.poi.poifs.crypt.EncryptionHeader.getProviderType() use getCipherProvider()
org.apache.poi.hssf.usermodel.HSSFName.getReference() (Nov 2008) Misleading name. Use `HSSFName.getRefersToFormula()` instead.
org.apache.poi.hssf.record.FilePassRecord.getSaltData() use getRc4KeyData().getEncryptedVerifier()
org.apache.poi.hssf.record.FilePassRecord.getSaltHash() use getRc4KeyData().getEncryptedVerifierHash()
org.apache.poi.hssf.record.WindowOneRecord.getSelectedTab() - Misleading name - use getActiveSheetIndex()
org.apache.poi.hssf.usermodel.HSSFWorkbook.getSelectedTab() - Misleading name - use getActiveSheetIndex()
org.apache.poi.hssf.usermodel.HSSFWorkbook.getSheetIndexFromExternSheetIndex(int) for POI internal use only (formula parsing). This method is likely to be removed in future versions of POI.
org.apache.poi.hssf.usermodel.HSSFWorkbook.getSSTString(int) Do not call this method from your applications. Use the methods available in the HSSFRow to get string HSSFCells
org.apache.poi.util.LittleEndian.getUnsignedByte(byte[], int) Use `LittleEndian.getUByte(byte[], int)` instead
org.apache.poi.hssf.model.InternalSheet.getValueRecords() use `InternalSheet.getCellValueIterator()` instead
org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate.getValueRecords() use `ValueRecordsAggregate.iterator()` instead
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.getValueRecords() use `RowRecordsAggregate.getCellValueIterator()` instead
org.apache.poi.poifs.crypt.EncryptionVerifier.getVerifier() use getEncryptedVerifier()
org.apache.poi.poifs.crypt.EncryptionVerifier.getVerifierHash() use getEnryptedVerifierHash
org.apache.poi.hssf.usermodel.HSSFSheet.getVerticallyCenter(boolean) (Mar-2008) use getVerticallyCenter() instead
org.apache.poi.hssf.usermodel.HSSFSheet.groupColumn(short, short) (Sep 2008) use `HSSFSheet.groupColumn(int, int)`
org.apache.poi.hssf.record.PasswordRecord.hashPassword(String) use `CryptoFunctions.createXorVerifier1(String)`
org.apache.poi.hssf.usermodel.HSSFSheet.isColumnHidden(short) (Sep 2008) use `HSSFSheet.isColumnHidden(int)`
org.apache.poi.hssf.record.DrawingRecord.processContinueRecord(byte[])
org.apache.poi.hpsf.wellknown.SectionIDMap.put(Object, Object) Use `SectionIDMap.put(byte[], PropertyIDMap)` instead!
org.apache.poi.util.LittleEndian.putInt(byte[], int) Use `LittleEndian.putInt(byte[], int, int)` instead
org.apache.poi.util.LittleEndian.putShort(byte[], short) Use `LittleEndian.putShort(byte[], int, short)` instead
org.apache.poi.util.LittleEndian.putUInt(byte[], long) Use `LittleEndian.putUInt(byte[], int, long)` instead
org.apache.poi.hssf.record.RecordInputStream.readAllContinuedRemainder() Best to write a input stream that wraps this one where there is special sub record that may overlap continue records.
org.apache.poi.hssf.usermodel.HSSFWorkbook.resolveNameXText(int, int) for POI internal use only (formula rendering). This method is likely to be removed in future versions of POI.
org.apache.poi.hssf.util.CellRangeAddress8Bit.serialize(int, byte[]) use `CellRangeAddress8Bit.serialize(LittleEndianOutput)`
org.apache.poi.ss.util.CellRangeAddress.serialize(int, byte[]) use `CellRangeAddress.serialize(LittleEndianOutput)`
org.apache.poi.hssf.util.HSSFRegionUtil.setBorderBottom(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.util.HSSFRegionUtil.setBorderLeft(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.util.HSSFRegionUtil.setBorderRight(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.util.HSSFRegionUtil.setBorderTop(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.util.HSSFRegionUtil.setBottomBorderColor(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.usermodel.HSSFCell.setCellNum(short) (Jan 2008) Doesn't update the row's idea of what cell this is, use `HSSFRow.moveCell(HSSFCell, short)` instead
org.apache.poi.hssf.usermodel.HSSFComment.setColumn(short) (Nov 2009) use `HSSFComment.setColumn(int)` }
org.apache.poi.hssf.usermodel.HSSFSheet.setColumnGroupCollapsed(short, boolean) (Sep 2008) use `HSSFSheet.setColumnGroupCollapsed(int, boolean)`
org.apache.poi.hssf.usermodel.HSSFSheet.setColumnHidden(short, boolean) (Sep 2008) use `HSSFSheet.setColumnHidden(int, boolean)`
org.apache.poi.hssf.usermodel.HSSFSheet.setColumnWidth(short, short) (Sep 2008) use `HSSFSheet.setColumnWidth(int, int)`
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.setCurrentRow(HSSFRow) (Aug 2008) - not needed, since the current row can be derived from the cell
org.apache.poi.hssf.usermodel.HSSFSheet.setDefaultColumnWidth(short) (Sep 2008) use `HSSFSheet.setDefaultColumnWidth(int)`
org.apache.poi.hssf.record.WindowOneRecord.setDisplayedTab(short) - Misleading name - use setFirstVisibleTab()
org.apache.poi.hssf.usermodel.HSSFWorkbook.setDisplayedTab(short) - Misleading name - use setFirstVisibleTab()
org.apache.poi.hssf.record.FilePassRecord.setDocId(byte[]) use getRc4KeyData().setSalt()
org.apache.poi.hssf.util.HSSFRegionUtil.setLeftBorderColor(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.record.WindowTwoRecord.setPaged(boolean) use setActive()
org.apache.poi.hssf.usermodel.HSSFName.setReference(String) (Nov 2008) Misleading name. Use `HSSFName.setRefersToFormula(String)` instead.
org.apache.poi.hssf.usermodel.HSSFWorkbook.setRepeatingRowsAndColumns(int, int, int, int, int) use `HSSFSheet.setRepeatingRows(CellRangeAddress)` or `HSSFSheet.setRepeatingColumns(CellRangeAddress)`
org.apache.poi.ss.usermodel.Workbook.setRepeatingRowsAndColumns(int, int, int, int, int) use `Sheet.setRepeatingRows(CellRangeAddress)` or `Sheet.setRepeatingColumns(CellRangeAddress)`
org.apache.poi.hssf.util.HSSFRegionUtil.setRightBorderColor(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.hssf.record.FilePassRecord.setSaltData(byte[]) use getRc4KeyData().setEncryptedVerifier()
org.apache.poi.hssf.record.FilePassRecord.setSaltHash(byte[]) use getRc4KeyData().setEncryptedVerifierHash()
org.apache.poi.hssf.record.WindowOneRecord.setSelectedTab(short) - Misleading name - use setActiveSheetIndex()
org.apache.poi.hssf.usermodel.HSSFWorkbook.setSelectedTab(short) use setSelectedTab(int)
org.apache.poi.hssf.util.HSSFRegionUtil.setTopBorderColor(short, Region, HSSFSheet, HSSFWorkbook) (Aug 2008) use `CellRangeAddress` instead of `Region`
org.apache.poi.ss.usermodel.Sheet.showInPane(short, short) Use `Sheet.showInPane(int, int)` as there can be more than 32767 rows.
org.apache.poi.hssf.usermodel.HSSFSheet.ungroupColumn(short, short) (Sep 2008) use `HSSFSheet.ungroupColumn(int, int)`

Deprecated Constructors
Constructor and Description
org.apache.poi.hssf.extractor.EventBasedExcelExtractor(DirectoryNode, POIFSFileSystem) Use `EventBasedExcelExtractor.EventBasedExcelExtractor(DirectoryNode)` instead
org.apache.poi.hssf.extractor.ExcelExtractor(DirectoryNode, POIFSFileSystem) Use `ExcelExtractor.ExcelExtractor(DirectoryNode)` instead
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator(HSSFSheet, HSSFWorkbook) (Sep 2008) HSSFSheet parameter is ignored
org.apache.poi.poifs.filesystem.Ole10Native(byte[], int, boolean) parameter plain is ignored, use `Ole10Native.Ole10Native(byte[],int)`
org.apache.poi.POIDocument(DirectoryNode, POIFSFileSystem) use `POIDocument.POIDocument(DirectoryNode)` instead
org.apache.poi.hssf.record.UnicodeString(RecordInputStream) Use `UnicodeString` instead
org.apache.poi.hssf.record.UnicodeString(String) Use `UnicodeString` instead

Deprecated API

Contents