Package org.apache.poi.ss.util
Class RegionUtil
java.lang.Object
org.apache.poi.ss.util.RegionUtil
Various utility functions that make working with a region of cells easier.
-
Method Summary
Modifier and TypeMethodDescriptionstatic void
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 bottomstatic void
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 leftstatic void
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 rightstatic void
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 topstatic void
setBottomBorderColor
(int color, CellRangeAddress region, Sheet sheet) Sets the bottom border color for a region of cells by manipulating the cell style of the individual cells on the bottomstatic void
setLeftBorderColor
(int color, CellRangeAddress region, Sheet sheet) Sets the left border color for a region of cells by manipulating the cell style of the individual cells on the leftstatic void
setRightBorderColor
(int color, CellRangeAddress region, Sheet sheet) Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the rightstatic void
setTopBorderColor
(int color, CellRangeAddress region, Sheet sheet) Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top
-
Method Details
-
setBorderLeft
Sets the left border style for a region of cells by manipulating the cell style of the individual cells on the left- Parameters:
border
- The new borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.16 beta 1
-
setLeftBorderColor
Sets the left border color for a region of cells by manipulating the cell style of the individual cells on the left- Parameters:
color
- The color of the borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.15 beta 2
-
setBorderRight
Sets the right border style for a region of cells by manipulating the cell style of the individual cells on the right- Parameters:
border
- The new borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.16 beta 1
-
setRightBorderColor
Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the right- Parameters:
color
- The color of the borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.15 beta 2
-
setBorderBottom
Sets the bottom border style for a region of cells by manipulating the cell style of the individual cells on the bottom- Parameters:
border
- The new borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.16 beta 1
-
setBottomBorderColor
Sets the bottom border color for a region of cells by manipulating the cell style of the individual cells on the bottom- Parameters:
color
- The color of the borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.15 beta 2
-
setBorderTop
Sets the top border style for a region of cells by manipulating the cell style of the individual cells on the top- Parameters:
border
- The new borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.16 beta 1
-
setTopBorderColor
Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top- Parameters:
color
- The color of the borderregion
- The region that should have the bordersheet
- The sheet that the region is on.- Since:
- POI 3.15 beta 2
-