org.apache.poi.xssf.usermodel.extensions

Class XSSFCellBorder

java.lang.Object

org.apache.poi.xssf.usermodel.extensions.XSSFCellBorder

public class XSSFCellBorder
extends java.lang.Object

This element contains border formatting information, specifying border definition formats (left, right, top, bottom, diagonal) for cells in the workbook. Color is optional. (此元素包含边框格式信息，为工作簿中的单元格指定边框定义格式（左、右、上、下、对角线）。颜色是可选的。)

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	XSSFCellBorder.BorderSide The enumeration value indicating the side being used for a cell border. (指示用于单元格边框的边的枚举值。)

Constructor Summary

Constructors

Constructor and Description
XSSFCellBorder() Creates a new, empty Cell Border.
XSSFCellBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder border) Creates a Cell Border from the supplied XML definition
XSSFCellBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder border, IndexedColorMap colorMap)
XSSFCellBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder border, ThemesTable theme, IndexedColorMap colorMap) Creates a Cell Border from the supplied XML definition

Method Summary

Modifier and Type	Method and Description
boolean	equals(java.lang.Object o)
XSSFColor	getBorderColor(XSSFCellBorder.BorderSide side) Get the color to use for the selected border (获取用于选定边框的颜色)
BorderStyle	getBorderStyle(XSSFCellBorder.BorderSide side) Get the type of border to use for the selected border (获取用于选定边框的边框类型)
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder	getCTBorder() Returns the underlying XML bean. (返回底层 XML bean。)
int	hashCode()
void	setBorderColor(XSSFCellBorder.BorderSide side, XSSFColor color) Set the color to use for the selected border (设置用于选定边框的颜色)
void	setBorderStyle(XSSFCellBorder.BorderSide side, BorderStyle style) Set the type of border to use for the selected border (设置用于选定边框的边框类型)
void	setThemesTable(ThemesTable themes) Records the Themes Table that is associated with the current font, used when looking up theme based colours and properties. (记录与当前字体关联的主题表，在查找基于主题的颜色和属性时使用。)

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

XSSFCellBorder

public XSSFCellBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder border,
                      ThemesTable theme,
                      IndexedColorMap colorMap)

Creates a Cell Border from the supplied XML definition (根据提供的 XML 定义创建单元格边框)

Parameters:

border - The ooxml object for the border (边框 - 边框的 ooxml 对象)

theme - The related themes (主题 - 相关主题)

colorMap - The global map of colors (colorMap - 颜色的全球地图)

XSSFCellBorder

public XSSFCellBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder border)

Creates a Cell Border from the supplied XML definition (根据提供的 XML 定义创建单元格边框)

Parameters:

border - The ooxml object for the border (边框 - 边框的 ooxml 对象)

XSSFCellBorder

public XSSFCellBorder(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder border,
                      IndexedColorMap colorMap)

Parameters:

border - The ooxml object for the border (边框 - 边框的 ooxml 对象)

colorMap - The global map of colors (colorMap - 颜色的全球地图)

XSSFCellBorder

public XSSFCellBorder()

Creates a new, empty Cell Border. You need to attach this to the Styles Table (创建一个新的空单元格边框。您需要将此附加到样式表)

Method Detail

setThemesTable

public void setThemesTable(ThemesTable themes)

Records the Themes Table that is associated with the current font, used when looking up theme based colours and properties. (记录与当前字体关联的主题表，在查找基于主题的颜色和属性时使用。)

getCTBorder

@Internal
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTBorder getCTBorder()

Returns the underlying XML bean. (返回底层 XML bean。)

Returns:

CTBorder (CTB订单)

getBorderStyle

public BorderStyle getBorderStyle(XSSFCellBorder.BorderSide side)

Get the type of border to use for the selected border (获取用于选定边框的边框类型)

Parameters:

side - - - where to apply the color definition (side - - - 应用颜色定义的位置)

Returns:

borderstyle - the type of border to use. default value is NONE if border style is not set. (borderstyle - 要使用的边框类型。如果未设置边框样式，则默认值为 NONE。)

See Also:

BorderStyle

setBorderStyle

public void setBorderStyle(XSSFCellBorder.BorderSide side,
                           BorderStyle style)

Set the type of border to use for the selected border (设置用于选定边框的边框类型)

Parameters:

side - - - where to apply the color definition (side - - - 应用颜色定义的位置)

style - - border style (style - - 边框样式)

See Also:

BorderStyle

getBorderColor

public XSSFColor getBorderColor(XSSFCellBorder.BorderSide side)

Get the color to use for the selected border (获取用于选定边框的颜色)

Parameters:

side - - where to apply the color definition (side - - 应用颜色定义的位置)

Returns:

color - color to use as XSSFColor. null if color is not set (color - 用作 XSSFColor 的颜色。如果未设置颜色，则为 null)

setBorderColor

public void setBorderColor(XSSFCellBorder.BorderSide side,
                           XSSFColor color)

Set the color to use for the selected border (设置用于选定边框的颜色)

Parameters:

side - - where to apply the color definition (side - - 应用颜色定义的位置)

color - - the color to use (color - - 要使用的颜色)

hashCode

public int hashCode()

Overrides:

hashCode in class java.lang.Object

equals

public boolean equals(java.lang.Object o)

Overrides:

equals in class java.lang.Object