XSSFBorderFormatting (POI API Documentation)

java.lang.Object
- org.apache.poi.xssf.usermodel.XSSFBorderFormatting

All Implemented Interfaces:

BorderFormatting
```
public class XSSFBorderFormatting
extends java.lang.Object
implements BorderFormatting
```
XSSF high level representation for Border Formatting component of Conditional Formatting settings (条件格式设置的边框格式组件的 XSSF 高级表示)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`BorderStyle`	`getBorderBottom()`
`BorderStyle`	`getBorderDiagonal()`
`BorderStyle`	`getBorderHorizontal()` Only valid for range borders, such as table styles (仅对范围边框有效，例如表格样式)
`BorderStyle`	`getBorderLeft()`
`BorderStyle`	`getBorderRight()`
`BorderStyle`	`getBorderTop()`
`BorderStyle`	`getBorderVertical()` Only valid for range borders, such as table styles (仅对范围边框有效，例如表格样式)
`short`	`getBottomBorderColor()`
`XSSFColor`	`getBottomBorderColorColor()`
`short`	`getDiagonalBorderColor()`
`XSSFColor`	`getDiagonalBorderColorColor()`
`short`	`getHorizontalBorderColor()` Range internal borders. (范围内部边界。)
`XSSFColor`	`getHorizontalBorderColorColor()` Range internal borders. (范围内部边界。)
`short`	`getLeftBorderColor()`
`XSSFColor`	`getLeftBorderColorColor()`
`short`	`getRightBorderColor()`
`XSSFColor`	`getRightBorderColorColor()`
`short`	`getTopBorderColor()`
`XSSFColor`	`getTopBorderColorColor()`
`short`	`getVerticalBorderColor()` Range internal borders. (范围内部边界。)
`XSSFColor`	`getVerticalBorderColorColor()` Range internal borders. (范围内部边界。)
`void`	`setBorderBottom(BorderStyle border)` Set bottom border. (设置底部边框。)
`void`	`setBorderDiagonal(BorderStyle border)` Set diagonal border. (设置对角线边框。)
`void`	`setBorderHorizontal(BorderStyle border)` Set range internal horizontal borders. (设置范围内部水平边框。)
`void`	`setBorderLeft(BorderStyle border)` Set left border. (设置左边框。)
`void`	`setBorderRight(BorderStyle border)` Set right border. (设置右边框。)
`void`	`setBorderTop(BorderStyle border)` Set top border. (设置顶部边框。)
`void`	`setBorderVertical(BorderStyle border)` Set range internal vertical borders. (设置范围内部垂直边框。)
`void`	`setBottomBorderColor(Color color)`
`void`	`setBottomBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)`
`void`	`setBottomBorderColor(short color)`
`void`	`setDiagonalBorderColor(Color color)`
`void`	`setDiagonalBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)`
`void`	`setDiagonalBorderColor(short color)`
`void`	`setHorizontalBorderColor(Color color)` Range internal border color, such as table styles (范围内边框颜色，如表格样式)
`void`	`setHorizontalBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)`
`void`	`setHorizontalBorderColor(short color)` Range internal border color, such as table styles (范围内边框颜色，如表格样式)
`void`	`setLeftBorderColor(Color color)`
`void`	`setLeftBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)`
`void`	`setLeftBorderColor(short color)`
`void`	`setRightBorderColor(Color color)`
`void`	`setRightBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)`
`void`	`setRightBorderColor(short color)`
`void`	`setTopBorderColor(Color color)`
`void`	`setTopBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)`
`void`	`setTopBorderColor(short color)`
`void`	`setVerticalBorderColor(Color color)` Range internal border color, such as table styles (范围内边框颜色，如表格样式)
`void`	`setVerticalBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)`
`void`	`setVerticalBorderColor(short color)` Range internal border color, such as table styles (范围内边框颜色，如表格样式)

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Method Detail
  - getBorderBottom
```
public BorderStyle getBorderBottom()
```
    Specified by:
    
    getBorderBottom in interface BorderFormatting (接口 BorderFormatting 中的 getBorderBottom)
  - getBorderDiagonal
```
public BorderStyle getBorderDiagonal()
```
    Specified by:
    
    getBorderDiagonal in interface BorderFormatting (接口 BorderFormatting 中的 getBorderDiagonal)
  - getBorderLeft
