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 voidsetBorderBottom(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 voidsetBorderLeft(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 voidsetBorderRight(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 voidsetBorderTop(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 voidsetBottomBorderColor(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 voidsetLeftBorderColor(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 voidsetRightBorderColor(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 voidsetTopBorderColor(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
-