| java.lang.Object org.apache.poi.hssf.usermodel.contrib.HSSFRegionUtil
HSSFRegionUtil | public class HSSFRegionUtil (Code) | | Various utility functions that make working with a region of cells easier.
author: Eric Pugh epugh@upstate.com since: July 29, 2002 |
Method Summary | |
public static void | setBorderBottom(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) | public static void | setBorderLeft(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) | public static void | setBorderRight(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) | public static void | setBorderTop(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) | public static void | setBottomBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) | public static void | setLeftBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) | public static void | setRightBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) | public static void | setTopBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) |
setBorderBottom | public static void setBorderBottom(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the borderBottom attribute of the HSSFRegionUtil object
Parameters: border - The new border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changed |
setBorderLeft | public static void setBorderLeft(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the left border for a region of cells by manipulating the cell style
of the indidual cells on the left
Parameters: border - The new border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changed |
setBorderRight | public static void setBorderRight(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the borderRight attribute of the HSSFRegionUtil object
Parameters: border - The new border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changed |
setBorderTop | public static void setBorderTop(short border, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the borderBottom attribute of the HSSFRegionUtil object
Parameters: border - The new border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changed |
setBottomBorderColor | public static void setBottomBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the bottomBorderColor attribute of the HSSFRegionUtil object
Parameters: color - The color of the border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changedproperly. |
setLeftBorderColor | public static void setLeftBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the leftBorderColor attribute of the HSSFRegionUtil object
Parameters: color - The color of the border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changedproperly. |
setRightBorderColor | public static void setRightBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the rightBorderColor attribute of the HSSFRegionUtil object
Parameters: color - The color of the border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changedproperly. |
setTopBorderColor | public static void setTopBorderColor(short color, Region region, HSSFSheet sheet, HSSFWorkbook workbook) throws NestableException(Code) | | Sets the topBorderColor attribute of the HSSFRegionUtil object
Parameters: color - The color of the border Parameters: region - The region that should have the border Parameters: workbook - The workbook that the region is on. Parameters: sheet - The sheet that the region is on. exception: NestableException - Thrown if the CellStyle can't be changedproperly. |
|
|