Modifier and Type	Class and Description
private static class	RegionUtil.CellPropertySetter For setting the same property on many cells to the same value

Access	Constructor and Description
private	RegionUtil()

Method Summary

Modifier and Type	Method and Description
public static void	setBorderBottom(BorderStyle The new border border, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the bottom border style for a region of cells by manipulating the cell style of the individual cells on the bottom
public static void	setBorderLeft(BorderStyle The new border border, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the left border style for a region of cells by manipulating the cell style of the individual cells on the left
public static void	setBorderRight(BorderStyle The new border border, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the right border style for a region of cells by manipulating the cell style of the individual cells on the right
public static void	setBorderTop(BorderStyle The new border border, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the top border style for a region of cells by manipulating the cell style of the individual cells on the top
public static void	setBottomBorderColor(int The color of the border color, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the bottom border color for a region of cells by manipulating the cell style of the individual cells on the bottom
public static void	setLeftBorderColor(int The color of the border color, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the left border color for a region of cells by manipulating the cell style of the individual cells on the left
public static void	setRightBorderColor(int The color of the border color, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the right border color for a region of cells by manipulating the cell style of the individual cells on the right
public static void	setTopBorderColor(int The color of the border color, CellRangeAddress The region that should have the border region, Sheet The sheet that the region is on. sheet) Sets the top border color for a region of cells by manipulating the cell style of the individual cells on the top

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Constructor Detail

RegionUtil	back to summary
private RegionUtil()

Method Detail

setBorderBottom	back to summary
public static 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 bottom Parameters border:BorderStyle The new border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.16 beta 1

setBorderBottom

back to summary

public static 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 bottom

Parameters

border:BorderStyle: The new border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.16 beta 1

setBorderLeft	back to summary
public static 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 left Parameters border:BorderStyle The new border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.16 beta 1

setBorderLeft

back to summary

public static 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 left

Parameters

border:BorderStyle: The new border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.16 beta 1

setBorderRight	back to summary
public static 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 right Parameters border:BorderStyle The new border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.16 beta 1

setBorderRight

back to summary

public static 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 right

Parameters

border:BorderStyle: The new border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.16 beta 1

setBorderTop	back to summary
public static 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 top Parameters border:BorderStyle The new border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.16 beta 1

setBorderTop

back to summary

public static 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 top

Parameters

border:BorderStyle: The new border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.16 beta 1

setBottomBorderColor	back to summary
public static 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 bottom Parameters color:int The color of the border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.15 beta 2

setBottomBorderColor

back to summary

public static 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 bottom

Parameters

color:int: The color of the border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.15 beta 2

setLeftBorderColor	back to summary
public static 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 left Parameters color:int The color of the border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.15 beta 2

setLeftBorderColor

back to summary

public static 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 left

Parameters

color:int: The color of the border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.15 beta 2

setRightBorderColor	back to summary
public static 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 right Parameters color:int The color of the border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.15 beta 2

setRightBorderColor

back to summary

public static 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 right

Parameters

color:int: The color of the border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.15 beta 2

setTopBorderColor	back to summary
public static 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 Parameters color:int The color of the border region:CellRangeAddress The region that should have the border sheet:Sheet The sheet that the region is on. Since POI 3.15 beta 2

setTopBorderColor

back to summary

public static 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

Parameters

color:int: The color of the border
region:CellRangeAddress: The region that should have the border
sheet:Sheet: The sheet that the region is on.

Since

POI 3.15 beta 2

org.apache.poi.ss.util back to summary

private final Class RegionUtil.CellPropertySetter

Class Inheritance

extends Object

java.lang.Object
org.apache.poi.ss.util.RegionUtil.CellPropertySetter

For setting the same property on many cells to the same value

Field Summary

Modifier and Type	Field and Description
private final String	_propertyName
private final Object	_propertyValue

Constructor Summary

Access	Constructor and Description
public	CellPropertySetter(String propertyName, int value)
public	CellPropertySetter(String propertyName, BorderStyle value)

Method Summary

Modifier and Type	Method and Description
public void	setProperty(Row row, int column)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

_propertyName	back to summary
private final String _propertyName

_propertyValue	back to summary
private final Object _propertyValue

Constructor Detail

CellPropertySetter	back to summary
public CellPropertySetter(String propertyName, int value)

CellPropertySetter	back to summary
public CellPropertySetter(String propertyName, BorderStyle value)

Method Detail

setProperty	back to summary
public void setProperty(Row row, int column)

public final Class RegionUtil

Nested and Inner Type Summary

Constructor Summary

Method Summary

Constructor Detail

Method Detail

private final Class RegionUtil.CellPropertySetter

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail