| Package | Description |
|---|---|
| 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 |
| Modifier and Type | Method and Description |
|---|---|
BorderStyle |
HSSFCellStyle.getBorderBottom() |
BorderStyle |
HSSFBorderFormatting.getBorderBottom() |
BorderStyle |
HSSFBorderFormatting.getBorderDiagonal() |
BorderStyle |
HSSFBorderFormatting.getBorderHorizontal()
HSSF doesn't support table borders, so always
NONE |
BorderStyle |
HSSFCellStyle.getBorderLeft() |
BorderStyle |
HSSFBorderFormatting.getBorderLeft() |
BorderStyle |
HSSFCellStyle.getBorderRight() |
BorderStyle |
HSSFBorderFormatting.getBorderRight() |
BorderStyle |
HSSFCellStyle.getBorderTop() |
BorderStyle |
HSSFBorderFormatting.getBorderTop() |
BorderStyle |
HSSFBorderFormatting.getBorderVertical()
HSSF doesn't support table borders, so always
NONE |
| 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 |
BorderFormatting.getBorderDiagonal() |
BorderStyle |
BorderFormatting.getBorderHorizontal()
Only valid for range borders, such as table styles
|
BorderStyle |
CellStyle.getBorderLeft()
get the type of border to use for the left border of the cell
|
BorderStyle |
BorderFormatting.getBorderLeft() |
BorderStyle |
CellStyle.getBorderRight()
get the type of border to use for the right border of the cell
|
BorderStyle |
BorderFormatting.getBorderRight() |
BorderStyle |
CellStyle.getBorderTop()
get the type of border to use for the top border of the cell
|
BorderStyle |
BorderFormatting.getBorderTop() |
BorderStyle |
BorderFormatting.getBorderVertical()
Only valid for range borders, such as table styles
|
static BorderStyle |
BorderStyle.valueOf(short code) |
static BorderStyle |
BorderStyle.valueOf(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,
CellPropertyType property)
Retrieves the border style for a given cell
|
BorderStyle |
PropertyTemplate.getBorderStyle(CellAddress cell,
String propertyName)
Deprecated.
|
BorderStyle |
PropertyTemplate.getBorderStyle(int row,
int col,
CellPropertyType property)
Retrieves the border style for a given cell
|
BorderStyle |
PropertyTemplate.getBorderStyle(int row,
int col,
String propertyName)
Deprecated.
|
| 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
|