Class Banding

Class Banding

Access and modify bandings, the color patterns applied to rows or columns of a range. Each banding consists of a range and a set of colors for rows, columns, headers, and footers.

Methods

Method	Return type	Brief description
`copyTo(range)`	`Banding`	Copies this banding to another range.
`getFirstColumnColor()`	`String`	Returns the first column color that is alternating, or `null` if no color is set.
`getFirstRowColor()`	`String`	Returns the first row color that is alternating or `null` if no color is set.
`getFooterColumnColor()`	`String`	Returns the color of the last column, or `null` if no color is set.
`getFooterRowColor()`	`String`	Returns the color of the last row, or `null` if no color is set.
`getHeaderColumnColor()`	`String`	Returns the color of the header column, or `null` if no color is set.
`getHeaderRowColor()`	`String`	Returns the color of the header row or `null` if no color is set.
`getRange()`	`Range`	Returns the range for this banding.
`getSecondColumnColor()`	`String`	Returns the second column color that is alternating, or `null` if no color is set.
`getSecondRowColor()`	`String`	Returns the second row color that is alternating or `null` if no color is set.
`remove()`	`void`	Removes this banding.
`setFirstColumnColor(color)`	`Banding`	Sets the first column color that is alternating.
`setFirstRowColor(color)`	`Banding`	Sets the first row color that is alternating.
`setFooterColumnColor(color)`	`Banding`	Sets the color of the last column.
`setFooterRowColor(color)`	`Banding`	Sets the color of the last row.
`setHeaderColumnColor(color)`	`Banding`	Sets the color of the header column.
`setHeaderRowColor(color)`	`Banding`	Sets the color of the header row.
`setRange(range)`	`Banding`	Sets the range for this banding.
`setSecondColumnColor(color)`	`Banding`	Sets the second column color that is alternating.
`setSecondRowColor(color)`	`Banding`	Sets the second row color that is alternating.

Detailed documentation

`copyTo(range)`

Copies this banding to another range.

Parameters

Name	Type	Description
`range`	`Range`	The range to copy this banding to.

Return

Banding — the new banding

`getFirstColumnColor()`

Returns the first column color that is alternating, or null if no color is set.

Return

String — the color code in CSS notation (such as '#ffffff' or 'white'), or null if no color is set

`getFirstRowColor()`

Returns the first row color that is alternating or null if no color is set.

Return

String — the color code in CSS notation (such as '#ffffff' or 'white'), or null if no color is set

`getFooterColumnColor()`

Returns the color of the last column, or null if no color is set.

Return

String — the color code in CSS notation (such as '#ffffff' or 'white'), or null if no color is set

`getFooterRowColor()`

Returns the color of the last row, or null if no color is set.

Return

String — the color code in CSS notation (such as '#ffffff' or 'white'), or null if no color is set

`getHeaderColumnColor()`

Returns the color of the header column, or null if no color is set.

Return

String — the color code in CSS notation (such as '#ffffff' or 'white'), or null if no color is set

`getHeaderRowColor()`

Returns the color of the header row or null if no color is set.

Return

String — the color code in CSS notation (such as '#ffffff' or 'white'), or null if no color is set

`getRange()`

Returns the range for this banding.

Return

Range — the range for this banding

`getSecondColumnColor()`

Returns the second column color that is alternating, or null if no color is set.

Return

String — the HEX color or null if no color is set

`getSecondRowColor()`

Returns the second row color that is alternating or null if no color is set.

Return

String — the color code in CSS notation (such as '#ffffff' or 'white'), or null if no color is set

`remove()`

Removes this banding.

`setFirstColumnColor(color)`

Sets the first column color that is alternating.