```
public BorderStyle getBorderLeft()
```
    Specified by:
    
    getBorderLeft in interface BorderFormatting (接口 BorderFormatting 中的 getBorderLeft)
  - getBorderRight
```
public BorderStyle getBorderRight()
```
    Specified by:
    
    getBorderRight in interface BorderFormatting (接口 BorderFormatting 中的 getBorderRight)
  - getBorderTop
```
public BorderStyle getBorderTop()
```
    Specified by:
    
    getBorderTop in interface BorderFormatting (接口 BorderFormatting 中的 getBorderTop)
  - getBottomBorderColorColor
```
public XSSFColor getBottomBorderColorColor()
```
    Specified by:
    
    getBottomBorderColorColor in interface BorderFormatting (接口 BorderFormatting 中的 getBottomBorderColorColor)
  - getBottomBorderColor
```
public short getBottomBorderColor()
```
    Specified by:
    
    getBottomBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 getBottomBorderColor)
  - getDiagonalBorderColorColor
```
public XSSFColor getDiagonalBorderColorColor()
```
    Specified by:
    
    getDiagonalBorderColorColor in interface BorderFormatting (接口 BorderFormatting 中的 getDiagonalBorderColorColor)
  - getDiagonalBorderColor
```
public short getDiagonalBorderColor()
```
    Specified by:
    
    getDiagonalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 getDiagonalBorderColor)
  - getLeftBorderColorColor
```
public XSSFColor getLeftBorderColorColor()
```
    Specified by:
    
    getLeftBorderColorColor in interface BorderFormatting (接口 BorderFormatting 中的 getLeftBorderColorColor)
  - getLeftBorderColor
```
public short getLeftBorderColor()
```
    Specified by:
    
    getLeftBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 getLeftBorderColor)
  - getRightBorderColorColor
```
public XSSFColor getRightBorderColorColor()
```
    Specified by:
    
    getRightBorderColorColor in interface BorderFormatting (接口 BorderFormatting 中的 getRightBorderColorColor)
  - getRightBorderColor
```
public short getRightBorderColor()
```
    Specified by:
    
    getRightBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 getRightBorderColor)
  - getTopBorderColorColor
```
public XSSFColor getTopBorderColorColor()
```
    Specified by:
    
    getTopBorderColorColor in interface BorderFormatting (接口 BorderFormatting 中的 getTopBorderColorColor)
  - getTopBorderColor
```
public short getTopBorderColor()
```
    Specified by:
    
    getTopBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 getTopBorderColor)
  - setBorderBottom
```
public void setBorderBottom(BorderStyle border)
```
    Description copied from interface: BorderFormatting
    
    Set bottom border. (设置底部边框。)
    
    Specified by:
    
    setBorderBottom in interface BorderFormatting (接口 BorderFormatting 中的 setBorderBottom)
    
    Parameters:
    
    border - The style of border to set. (border - 要设置的边框样式。)
  - setBorderDiagonal
```
public void setBorderDiagonal(BorderStyle border)
```
    Description copied from interface: BorderFormatting
    
    Set diagonal border. (设置对角线边框。)
    
    Specified by:
    
    setBorderDiagonal in interface BorderFormatting (接口 BorderFormatting 中的 setBorderDiagonal)
    
    Parameters:
    
    border - The style of border to set. (border - 要设置的边框样式。)
  - setBorderLeft
```
public void setBorderLeft(BorderStyle border)
```
    Description copied from interface: BorderFormatting
    
    Set left border. (设置左边框。)
    
    Specified by:
    
    setBorderLeft in interface BorderFormatting (接口 BorderFormatting 中的 setBorderLeft)
    
    Parameters:
    
    border - The style of border to set. (border - 要设置的边框样式。)
  - setBorderRight
```
public void setBorderRight(BorderStyle border)
```
    Description copied from interface: BorderFormatting
    
    Set right border. (设置右边框。)
    
    Specified by:
    
    setBorderRight in interface BorderFormatting (接口 BorderFormatting 中的 setBorderRight)
    
    Parameters:
    
    border - The style of border to set. (border - 要设置的边框样式。)
  - setBorderTop
