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.
`getFirstColumnColorObject()`	`Color`	Returns the first alternating column color in the banding, or `null` if no color is set.
`getFirstRowColorObject()`	`Color`	Returns the first alternating row color, or `null` if no color is set.
`getFooterColumnColorObject()`	`Color`	Returns the color of the last column in the banding, or `null` if no color is set.
`getFooterRowColorObject()`	`Color`	Returns the last row color in the banding, or `null` if no color is set.
`getHeaderColumnColorObject()`	`Color`	Returns the color of the first column in the banding, or `null` if no color is set.
`getHeaderRowColorObject()`	`Color`	Returns the color of the header row or `null` if no color is set.
`getRange()`	`Range`	Returns the range for this banding.
`getSecondColumnColorObject()`	`Color`	Returns the second alternating column color in the banding, or `null` if no color is set.
`getSecondRowColorObject()`	`Color`	Returns the second alternating row color, or `null` if no color is set.
`remove()`	`void`	Removes this banding.
`setFirstColumnColor(color)`	`Banding`	Sets the first column color that is alternating.
`setFirstColumnColorObject(color)`	`Banding`	Sets the first alternating column color in the banding.
`setFirstRowColor(color)`	`Banding`	Sets the first row color that is alternating.
`setFirstRowColorObject(color)`	`Banding`	Sets the first alternating row color in the banding.
`setFooterColumnColor(color)`	`Banding`	Sets the color of the last column.
`setFooterColumnColorObject(color)`	`Banding`	Sets the color of the last column in the banding.
`setFooterRowColor(color)`	`Banding`	Sets the color of the last row.
`setFooterRowColorObject(color)`	`Banding`	Sets the color of the footer row in the banding.
`setHeaderColumnColor(color)`	`Banding`	Sets the color of the header column.
`setHeaderColumnColorObject(color)`	`Banding`	Sets the color of the header column.
`setHeaderRowColor(color)`	`Banding`	Sets the color of the header row.
`setHeaderRowColorObject(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.
`setSecondColumnColorObject(color)`	`Banding`	Sets the second alternating column color in the banding.
`setSecondRowColor(color)`	`Banding`	Sets the second row color that is alternating.
`setSecondRowColorObject(color)`	`Banding`	Sets the second alternating color in the banding.

Deprecated methods

Method	Return type	Brief description
`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.
`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.

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getFirstColumnColorObject()`

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

Return

Color — The first alternating column color in the banding, or null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getFirstRowColorObject()`

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

Return

Color — The first alternating row color in the banding, or null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getFooterColumnColorObject()`

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

Return

Color — The last column color in the banding, or null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getFooterRowColorObject()`

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

Return

Color — The footer row color in the banding, or null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getHeaderColumnColorObject()`

Returns the color of the first column in the banding, or null if no color is set.

Return

Color — The first column color in the banding, or null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getHeaderRowColorObject()`

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

Return

Color — The color of the header row; returns null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getRange()`

Returns the range for this banding.

Return

Range — The range for this banding.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getSecondColumnColorObject()`

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

Return

Color — The second alternating column color in the banding, or null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getSecondRowColorObject()`

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

Return

Color — The second alternating row color in the banding, or null if no color is set.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`remove()`

Removes this banding.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFirstColumnColor(color)`

Sets the first column color that is alternating.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFirstColumnColorObject(color)`

Sets the first alternating column color in the banding.

Parameters

Name	Type	Description
`color`	`Color`	The new first alternating column color in the banding; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFirstRowColor(color)`

Sets the first row color that is alternating.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFirstRowColorObject(color)`

Sets the first alternating row color in the banding.

Parameters

Name	Type	Description
`color`	`Color`	The new first alternating color in the banding; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFooterColumnColor(color)`

Sets the color of the last column.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFooterColumnColorObject(color)`

Sets the color of the last column in the banding.

Parameters

Name	Type	Description
`color`	`Color`	The new color of the last column in the banding; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFooterRowColor(color)`

Sets the color of the last row.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setFooterRowColorObject(color)`

Sets the color of the footer row in the banding.

Parameters

Name	Type	Description
`color`	`Color`	The new footer row color; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setHeaderColumnColor(color)`

Sets the color of the header column.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setHeaderColumnColorObject(color)`

Sets the color of the header column.

Parameters

Name	Type	Description
`color`	`Color`	The new header column color; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setHeaderRowColor(color)`

Sets the color of the header row.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setHeaderRowColorObject(color)`

Sets the color of the header row.

Parameters

Name	Type	Description
`color`	`Color`	The new header row color; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setRange(range)`

Sets the range for this banding.

Parameters

Name	Type	Description
`range`	`Range`	The new range for this banding.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setSecondColumnColor(color)`

Sets the second column color that is alternating.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setSecondColumnColorObject(color)`

Sets the second alternating column color in the banding.

Parameters

Name	Type	Description
`color`	`Color`	The new second alternating column color in the banding; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setSecondRowColor(color)`

Sets the second row color that is alternating.

Parameters

Name	Type	Description
`color`	`String`	The color code in CSS notation (such as `'#ffffff'` or `'white'`), or `null` to clear the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`setSecondRowColorObject(color)`

Sets the second alternating color in the banding.

Parameters

Name	Type	Description
`color`	`Color`	The new second alternating color in the banding; setting to `null` clears the color.

Return

Banding — This banding, for chaining.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

Deprecated methods

`getFirstColumnColor()`

Deprecated. Replaced by getFirstColumnColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getFirstRowColor()`

Deprecated. Replaced by getFirstRowColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getFooterColumnColor()`

Deprecated. Replaced by getFooterColumnColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getFooterRowColor()`

Deprecated. Replaced by getFooterRowColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getHeaderColumnColor()`

Deprecated. Replaced by getHeaderColumnColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getHeaderRowColor()`

Deprecated. Replaced by getHeaderRowColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getSecondColumnColor()`

Deprecated. Replaced by getSecondColumnColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets

`getSecondRowColor()`

Deprecated. Replaced by getSecondRowColorObject()

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.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/spreadsheets.currentonly
https://www.googleapis.com/auth/spreadsheets