Package | Description |
---|---|
org.apache.poi.hssf.converter | |
org.apache.poi.hssf.usermodel |
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
|
org.apache.poi.ss.usermodel | |
org.apache.poi.ss.util | |
org.apache.poi.xssf.usermodel | |
org.apache.poi.xssf.usermodel.extensions |
Modifier and Type | Method and Description |
---|---|
static java.lang.String |
AbstractExcelUtils.getBorderStyle(BorderStyle xlsBorder) |
static java.lang.String |
AbstractExcelUtils.getBorderWidth(BorderStyle xlsBorder) |
protected void |
ExcelToFoConverter.processCellStyleBorder(HSSFWorkbook workbook,
org.w3c.dom.Element cellTarget,
java.lang.String type,
BorderStyle xlsBorder,
short borderColor) |
Modifier and Type | Method and Description |
---|---|
BorderStyle |
HSSFCellStyle.getBorderBottom() |
BorderStyle |
HSSFBorderFormatting.getBorderBottom() |
BorderStyle |
HSSFCellStyle.getBorderBottomEnum() |
BorderStyle |
HSSFBorderFormatting.getBorderBottomEnum() |
BorderStyle |
HSSFBorderFormatting.getBorderDiagonal() |
BorderStyle |
HSSFBorderFormatting.getBorderDiagonalEnum() |
BorderStyle |
HSSFBorderFormatting.getBorderHorizontal()
HSSF doesn't support table borders, so always
NONE |
BorderStyle |
HSSFBorderFormatting.getBorderHorizontalEnum()
Deprecated.
|
BorderStyle |
HSSFCellStyle.getBorderLeft() |
BorderStyle |
HSSFBorderFormatting.getBorderLeft() |
BorderStyle |
HSSFCellStyle.getBorderLeftEnum() |
BorderStyle |
HSSFBorderFormatting.getBorderLeftEnum() |
BorderStyle |
HSSFCellStyle.getBorderRight() |
BorderStyle |
HSSFBorderFormatting.getBorderRight() |
BorderStyle |
HSSFCellStyle.getBorderRightEnum() |
BorderStyle |
HSSFBorderFormatting.getBorderRightEnum() |
BorderStyle |
HSSFCellStyle.getBorderTop() |
BorderStyle |
HSSFBorderFormatting.getBorderTop() |
BorderStyle |
HSSFCellStyle.getBorderTopEnum() |
BorderStyle |
HSSFBorderFormatting.getBorderTopEnum() |
BorderStyle |
HSSFBorderFormatting.getBorderVertical()
HSSF doesn't support table borders, so always
NONE |
BorderStyle |
HSSFBorderFormatting.getBorderVerticalEnum()
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
void |
HSSFCellStyle.setBorderBottom(BorderStyle border)
set the type of border to use for the bottom border of the cell
|
void |
HSSFBorderFormatting.setBorderBottom(BorderStyle border) |
void |
HSSFBorderFormatting.setBorderDiagonal(BorderStyle border) |
void |
HSSFBorderFormatting.setBorderHorizontal(BorderStyle border)
Not available for HSSF.
|
void |
HSSFCellStyle.setBorderLeft(BorderStyle border)
set the type of border to use for the left border of the cell
|
void |
HSSFBorderFormatting.setBorderLeft(BorderStyle border) |
void |
HSSFCellStyle.setBorderRight(BorderStyle border)
set the type of border to use for the right border of the cell
|
void |
HSSFBorderFormatting.setBorderRight(BorderStyle border) |
void |
HSSFCellStyle.setBorderTop(BorderStyle border)
set the type of border to use for the top border of the cell
|
void |
HSSFBorderFormatting.setBorderTop(BorderStyle border) |
void |
HSSFBorderFormatting.setBorderVertical(BorderStyle border)
Not available for HSSF.
|
Modifier and Type | Method and Description |
---|---|
BorderStyle |
CellStyle.getBorderBottom()
get the type of border to use for the bottom border of the cell
|
BorderStyle |
BorderFormatting.getBorderBottom() |
BorderStyle |
CellStyle.getBorderBottomEnum()
Deprecated.
use
getBorderBottom() instead |
BorderStyle |
BorderFormatting.getBorderBottomEnum()
Deprecated.
use
getBorderBottom instead |
BorderStyle |
BorderFormatting.getBorderDiagonal() |
BorderStyle |
BorderFormatting.getBorderDiagonalEnum()
Deprecated.
use
getBorderDiagonal instead |
BorderStyle |
BorderFormatting.getBorderHorizontal()
Only valid for range borders, such as table styles
|
BorderStyle |
BorderFormatting.getBorderHorizontalEnum()
Deprecated.
use
getBorderHorizontal instead |
BorderStyle |
CellStyle.getBorderLeft()
get the type of border to use for the left border of the cell
|
BorderStyle |
BorderFormatting.getBorderLeft() |
BorderStyle |
CellStyle.getBorderLeftEnum()
Deprecated.
use
getBorderLeft() instead |
BorderStyle |
BorderFormatting.getBorderLeftEnum()
Deprecated.
use
getBorderLeft instead |
BorderStyle |
CellStyle.getBorderRight()
get the type of border to use for the right border of the cell
|
BorderStyle |
BorderFormatting.getBorderRight() |
BorderStyle |
CellStyle.getBorderRightEnum()
Deprecated.
use
getBorderRight() instead |
BorderStyle |
BorderFormatting.getBorderRightEnum()
Deprecated.
use
getBorderRight instead |
BorderStyle |
CellStyle.getBorderTop()
get the type of border to use for the top border of the cell
|
BorderStyle |
BorderFormatting.getBorderTop() |
BorderStyle |
CellStyle.getBorderTopEnum()
Deprecated.
use
getBorderTop() instead |
BorderStyle |
BorderFormatting.getBorderTopEnum()
Deprecated.
use
getBorderTop instead |
BorderStyle |
BorderFormatting.getBorderVertical()
Only valid for range borders, such as table styles
|
BorderStyle |
BorderFormatting.getBorderVerticalEnum()
Deprecated.
use
getBorderVertical instead |
static BorderStyle |
BorderStyle.valueOf(short code) |
static BorderStyle |
BorderStyle.valueOf(java.lang.String name)
Returns the enum constant of this type with the specified name.
|
static BorderStyle[] |
BorderStyle.values()
Returns an array containing the constants of this enum type, in
the order they are declared.
|
Modifier and Type | Method and Description |
---|---|
void |
CellStyle.setBorderBottom(BorderStyle border)
set the type of border to use for the bottom border of the cell
|
void |
BorderFormatting.setBorderBottom(BorderStyle border)
Set bottom border.
|
void |
BorderFormatting.setBorderDiagonal(BorderStyle border)
Set diagonal border.
|
void |
BorderFormatting.setBorderHorizontal(BorderStyle border)
Set range internal horizontal borders.
|
void |
CellStyle.setBorderLeft(BorderStyle border)
set the type of border to use for the left border of the cell
|
void |
BorderFormatting.setBorderLeft(BorderStyle border)
Set left border.
|
void |
CellStyle.setBorderRight(BorderStyle border)
set the type of border to use for the right border of the cell
|
void |
BorderFormatting.setBorderRight(BorderStyle border)
Set right border.
|
void |
CellStyle.setBorderTop(BorderStyle border)
set the type of border to use for the top border of the cell
|
void |
BorderFormatting.setBorderTop(BorderStyle border)
Set top border.
|
void |
BorderFormatting.setBorderVertical(BorderStyle border)
Set range internal vertical borders.
|
Modifier and Type | Method and Description |
---|---|
BorderStyle |
PropertyTemplate.getBorderStyle(CellAddress cell,
java.lang.String property)
Retrieves the border style for a given cell
|
BorderStyle |
PropertyTemplate.getBorderStyle(int row,
int col,
java.lang.String property)
Retrieves the border style for a given cell
|
Modifier and Type | Method and Description |
---|---|
void |
PropertyTemplate.drawBorders(CellRangeAddress range,
BorderStyle borderType,
BorderExtent extent)
Draws a group of cell borders for a cell range.
|
void |
PropertyTemplate.drawBorders(CellRangeAddress range,
BorderStyle borderType,
short color,
BorderExtent extent)
Draws a group of cell borders for a cell range.
|
static void |
RegionUtil.setBorderBottom(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the bottom border style for a region of cells by manipulating the cell style of the individual
cells on the bottom
|
static void |
RegionUtil.setBorderLeft(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the left border style for a region of cells by manipulating the cell style of the individual
cells on the left
|
static void |
RegionUtil.setBorderRight(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the right border style for a region of cells by manipulating the cell style of the individual
cells on the right
|
static void |
RegionUtil.setBorderTop(BorderStyle border,
CellRangeAddress region,
Sheet sheet)
Sets the top border style for a region of cells by manipulating the cell style of the individual
cells on the top
|
Modifier and Type | Method and Description |
---|---|
void |
XSSFCellStyle.setBorderBottom(BorderStyle border)
Set the type of border to use for the bottom border of the cell
|
void |
XSSFBorderFormatting.setBorderBottom(BorderStyle border) |
void |
XSSFBorderFormatting.setBorderDiagonal(BorderStyle border) |
void |
XSSFBorderFormatting.setBorderHorizontal(BorderStyle border) |
void |
XSSFCellStyle.setBorderLeft(BorderStyle border)
Set the type of border to use for the left border of the cell
|
void |
XSSFBorderFormatting.setBorderLeft(BorderStyle border) |
void |
XSSFCellStyle.setBorderRight(BorderStyle border)
Set the type of border to use for the right border of the cell
|
void |
XSSFBorderFormatting.setBorderRight(BorderStyle border) |
void |
XSSFCellStyle.setBorderTop(BorderStyle border)
Set the type of border to use for the top border of the cell
|
void |
XSSFBorderFormatting.setBorderTop(BorderStyle border) |
void |
XSSFBorderFormatting.setBorderVertical(BorderStyle border) |
Modifier and Type | Method and Description |
---|---|
BorderStyle |
XSSFCellBorder.getBorderStyle(XSSFCellBorder.BorderSide side)
Get the type of border to use for the selected border
|
Modifier and Type | Method and Description |
---|---|
void |
XSSFCellBorder.setBorderStyle(XSSFCellBorder.BorderSide side,
BorderStyle style)
Set the type of border to use for the selected border
|
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.