```
public void setBorderTop(BorderStyle border)
```
    Description copied from interface: BorderFormatting
    
    Set top border. (设置顶部边框。)
    
    Specified by:
    
    setBorderTop in interface BorderFormatting (接口 BorderFormatting 中的 setBorderTop)
    
    Parameters:
    
    border - The style of border to set. (border - 要设置的边框样式。)
  - setBottomBorderColor
```
public void setBottomBorderColor(Color color)
```
    Specified by:
    
    setBottomBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setBottomBorderColor)
  - setBottomBorderColor
```
public void setBottomBorderColor(short color)
```
    Specified by:
    
    setBottomBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setBottomBorderColor)
  - setBottomBorderColor
```
public void setBottomBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)
```
  - setDiagonalBorderColor
```
public void setDiagonalBorderColor(Color color)
```
    Specified by:
    
    setDiagonalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setDiagonalBorderColor)
  - setDiagonalBorderColor
```
public void setDiagonalBorderColor(short color)
```
    Specified by:
    
    setDiagonalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setDiagonalBorderColor)
  - setDiagonalBorderColor
```
public void setDiagonalBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)
```
  - setLeftBorderColor
```
public void setLeftBorderColor(Color color)
```
    Specified by:
    
    setLeftBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setLeftBorderColor)
  - setLeftBorderColor
```
public void setLeftBorderColor(short color)
```
    Specified by:
    
    setLeftBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setLeftBorderColor)
  - setLeftBorderColor
```
public void setLeftBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)
```
  - setRightBorderColor
```
public void setRightBorderColor(Color color)
```
    Specified by:
    
    setRightBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setRightBorderColor)
  - setRightBorderColor
```
public void setRightBorderColor(short color)
```
    Specified by:
    
    setRightBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setRightBorderColor)
  - setRightBorderColor
```
public void setRightBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)
```
  - setTopBorderColor
```
public void setTopBorderColor(Color color)
```
    Specified by:
    
    setTopBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setTopBorderColor)
  - setTopBorderColor
```
public void setTopBorderColor(short color)
```
    Specified by:
    
    setTopBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setTopBorderColor)
  - setTopBorderColor
```
public void setTopBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)
```
  - getBorderVertical
```
public BorderStyle getBorderVertical()
```
    Description copied from interface: BorderFormatting
    
    Only valid for range borders, such as table styles (仅对范围边框有效，例如表格样式)
    
    Specified by:
    
    getBorderVertical in interface BorderFormatting (接口 BorderFormatting 中的 getBorderVertical)
    
    Returns:
    
    border style (边框样式)
  - getBorderHorizontal
```
public BorderStyle getBorderHorizontal()
```
    Description copied from interface: BorderFormatting
    
    Only valid for range borders, such as table styles (仅对范围边框有效，例如表格样式)
    
    Specified by:
    
    getBorderHorizontal in interface BorderFormatting (接口 BorderFormatting 中的 getBorderHorizontal)
    
    Returns:
    
    border style (边框样式)
  - getVerticalBorderColor
```
public short getVerticalBorderColor()
```
    Description copied from interface: BorderFormatting
    
    Range internal borders. Only relevant for range styles, such as table formatting (范围内部边界。仅与范围样式相关，例如表格格式)
    
    Specified by:
    
    getVerticalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 getVerticalBorderColor)
    
    Returns:
    
    color index (颜色指数)
  - getVerticalBorderColorColor
```
public XSSFColor getVerticalBorderColorColor()
```
    Description copied from interface: BorderFormatting
    
    Range internal borders. Only relevant for range styles, such as table formatting (范围内部边界。仅与范围样式相关，例如表格格式)
    
    Specified by:
    
    getVerticalBorderColorColor in interface BorderFormatting (接口 BorderFormatting 中的 getVerticalBorderColorColor)
    
    Returns:
    
    color (颜色)
  - getHorizontalBorderColor
```
public short getHorizontalBorderColor()
```
    Description copied from interface: BorderFormatting
    
    Range internal borders. Only relevant for range styles, such as table formatting (范围内部边界。仅与范围样式相关，例如表格格式)
    
    Specified by:
    
    getHorizontalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 getHorizontalBorderColor)
    
    Returns:
    
    color index (颜色指数)
  - getHorizontalBorderColorColor
