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 | |---|---|---| | `https://developers.google.com/apps-script/reference/spreadsheet/banding#copyTo(Range)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Copies this banding to another range. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFirstColumnColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the first alternating column color in the banding, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFirstRowColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the first alternating row color, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFooterColumnColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the color of the last column in the banding, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFooterRowColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the last row color in the banding, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getHeaderColumnColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the color of the first column in the banding, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getHeaderRowColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the color of the header row or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getRange()` | `https://developers.google.com/apps-script/reference/spreadsheet/range` | Returns the range for this banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getSecondColumnColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the second alternating column color in the banding, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getSecondRowColorObject()` | `https://developers.google.com/apps-script/reference/spreadsheet/color|null` | Returns the second alternating row color, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#remove()` | `void` | Removes this banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFirstColumnColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the first column color that is alternating. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFirstColumnColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the first alternating column color in the banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFirstRowColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the first row color that is alternating. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFirstRowColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the first alternating row color in the banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFooterColumnColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the last column. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFooterColumnColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the last column in the banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFooterRowColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the last row. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setFooterRowColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the footer row in the banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setHeaderColumnColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the header column. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setHeaderColumnColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the header column. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setHeaderRowColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the header row. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setHeaderRowColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the color of the header row. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setRange(Range)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the range for this banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setSecondColumnColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the second column color that is alternating. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setSecondColumnColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the second alternating column color in the banding. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setSecondRowColor(String)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the second row color that is alternating. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#setSecondRowColorObject(Color)` | `https://developers.google.com/apps-script/reference/spreadsheet/banding#` | Sets the second alternating color in the banding. | ### Deprecated methods | Method | Return type | Brief description | |---|---|---| | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFirstColumnColor()` | `String|null` | Returns the first column color that is alternating, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFirstRowColor()` | `String|null` | Returns the first row color that is alternating or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFooterColumnColor()` | `String|null` | Returns the color of the last column, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFooterRowColor()` | `String|null` | Returns the color of the last row, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getHeaderColumnColor()` | `String|null` | Returns the color of the header column, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getHeaderRowColor()` | `String|null` | Returns the color of the header row or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getSecondColumnColor()` | `String|null` | Returns the second column color that is alternating, or `null` if no color is set. | | `https://developers.google.com/apps-script/reference/spreadsheet/banding#getSecondRowColor()` | `String|null` | 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` | `https://developers.google.com/apps-script/reference/spreadsheet/range` | The range to copy this banding to. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- The new banding. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getRange()` Returns the range for this banding. #### Return `https://developers.google.com/apps-script/reference/spreadsheet/range` --- The range for this banding. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/color|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new first alternating column color in the banding; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new first alternating color in the banding; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new color of the last column in the banding; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new footer row color; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new header column color; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new header row color; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/range` | The new range for this banding. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new second alternating column color in the banding; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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 `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_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` | `https://developers.google.com/apps-script/reference/spreadsheet/color` | The new second alternating color in the banding; setting to `null` clears the color. | #### Return `https://developers.google.com/apps-script/reference/spreadsheet/banding#` --- This banding, for chaining. #### Authorization Scripts that use this method require authorization with one or more of the following [scopes](https://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` ## Deprecated methods ### `getFirstColumnColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFirstColumnColorObject()` Returns the first column color that is alternating, or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getFirstRowColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFirstRowColorObject()` Returns the first row color that is alternating or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getFooterColumnColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFooterColumnColorObject()` Returns the color of the last column, or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getFooterRowColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getFooterRowColorObject()` Returns the color of the last row, or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getHeaderColumnColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getHeaderColumnColorObject()` Returns the color of the header column, or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getHeaderRowColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getHeaderRowColorObject()` Returns the color of the header row or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getSecondColumnColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getSecondColumnColorObject()` Returns the second column color that is alternating, or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets` *** ** * ** *** ### `getSecondRowColor()` **Deprecated.** Replaced by `https://developers.google.com/apps-script/reference/spreadsheet/banding#getSecondRowColorObject()` Returns the second row color that is alternating or `null` if no color is set. #### Return `String|null` --- 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://developers.google.com/apps-script/concepts/scopes#setting_explicit_scopes): - `https://www.googleapis.com/auth/spreadsheets.currentonly` - `https://www.googleapis.com/auth/spreadsheets`