Package | Description |
---|---|
org.apache.poi.common.usermodel | |
org.apache.poi.hssf.model |
Provides low level API structures for reading, writing, modifying XLS files.
|
org.apache.poi.hssf.usermodel |
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
|
org.apache.poi.hssf.util |
util package contains tools needed for writing HSSF files that are not necesarily "real"
HSSF concepts.
|
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.util | |
org.apache.poi.xssf.streaming | |
org.apache.poi.xssf.usermodel | |
org.apache.poi.xssf.usermodel.helpers |
Modifier and Type | Field and Description |
---|---|
static int |
Hyperlink.LINK_DOCUMENT
Deprecated.
POI 3.15 beta 3. Use
HyperlinkType.DOCUMENT instead. |
static int |
Hyperlink.LINK_EMAIL
Deprecated.
POI 3.15 beta 3. Use
HyperlinkType.EMAIL instead. |
static int |
Hyperlink.LINK_FILE
Deprecated.
POI 3.15 beta 3. Use
HyperlinkType.FILE instead. |
static int |
Hyperlink.LINK_URL
Deprecated.
POI 3.15 beta 3. Use
HyperlinkType.URL instead. |
Modifier and Type | Method and Description |
---|---|
static Ptg[] |
HSSFFormulaParser.parse(java.lang.String formula,
HSSFWorkbook workbook,
int formulaType)
Deprecated.
POI 3.15 beta 3. Use
HSSFFormulaParser.parse(String, HSSFWorkbook, FormulaType) instead. |
static Ptg[] |
HSSFFormulaParser.parse(java.lang.String formula,
HSSFWorkbook workbook,
int formulaType,
int sheetIndex)
Deprecated.
POI 3.15 beta 3. Use
HSSFFormulaParser.parse(String, HSSFWorkbook, FormulaType, int) instead. |
Modifier and Type | Method and Description |
---|---|
HSSFHyperlink |
HSSFCreationHelper.createHyperlink(int type)
Deprecated.
POI 3.15 beta 3. Use
HSSFCreationHelper.createHyperlink(HyperlinkType) instead. |
void |
HSSFCellStyle.setAlignment(short align)
Deprecated.
POI 3.15 beta 3. Use
HSSFCellStyle.setAlignment(HorizontalAlignment) instead. |
void |
HSSFClientAnchor.setAnchorType(int anchorType)
Deprecated.
POI 3.15. Use
ClientAnchor.setAnchorType(AnchorType) instead. |
void |
HSSFCellStyle.setBorderBottom(short border)
Deprecated.
3.15 beta 2. Use
HSSFCellStyle.setBorderBottom(BorderStyle) instead. |
void |
HSSFCellStyle.setBorderLeft(short border)
Deprecated.
3.15 beta 2. Use
HSSFCellStyle.setBorderLeft(BorderStyle) instead. |
void |
HSSFCellStyle.setBorderRight(short border)
Deprecated.
3.15 beta 2. Use
HSSFCellStyle.setBorderRight(BorderStyle) instead. |
void |
HSSFCellStyle.setBorderTop(short border)
Deprecated.
3.15 beta 2. Use
HSSFCellStyle.setBorderTop(BorderStyle) instead. |
void |
HSSFCellStyle.setFillPattern(short fp)
Deprecated.
POI 3.15 beta 3. Use
HSSFCellStyle.setFillPattern(FillPatternType) instead. |
void |
HSSFCellStyle.setVerticalAlignment(short align)
Deprecated.
POI 3.15 beta 3. Use
HSSFCellStyle.setVerticalAlignment(VerticalAlignment) instead. |
Modifier and Type | Class and Description |
---|---|
class |
HSSFCellUtil
Deprecated.
3.15 beta2. Use
CellUtil instead. |
Modifier and Type | Field and Description |
---|---|
static short |
CellStyle.ALIGN_CENTER
Deprecated.
POI 3.15 beta 3. Use
HorizontalAlignment.CENTER instead. |
static short |
CellStyle.ALIGN_CENTER_SELECTION
Deprecated.
POI 3.15 beta 3. Use
HorizontalAlignment.CENTER_SELECTION instead. |
static short |
CellStyle.ALIGN_FILL
Deprecated.
POI 3.15 beta 3. Use
HorizontalAlignment.FILL instead. |
static short |
CellStyle.ALIGN_GENERAL
Deprecated.
POI 3.15 beta 3. Use
HorizontalAlignment.GENERAL instead. |
static short |
CellStyle.ALIGN_JUSTIFY
Deprecated.
POI 3.15 beta 3. Use
HorizontalAlignment.JUSTIFY instead. |
static short |
CellStyle.ALIGN_LEFT
Deprecated.
POI 3.15 beta 3. Use
HorizontalAlignment.LEFT instead. |
static short |
CellStyle.ALIGN_RIGHT
Deprecated.
POI 3.15 beta 3. Use
HorizontalAlignment.RIGHT instead. |
static short |
CellStyle.ALT_BARS
Deprecated.
3.15 beta 3. Use
FillPatternType.ALT_BARS instead. |
static short |
CellStyle.BIG_SPOTS
Deprecated.
3.15 beta 3. Use
FillPatternType.BIG_SPOTS instead. |
static short |
BorderFormatting.BORDER_DASH_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.DASH_DOT |
static short |
CellStyle.BORDER_DASH_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.DASH_DOT instead. |
static short |
BorderFormatting.BORDER_DASH_DOT_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.DASH_DOT_DOT |
static short |
CellStyle.BORDER_DASH_DOT_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.DASH_DOT_DOT instead. |
static short |
BorderFormatting.BORDER_DASHED
Deprecated.
3.15 beta 2. Use
BorderStyle.DASHED |
static short |
CellStyle.BORDER_DASHED
Deprecated.
3.15 beta 2. Use
BorderStyle.DASHED instead. |
static short |
BorderFormatting.BORDER_DOTTED
Deprecated.
3.15 beta 2. Use
BorderStyle.DOTTED |
static short |
CellStyle.BORDER_DOTTED
Deprecated.
3.15 beta 2. Use
BorderStyle.DOTTED instead. |
static short |
BorderFormatting.BORDER_DOUBLE
Deprecated.
3.15 beta 2. Use
BorderStyle.DOUBLE |
static short |
CellStyle.BORDER_DOUBLE
Deprecated.
3.15 beta 2. Use
BorderStyle.DOUBLE instead. |
static short |
BorderFormatting.BORDER_HAIR
Deprecated.
3.15 beta 2. Use
BorderStyle.HAIR |
static short |
CellStyle.BORDER_HAIR
Deprecated.
3.15 beta 2. Use
BorderStyle.HAIR instead. |
static short |
BorderFormatting.BORDER_MEDIUM
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM |
static short |
CellStyle.BORDER_MEDIUM
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM instead. |
static short |
BorderFormatting.BORDER_MEDIUM_DASH_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM_DASH_DOT |
static short |
CellStyle.BORDER_MEDIUM_DASH_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM_DASH_DOT instead. |
static short |
BorderFormatting.BORDER_MEDIUM_DASH_DOT_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM_DASH_DOT_DOT |
static short |
CellStyle.BORDER_MEDIUM_DASH_DOT_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM_DASH_DOT_DOT instead. |
static short |
BorderFormatting.BORDER_MEDIUM_DASHED
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM_DASHED |
static short |
CellStyle.BORDER_MEDIUM_DASHED
Deprecated.
3.15 beta 2. Use
BorderStyle.MEDIUM_DASHED instead. |
static short |
BorderFormatting.BORDER_NONE
Deprecated.
3.15 beta 2. Use
BorderStyle.NONE |
static short |
CellStyle.BORDER_NONE
Deprecated.
3.15 beta 2. Use
BorderStyle.NONE instead. |
static short |
BorderFormatting.BORDER_SLANTED_DASH_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.SLANTED_DASH_DOT |
static short |
CellStyle.BORDER_SLANTED_DASH_DOT
Deprecated.
3.15 beta 2. Use
BorderStyle.SLANTED_DASH_DOT instead. |
static short |
BorderFormatting.BORDER_THICK
Deprecated.
3.15 beta 2. Use
BorderStyle.THICK |
static short |
CellStyle.BORDER_THICK
Deprecated.
3.15 beta 2. Use
BorderStyle.THICK instead. |
static short |
BorderFormatting.BORDER_THIN
Deprecated.
3.15 beta 2. Use
BorderStyle.THIN |
static short |
CellStyle.BORDER_THIN
Deprecated.
3.15 beta 2. Use
BorderStyle.THIN instead. |
static short |
CellStyle.BRICKS
Deprecated.
3.15 beta 3. Use
FillPatternType.BRICKS instead. |
static int |
Cell.CELL_TYPE_BLANK
Deprecated.
POI 3.15 beta 3. Use
CellType.BLANK instead. |
static int |
Cell.CELL_TYPE_BOOLEAN
Deprecated.
POI 3.15 beta 3. Use
CellType.BOOLEAN instead. |
static int |
Cell.CELL_TYPE_ERROR
Deprecated.
POI 3.15 beta 3. Use
CellType.ERROR instead. |
static int |
Cell.CELL_TYPE_FORMULA
Deprecated.
POI 3.15 beta 3. Use
CellType.FORMULA instead. |
static int |
Cell.CELL_TYPE_NUMERIC
Deprecated.
POI 3.15 beta 3. Use
CellType.NUMERIC instead. |
static int |
Cell.CELL_TYPE_STRING
Deprecated.
POI 3.15 beta 3. Use
CellType.STRING instead. |
static Row.MissingCellPolicy |
Row.CREATE_NULL_AS_BLANK
Deprecated.
as of POI 3.15-beta2, scheduled for removal in 3.17 - use the MissingCellPolicy enum
|
static short |
CellStyle.DIAMONDS
Deprecated.
3.15 beta 3. Use
FillPatternType.DIAMONDS instead. |
static ClientAnchor.AnchorType |
ClientAnchor.DONT_MOVE_AND_RESIZE
Deprecated.
since POI 3.14beta1 (circa 2015-11-24). Use
ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE instead. |
static short |
CellStyle.FINE_DOTS
Deprecated.
3.15 beta 3. Use
FillPatternType.FINE_DOTS instead. |
int |
Row.MissingCellPolicy.id
Deprecated.
as of POI 3.15-beta2, scheduled for removal in 3.17 - the id has no function and will be removed.
The
id is only kept only for backwards compatibility with applications that hard-coded the number |
static short |
CellStyle.LEAST_DOTS
Deprecated.
3.15 beta 3. Use
FillPatternType.LEAST_DOTS instead. |
static short |
CellStyle.LESS_DOTS
Deprecated.
3.15 beta 3. Use
FillPatternType.LESS_DOTS instead. |
static ClientAnchor.AnchorType |
ClientAnchor.MOVE_AND_RESIZE
Deprecated.
since POI 3.14beta1 (circa 2015-11-24). Use
ClientAnchor.AnchorType.MOVE_AND_RESIZE instead. |
static ClientAnchor.AnchorType |
ClientAnchor.MOVE_DONT_RESIZE
Deprecated.
since POI 3.14beta1 (circa 2015-11-24). Use
ClientAnchor.AnchorType.MOVE_DONT_RESIZE instead. |
static short |
CellStyle.NO_FILL
Deprecated.
3.15 beta 3. Use
FillPatternType.NO_FILL instead. |
static Row.MissingCellPolicy |
Row.RETURN_BLANK_AS_NULL
Deprecated.
as of POI 3.15-beta2, scheduled for removal in 3.17 - use the MissingCellPolicy enum
|
static Row.MissingCellPolicy |
Row.RETURN_NULL_AND_BLANK
Deprecated.
as of POI 3.15-beta2, scheduled for removal in 3.17 - use the MissingCellPolicy enum
|
static short |
CellStyle.SOLID_FOREGROUND
Deprecated.
3.15 beta 3. Use
FillPatternType.SOLID_FOREGROUND instead. |
static short |
CellStyle.SPARSE_DOTS
Deprecated.
3.15 beta 3. Use
FillPatternType.SPARSE_DOTS instead. |
static short |
CellStyle.SQUARES
Deprecated.
3.15 beta 3. Use
FillPatternType.SQUARES instead. |
static short |
CellStyle.THICK_BACKWARD_DIAG
Deprecated.
3.15 beta 3. Use
FillPatternType.THICK_BACKWARD_DIAG instead. |
static short |
CellStyle.THICK_FORWARD_DIAG
Deprecated.
3.15 beta 3. Use
FillPatternType.THICK_FORWARD_DIAG instead. |
static short |
CellStyle.THICK_HORZ_BANDS
Deprecated.
3.15 beta 3. Use
FillPatternType.THICK_HORZ_BANDS instead. |
static short |
CellStyle.THICK_VERT_BANDS
Deprecated.
3.15 beta 3. Use
FillPatternType.THICK_VERT_BANDS instead. |
static short |
CellStyle.THIN_BACKWARD_DIAG
Deprecated.
3.15 beta 3. Use
FillPatternType.THIN_BACKWARD_DIAG instead. |
static short |
CellStyle.THIN_FORWARD_DIAG
Deprecated.
3.15 beta 3. Use
FillPatternType.THIN_FORWARD_DIAG instead. |
static short |
CellStyle.THIN_HORZ_BANDS
Deprecated.
3.15 beta 3. Use
FillPatternType.THIN_HORZ_BANDS instead. |
static short |
CellStyle.THIN_VERT_BANDS
Deprecated.
3.15 beta 3. Use
FillPatternType.THIN_VERT_BANDS instead. |
static short |
CellStyle.VERTICAL_BOTTOM
Deprecated.
POI 3.15 beta 3. Use
VerticalAlignment.BOTTOM instead. |
static short |
CellStyle.VERTICAL_CENTER
Deprecated.
POI 3.15 beta 3. Use
VerticalAlignment.CENTER instead. |
static short |
CellStyle.VERTICAL_JUSTIFY
Deprecated.
POI 3.15 beta 3. Use
VerticalAlignment.JUSTIFY instead. |
static short |
CellStyle.VERTICAL_TOP
Deprecated.
POI 3.15 beta 3. Use
VerticalAlignment.TOP instead. |
Modifier and Type | Method and Description |
---|---|
Hyperlink |
CreationHelper.createHyperlink(int type)
Deprecated.
POI 3.15 beta 3. Use
CreationHelper.createHyperlink(HyperlinkType) instead. |
CellType |
Cell.getCellTypeEnum()
Deprecated.
POI 3.15 beta 3
Will be renamed to
getCellType() when we make the CellType enum transition in POI 4.0. See bug 59791. |
void |
ClientAnchor.setAnchorType(int anchorType)
Deprecated.
POI 3.15. Use
ClientAnchor.setAnchorType(AnchorType) instead. |
void |
CellStyle.setBorderBottom(short border)
Deprecated.
3.15 beta 2. Use
CellStyle.setBorderBottom(BorderStyle) instead. |
void |
CellStyle.setBorderLeft(short border)
Deprecated.
3.15 beta 2. Use
CellStyle.setBorderLeft(BorderStyle) instead |
void |
CellStyle.setBorderRight(short border)
Deprecated.
3.15 beta 2. Use
CellStyle.setBorderRight(BorderStyle) instead |
void |
CellStyle.setBorderTop(short border)
Deprecated.
3.15 beta 2. Use
CellStyle.setBorderTop(BorderStyle) instead |
void |
Cell.setCellType(int cellType)
Deprecated.
POI 3.15 beta 3. Use
Cell.setCellType(CellType) instead. |
void |
Sheet.setZoom(int numerator,
int denominator)
Deprecated.
2015-11-23 (circa POI 3.14beta1). Use
Sheet.setZoom(int) instead. |
Modifier and Type | Method and Description |
---|---|
static void |
CellUtil.setAlignment(Cell cell,
Workbook workbook,
short align)
Deprecated.
3.15-beta2. Use
CellUtil.setAlignment(Cell, HorizontalAlignment) instead. |
static void |
CellUtil.setCellStyleProperty(Cell cell,
Workbook workbook,
java.lang.String propertyName,
java.lang.Object propertyValue)
Deprecated.
3.15-beta2. Use
CellUtil.setCellStyleProperty(Cell, String, Object) instead. |
static void |
CellUtil.setFont(Cell cell,
Workbook workbook,
Font font)
Deprecated.
3.15-beta2. Use
CellUtil.setFont(Cell, Font) instead. |
Modifier and Type | Method and Description |
---|---|
Hyperlink |
SXSSFCreationHelper.createHyperlink(int type)
Deprecated.
POI 3.15 beta 3. Use
SXSSFCreationHelper.createHyperlink(HyperlinkType) instead. |
void |
SXSSFSheet.setZoom(int numerator,
int denominator)
Deprecated.
2015-11-23 (circa POI 3.14beta1). Use
SXSSFSheet.setZoom(int) instead. |
Constructor and Description |
---|
SXSSFCell(SXSSFRow row,
int cellType)
Deprecated.
POI 3.15 beta 3.
Will be deleted when we make the CellType enum transition. See bug 59791.
|
Modifier and Type | Method and Description |
---|---|
XSSFHyperlink |
XSSFCreationHelper.createHyperlink(int type)
Deprecated.
POI 3.15 beta 3. Use
XSSFCreationHelper.createHyperlink(HyperlinkType) instead. |
void |
XSSFCellStyle.setAlignment(short align)
Deprecated.
POI 3.15 beta 3. Use
XSSFCellStyle.setAlignment(HorizontalAlignment) instead. |
void |
XSSFClientAnchor.setAnchorType(int anchorType)
Deprecated.
POI 3.15. Use
ClientAnchor.setAnchorType(AnchorType) instead |
void |
XSSFCellStyle.setBorderBottom(short border)
Deprecated.
3.15 beta 2. Use
XSSFCellStyle.setBorderBottom(BorderStyle) |
void |
XSSFCellStyle.setBorderLeft(short border)
Deprecated.
3.15 beta 2. Use
XSSFCellStyle.setBorderLeft(BorderStyle) |
void |
XSSFCellStyle.setBorderRight(short border)
Deprecated.
3.15 beta 2. Use
XSSFCellStyle.setBorderRight(BorderStyle) |
void |
XSSFCellStyle.setBorderTop(short border)
Deprecated.
3.15 beta 2. Use
XSSFCellStyle.setBorderTop(BorderStyle) |
void |
XSSFCellStyle.setFillPattern(short fp)
Deprecated.
POI 3.15. Use
XSSFCellStyle.setFillPattern(FillPatternType) instead. |
void |
XSSFCellStyle.setVerticalAlignment(short align)
Deprecated.
POI 3.15 beta 3. Use
XSSFCellStyle.setVerticalAlignment(VerticalAlignment) instead. |
void |
XSSFSheet.setZoom(int numerator,
int denominator)
Deprecated.
2015-11-23 (circa POI 3.14beta1). Use
XSSFSheet.setZoom(int) instead. |
Modifier and Type | Class and Description |
---|---|
class |
XSSFPaswordHelper
Deprecated.
POI 3.15 beta 3. Use
XSSFPasswordHelper instead. |
Copyright 2018 The Apache Software Foundation or its licensors, as applicable.