```
public XSSFColor getHorizontalBorderColorColor()
```
    Description copied from interface: BorderFormatting
    
    Range internal borders. Only relevant for range styles, such as table formatting (范围内部边界。仅与范围样式相关，例如表格格式)
    
    Specified by:
    
    getHorizontalBorderColorColor in interface BorderFormatting (接口 BorderFormatting 中的 getHorizontalBorderColorColor)
    
    Returns:
    
    color (颜色)
  - setBorderHorizontal
```
public void setBorderHorizontal(BorderStyle border)
```
    Description copied from interface: BorderFormatting
    
    Set range internal horizontal borders. (设置范围内部水平边框。)
    
    Specified by:
    
    setBorderHorizontal in interface BorderFormatting (接口 BorderFormatting 中的 setBorderHorizontal)
    
    Parameters:
    
    border - The style of border to set. (border - 要设置的边框样式。)
  - setBorderVertical
```
public void setBorderVertical(BorderStyle border)
```
    Description copied from interface: BorderFormatting
    
    Set range internal vertical borders. (设置范围内部垂直边框。)
    
    Specified by:
    
    setBorderVertical in interface BorderFormatting (接口 BorderFormatting 中的 setBorderVertical)
    
    Parameters:
    
    border - The style of border to set. (border - 要设置的边框样式。)
  - setHorizontalBorderColor
```
public void setHorizontalBorderColor(short color)
```
    Description copied from interface: BorderFormatting
    
    Range internal border color, such as table styles (范围内边框颜色，如表格样式)
    
    Specified by:
    
    setHorizontalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setHorizontalBorderColor)
    
    Parameters:
    
    color - index (颜色 - 索引)
  - setHorizontalBorderColor
```
public void setHorizontalBorderColor(Color color)
```
    Description copied from interface: BorderFormatting
    
    Range internal border color, such as table styles (范围内边框颜色，如表格样式)
    
    Specified by:
    
    setHorizontalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setHorizontalBorderColor)
    
    Parameters:
    
    color - index (颜色 - 索引)
  - setHorizontalBorderColor
```
public void setHorizontalBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)
```
  - setVerticalBorderColor
```
public void setVerticalBorderColor(short color)
```
    Description copied from interface: BorderFormatting
    
    Range internal border color, such as table styles (范围内边框颜色，如表格样式)
    
    Specified by:
    
    setVerticalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setVerticalBorderColor)
    
    Parameters:
    
    color - index (颜色 - 索引)
  - setVerticalBorderColor
```
public void setVerticalBorderColor(Color color)
```
    Description copied from interface: BorderFormatting
    
    Range internal border color, such as table styles (范围内边框颜色，如表格样式)
    
    Specified by:
    
    setVerticalBorderColor in interface BorderFormatting (接口 BorderFormatting 中的 setVerticalBorderColor)
    
    Parameters:
    
    color - index (颜色 - 索引)
  - setVerticalBorderColor
```
public void setVerticalBorderColor(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColor color)
```

Class XSSFBorderFormatting

Method Summary

Methods inherited from class java.lang.Object

Method Detail

getBorderBottom

getBorderDiagonal

getBorderLeft

getBorderRight

getBorderTop

getBottomBorderColorColor

getBottomBorderColor

getDiagonalBorderColorColor

getDiagonalBorderColor

getLeftBorderColorColor

getLeftBorderColor

getRightBorderColorColor

getRightBorderColor

getTopBorderColorColor

getTopBorderColor

setBorderBottom

setBorderDiagonal

setBorderLeft

setBorderRight

setBorderTop

setBottomBorderColor

setBottomBorderColor

setBottomBorderColor

setDiagonalBorderColor

setDiagonalBorderColor

setDiagonalBorderColor

setLeftBorderColor

setLeftBorderColor

setLeftBorderColor

setRightBorderColor

setRightBorderColor

setRightBorderColor

setTopBorderColor

setTopBorderColor

setTopBorderColor

getBorderVertical

getBorderHorizontal

getVerticalBorderColor

getVerticalBorderColorColor

getHorizontalBorderColor

getHorizontalBorderColorColor

setBorderHorizontal

setBorderVertical

setHorizontalBorderColor

setHorizontalBorderColor

setHorizontalBorderColor

setVerticalBorderColor

setVerticalBorderColor

setVerticalBorderColor