This service allows scripts to create, access, and modify Google Sheets files. See also the guide to storing data in spreadsheets.
Sometimes, spreadsheet operations are bundled together to improve performance, such as when
doing multiple calls to a method. If you want to make sure that all pending
changes are made right away, for instance to show users information as a script is executing,
call Spreadsheet
.
Classes
Name | Brief description |
---|---|
Auto | An enumeration of the types of series used to calculate auto-filled values. |
Banding | Access and modify bandings, the color patterns applied to rows or columns of a range. |
Banding | An enumeration of banding themes. |
Big | Access the existing BigQuery data source specification. |
Big | The builder for Big . |
Boolean | Access boolean conditions in Conditional . |
Boolean | An enumeration representing the boolean criteria that can be used in conditional format or filter. |
Border | Styles that can be set on a range using Range.setBorder(top, left, bottom, right, vertical, horizontal, color, style) . |
Cell | Represents an image value in a cell. |
Cell | Builder for Cell . |
Color | A representation for a color. |
Color | The builder for Color . |
Conditional | Access conditional formatting rules. |
Conditional | Builder for conditional format rules. |
Container | Access the chart's position within a sheet. |
Copy | An enumeration of possible special paste types. |
Data | An enumeration of data execution error codes. |
Data | An enumeration of data execution states. |
Data | The data execution status. |
Data | Access and modify existing data source. |
Data | Access and modify an existing data source chart. |
Data | Access and modify a data source column. |
Data | Access and modify existing data source formulas. |
Data | Access existing data source parameters. |
Data | An enumeration of data source parameter types. |
Data | Access and modify existing data source pivot table. |
Data | Access and modify an existing refresh schedule. |
Data | Access a refresh schedule's frequency, which specifies how often and when to refresh. |
Data | An enumeration of scopes for refreshes. |
Data | Access and modify existing data source sheet. |
Data | Access and modify an existing data source sheet filter. |
Data | Access the general settings of an existing data source spec. |
Data | The builder for Data . |
Data | Access and modify existing data source table. |
Data | Access and modify an existing column in a Data . |
Data | Access and modify an existing data source table filter. |
Data | An enumeration of data source types. |
Data | Access data validation rules. |
Data | Builder for data validation rules. |
Data | An enumeration representing the data validation criteria that can be set on a range. |
Date | Access an existing date-time grouping rule. |
Date | The types of date-time grouping rule. |
Developer | Access and modify developer metadata. |
Developer | Search for developer metadata in a spreadsheet. |
Developer | Access developer metadata location information. |
Developer | An enumeration of the types of developer metadata location types. |
Developer | An enumeration of the types of developer metadata visibility. |
Dimension | An enumeration of possible directions along which data can be stored in a spreadsheet. |
Direction | An enumeration representing the possible directions that one can move within a spreadsheet using the arrow keys. |
Drawing | Represents a drawing over a sheet in a spreadsheet. |
Embedded | Builder for area charts. |
Embedded | Builder for bar charts. |
Embedded | Represents a chart that has been embedded into a spreadsheet. |
Embedded | Builder used to edit an Embedded . |
Embedded | Builder for column charts. |
Embedded | Builder for combo charts. |
Embedded | Builder for histogram charts. |
Embedded | Builder for line charts. |
Embedded | Builder for pie charts. |
Embedded | Builder for scatter charts. |
Embedded | Builder for table charts. |
Filter | Use this class to modify existing filters on Grid sheets, the default type of
sheet. |
Filter | Use this class to get information about or copy the criteria on existing filters. |
Filter | Builder for filter criteria. |
Frequency | An enumeration of frequency types. |
Gradient | Access gradient (color) conditions in Conditional . |
Group | Access and modify spreadsheet groups. |
Group | An enumeration representing the possible positions that a group control toggle can have. |
Interpolation | An enumeration representing the interpolation options for calculating a value to be used in a
Gradient in a Conditional . |
Looker | A Data which is used to access specifically the existing Looker data source
specifications. |
Looker | The builder for Looker . |
Named | Create, access and modify named ranges in a spreadsheet. |
Over | Represents an image over the grid in a spreadsheet. |
| Access and modify protected sheets in the older version of Google Sheets. |
Pivot | Access and modify pivot table filters. |
Pivot | Access and modify pivot table breakout groups. |
Pivot | Access and modify pivot table group limit. |
Pivot | Access and modify pivot tables. |
Pivot | An enumeration of functions that summarize pivot table data. |
Pivot | Access and modify value groups in pivot tables. |
Pivot | An enumeration of ways to display a pivot value as a function of another value. |
Protection | Access and modify protected ranges and sheets. |
Protection | An enumeration representing the parts of a spreadsheet that can be protected from edits. |
Range | Access and modify spreadsheet ranges. |
Range | A collection of one or more Range instances in the same sheet. |
Recalculation | An enumeration representing the possible intervals used in spreadsheet recalculation. |
Relative | An enumeration representing the relative date options for calculating a value to be used in
date-based Boolean . |
Rich | A stylized text string used to represent cell text. |
Rich | A builder for Rich Text values. |
Selection | Access the current active selection in the active sheet. |
Sheet | Access and modify spreadsheet sheets. |
Sheet | The different types of sheets that can exist in a spreadsheet. |
Slicer | Represents a slicer, which is used to filter ranges, charts and pivot tables in a non-collaborative manner. |
Sort | An enumeration representing the sort order. |
Sort | The sorting specification. |
Spreadsheet | Access and modify Google Sheets files. |
Spreadsheet | Access and create Google Sheets files. |
Spreadsheet | Access and modify existing themes. |
Text | An enumerations of text directions. |
Text | Find or replace text within a range, sheet or spreadsheet. |
Text | Access the text rotation settings for a cell. |
Text | The rendered style of text in a cell. |
Text | A builder for text styles. |
Text | An enumeration of the types of preset delimiters that can split a column of text into multiple columns. |
Theme | A representation for a theme color. |
Theme | An enum which describes various color entries supported in themes. |
Value | An enumeration of value types returned by Range.getValue() and Range.getValues() from the Range class of the Spreadsheet service. |
Wrap | An enumeration of the strategies used to handle cell text wrapping. |
AutoFillSeries
Properties
Property | Type | Description |
---|---|---|
DEFAULT_SERIES | Enum | Default. |
ALTERNATE_SERIES | Enum | Auto-filling with this setting results in the empty cells in the expanded range being filled with copies of the existing values. |
Banding
Methods
Method | Return type | Brief description |
---|---|---|
copy | Banding | Copies this banding to another range. |
get | Color | Returns the first alternating column color in the banding, or null if no color is set. |
get | Color | Returns the first alternating row color, or null if no color is set. |
get | Color | Returns the color of the last column in the banding, or null if no color is set. |
get | Color | Returns the last row color in the banding, or null if no color is set. |
get | Color | Returns the color of the first column in the banding, or null if no color is set. |
get | Color | Returns the color of the header row or null if no color is set. |
get | Range | Returns the range for this banding. |
get | Color | Returns the second alternating column color in the banding, or null if no color is set. |
get | Color | Returns the second alternating row color, or null if no color is set. |
remove() | void | Removes this banding. |
set | Banding | Sets the first column color that is alternating. |
set | Banding | Sets the first alternating column color in the banding. |
set | Banding | Sets the first row color that is alternating. |
set | Banding | Sets the first alternating row color in the banding. |
set | Banding | Sets the color of the last column. |
set | Banding | Sets the color of the last column in the banding. |
set | Banding | Sets the color of the last row. |
set | Banding | Sets the color of the footer row in the banding. |
set | Banding | Sets the color of the header column. |
set | Banding | Sets the color of the header column. |
set | Banding | Sets the color of the header row. |
set | Banding | Sets the color of the header row. |
set | Banding | Sets the range for this banding. |
set | Banding | Sets the second column color that is alternating. |
set | Banding | Sets the second alternating column color in the banding. |
set | Banding | Sets the second row color that is alternating. |
set | Banding | Sets the second alternating color in the banding. |
BandingTheme
Properties
Property | Type | Description |
---|---|---|
LIGHT_GREY | Enum | A light grey banding theme. |
CYAN | Enum | A cyan banding theme. |
GREEN | Enum | A green banding theme. |
YELLOW | Enum | A yellow banding theme. |
ORANGE | Enum | An orange banding theme. |
BLUE | Enum | A blue banding theme. |
TEAL | Enum | A teal banding theme. |
GREY | Enum | A grey banding theme. |
BROWN | Enum | A brown banding theme. |
LIGHT_GREEN | Enum | A light green banding theme. |
INDIGO | Enum | An indigo banding theme. |
PINK | Enum | A pink banding theme. |
BigQueryDataSourceSpec
Methods
Method | Return type | Brief description |
---|---|---|
copy() | Data | Creates a Data based on this data source's settings. |
get | String | Gets the BigQuery dataset ID. |
get | Data | Gets the parameters of the data source. |
get | String | Gets the billing project ID. |
get | String | Gets the raw query string. |
get | String | Gets the BigQuery table ID. |
get | String | Gets the BigQuery project ID for the table. |
get | Data | Gets the type of the data source. |
BigQueryDataSourceSpecBuilder
Methods
Method | Return type | Brief description |
---|---|---|
build() | Data | Builds a data source specification from the settings in this builder. |
copy() | Data | Creates a Data based on this data source's settings. |
get | String | Gets the BigQuery dataset ID. |
get | Data | Gets the parameters of the data source. |
get | String | Gets the billing project ID. |
get | String | Gets the raw query string. |
get | String | Gets the BigQuery table ID. |
get | String | Gets the BigQuery project ID for the table. |
get | Data | Gets the type of the data source. |
remove | Big | Removes all the parameters. |
remove | Big | Removes the specified parameter. |
set | Big | Sets the BigQuery dataset ID. |
set | Big | Adds a parameter, or if the parameter with the name exists, updates its source cell for data
source spec builders of type Data . |
set | Big | Sets the billing BigQuery project ID. |
set | Big | Sets the raw query string. |
set | Big | Sets the BigQuery table ID. |
set | Big | Sets the BigQuery project ID for the table. |
BooleanCondition
Methods
Method | Return type | Brief description |
---|---|---|
get | Color | Gets the background color for this boolean condition. |
get | Boolean | Returns true if this boolean condition bolds the text and returns false if this
boolean condition removes bolding from the text. |
get | Boolean | Gets the rule's criteria type as defined in the Boolean enum. |
get | Object[] | Gets an array of arguments for the rule's criteria. |
get | Color | Gets the font color for this boolean condition. |
get | Boolean | Returns true if this boolean condition italicises the text and returns false if
this boolean condition removes italics from the text. |
get | Boolean | Returns true if this boolean condition strikes through the text and returns false if this boolean condition removes strikethrough from the text. |
get | Boolean | Returns true if this boolean condition underlines the text and returns false if
this boolean condition removes underlining from the text. |
BooleanCriteria
Properties
Property | Type | Description |
---|---|---|
CELL_EMPTY | Enum | The criteria is met when a cell is empty. |
CELL_NOT_EMPTY | Enum | The criteria is met when a cell is not empty. |
DATE_AFTER | Enum | The criteria is met when a date is after the given value. |
DATE_BEFORE | Enum | The criteria is met when a date is before the given value. |
DATE_EQUAL_TO | Enum | The criteria is met when a date is equal to the given value. |
DATE_NOT_EQUAL_TO | Enum | The criteria is met when a date is not equal to the given value. |
DATE_AFTER_RELATIVE | Enum | The criteria is met when a date is after the relative date value. |
DATE_BEFORE_RELATIVE | Enum | The criteria is met when a date is before the relative date value. |
DATE_EQUAL_TO_RELATIVE | Enum | The criteria is met when a date is equal to the relative date value. |
NUMBER_BETWEEN | Enum | The criteria is met when a number that is between the given values. |
NUMBER_EQUAL_TO | Enum | The criteria is met when a number that is equal to the given value. |
NUMBER_GREATER_THAN | Enum | The criteria is met when a number that is greater than the given value. |
NUMBER_GREATER_THAN_OR_EQUAL_TO | Enum | The criteria is met when a number that is greater than or equal to the given value. |
NUMBER_LESS_THAN | Enum | The criteria is met when a number that is less than the given value. |
NUMBER_LESS_THAN_OR_EQUAL_TO | Enum | The criteria is met when a number that is less than or equal to the given value. |
NUMBER_NOT_BETWEEN | Enum | The criteria is met when a number that is not between the given values. |
NUMBER_NOT_EQUAL_TO | Enum | The criteria is met when a number that is not equal to the given value. |
TEXT_CONTAINS | Enum | The criteria is met when the input contains the given value. |
TEXT_DOES_NOT_CONTAIN | Enum | The criteria is met when the input does not contain the given value. |
TEXT_EQUAL_TO | Enum | The criteria is met when the input is equal to the given value. |
TEXT_NOT_EQUAL_TO | Enum | The criteria is met when the input is not equal to the given value. |
TEXT_STARTS_WITH | Enum | The criteria is met when the input begins with the given value. |
TEXT_ENDS_WITH | Enum | The criteria is met when the input ends with the given value. |
CUSTOM_FORMULA | Enum | The criteria is met when the input makes the given formula evaluate to true . |
BorderStyle
Properties
Property | Type | Description |
---|---|---|
DOTTED | Enum | Dotted line borders. |
DASHED | Enum | Dashed line borders. |
SOLID | Enum | Thin solid line borders. |
SOLID_MEDIUM | Enum | Medium solid line borders. |
SOLID_THICK | Enum | Thick solid line borders. |
DOUBLE | Enum | Two solid line borders. |
CellImage
Properties
Property | Type | Description |
---|---|---|
value | Value | The value type of the cell image, which is Value . |
Methods
Method | Return type | Brief description |
---|---|---|
get | String | Returns the alt text description for this image. |
get | String | Returns the alt text title for this image. |
get | String | Returns a Google-hosted URL to the image. |
to | Cell | Creates a cell image builder based on the current image properties. |
CellImageBuilder
Properties
Property | Type | Description |
---|---|---|
value | Value | The value type of the cell image, which is Value . |
Methods
Method | Return type | Brief description |
---|---|---|
build() | Cell | Creates the image value type needed to add an image to a cell. |
get | String | Returns the alt text description for this image. |
get | String | Returns the alt text title for this image. |
get | String | Returns a Google-hosted URL to the image. |
set | Cell | Sets the alt-text description for this image. |
set | Cell | Sets the alt text title for this image. |
set | Cell | Sets the image source URL. |
to | Cell | Creates a cell image builder based on the current image properties. |
Color
Methods
Method | Return type | Brief description |
---|---|---|
as | Rgb | Converts this color to an Rgb . |
as | Theme | Converts this color to a Theme . |
get | Color | Get the type of this color. |
ColorBuilder
Methods
Method | Return type | Brief description |
---|---|---|
as | Rgb | Converts this color to an Rgb . |
as | Theme | Converts this color to a Theme . |
build() | Color | Creates a color object from the settings supplied to the builder. |
get | Color | Get the type of this color. |
set | Color | Sets as RGB color. |
set | Color | Sets as theme color. |
ConditionalFormatRule
Methods
Method | Return type | Brief description |
---|---|---|
copy() | Conditional | Returns a rule builder preset with this rule's settings. |
get | Boolean | Retrieves the rule's Boolean information if this rule uses
boolean condition criteria. |
get | Gradient | Retrieves the rule's Gradient information, if this rule
uses gradient condition criteria. |
get | Range[] | Retrieves the ranges to which this conditional format rule is applied. |
ConditionalFormatRuleBuilder
Methods
Method | Return type | Brief description |
---|---|---|
build() | Conditional | Constructs a conditional format rule from the settings applied to the builder. |
copy() | Conditional | Returns a rule builder preset with this rule's settings. |
get | Boolean | Retrieves the rule's Boolean information if this rule uses
boolean condition criteria. |
get | Gradient | Retrieves the rule's Gradient information, if this rule
uses gradient condition criteria. |
get | Range[] | Retrieves the ranges to which this conditional format rule is applied. |
set | Conditional | Sets the background color for the conditional format rule's format. |
set | Conditional | Sets the background color for the conditional format rule's format. |
set | Conditional | Sets text bolding for the conditional format rule's format. |
set | Conditional | Sets the font color for the conditional format rule's format. |
set | Conditional | Sets the font color for the conditional format rule's format. |
set | Conditional | Clears the conditional format rule's gradient maxpoint value, and instead uses the maximum value in the rule's ranges. |
set | Conditional | Clears the conditional format rule's gradient maxpoint value, and instead uses the maximum value in the rule's ranges. |
set | Conditional | Sets the conditional format rule's gradient maxpoint fields. |
set | Conditional | Sets the conditional format rule's gradient maxpoint fields. |
set | Conditional | Sets the conditional format rule's gradient midpoint fields. |
set | Conditional | Sets the conditional format rule's gradient midpoint fields. |
set | Conditional | Clears the conditional format rule's gradient minpoint value, and instead uses the minimum value in the rule's ranges. |
set | Conditional | Clears the conditional format rule's gradient minpoint value, and instead uses the minimum value in the rule's ranges. |
set | Conditional | Sets the conditional format rule's gradient minpoint fields. |
set | Conditional | Sets the conditional format rule's gradient minpoint fields. |
set | Conditional | Sets text italics for the conditional format rule's format. |
set | Conditional | Sets one or more ranges to which this conditional format rule is applied. |
set | Conditional | Sets text strikethrough for the conditional format rule's format. |
set | Conditional | Sets text underlining for the conditional format rule's format. |
when | Conditional | Sets the conditional format rule to trigger when the cell is empty. |
when | Conditional | Sets the conditional format rule to trigger when the cell is not empty. |
when | Conditional | Sets the conditional format rule to trigger when a date is after the given value. |
when | Conditional | Sets the conditional format rule to trigger when a date is after the given relative date. |
when | Conditional | Sets the conditional format rule to trigger when a date is before the given date. |
when | Conditional | Sets the conditional format rule to trigger when a date is before the given relative date. |
when | Conditional | Sets the conditional format rule to trigger when a date is equal to the given date. |
when | Conditional | Sets the conditional format rule to trigger when a date is equal to the given relative date. |
when | Conditional | Sets the conditional format rule to trigger when that the given formula evaluates to true . |
when | Conditional | Sets the conditional format rule to trigger when a number falls between, or is either of, two specified values. |
when | Conditional | Sets the conditional format rule to trigger when a number is equal to the given value. |
when | Conditional | Sets the conditional format rule to trigger when a number is greater than the given value. |
when | Conditional | Sets the conditional format rule to trigger when a number is greater than or equal to the given value. |
when | Conditional | Sets the conditional conditional format rule to trigger when a number less than the given value. |
when | Conditional | Sets the conditional format rule to trigger when a number less than or equal to the given value. |
when | Conditional | Sets the conditional format rule to trigger when a number does not fall between, and is neither of, two specified values. |
when | Conditional | Sets the conditional format rule to trigger when a number is not equal to the given value. |
when | Conditional | Sets the conditional format rule to trigger when that the input contains the given value. |
when | Conditional | Sets the conditional format rule to trigger when that the input does not contain the given value. |
when | Conditional | Sets the conditional format rule to trigger when that the input ends with the given value. |
when | Conditional | Sets the conditional format rule to trigger when that the input is equal to the given value. |
when | Conditional | Sets the conditional format rule to trigger when that the input starts with the given value. |
with | Conditional | Sets the conditional format rule to criteria defined by Boolean values,
typically taken from the criteria and arguments of an
existing rule. |
ContainerInfo
Methods
Method | Return type | Brief description |
---|---|---|
get | Integer | The chart's left side is anchored in this column. |
get | Integer | The chart's top side is anchored in this row. |
get | Integer | The chart's upper left hand corner is offset from the anchor column by this many pixels. |
get | Integer | The chart's upper left hand corner is offset from the anchor row by this many pixels. |
CopyPasteType
Properties
Property | Type | Description |
---|---|---|
PASTE_NORMAL | Enum | Paste values, formulas, formats and merges. |
PASTE_NO_BORDERS | Enum | Paste values, formulas, formats and merges but without borders. |
PASTE_FORMAT | Enum | Paste the format only. |
PASTE_FORMULA | Enum | Paste the formulas only. |
PASTE_DATA_VALIDATION | Enum | Paste the data validation only. |
PASTE_VALUES | Enum | Paste the values ONLY without formats, formulas or merges. |
PASTE_CONDITIONAL_FORMATTING | Enum | Paste the color rules only. |
PASTE_COLUMN_WIDTHS | Enum | Paste the column widths only. |
DataExecutionErrorCode
Properties
Property | Type | Description |
---|---|---|
DATA_EXECUTION_ERROR_CODE_UNSUPPORTED | Enum | A data execution error code that is not supported in Apps Script. |
NONE | Enum | The data execution has no error. |
TIME_OUT | Enum | The data execution timed out. |
TOO_MANY_ROWS | Enum | The data execution returns more rows than the limit. |
TOO_MANY_COLUMNS | Enum | The data execution returns more columns than the limit. |
TOO_MANY_CELLS | Enum | The data execution returns more cells than the limit. |
ENGINE | Enum | Data execution engine error. |
PARAMETER_INVALID | Enum | Invalid data execution parameter. |
UNSUPPORTED_DATA_TYPE | Enum | The data execution returns unsupported data type. |
DUPLICATE_COLUMN_NAMES | Enum | The data execution returns duplicate column names. |
INTERRUPTED | Enum | The data execution is interrupted. |
OTHER | Enum | Other errors. |
TOO_MANY_CHARS_PER_CELL | Enum | The data execution returns values that exceed the maximum characters allowed in a single cell. |
DATA_NOT_FOUND | Enum | The database referenced by the data source is not found. |
PERMISSION_DENIED | Enum | The user does not have access to the database referenced by the data source. |
DataExecutionState
Properties
Property | Type | Description |
---|---|---|
DATA_EXECUTION_STATE_UNSUPPORTED | Enum | A data execution state is not supported in Apps Script. |
RUNNING | Enum | The data execution has started and is running. |
SUCCESS | Enum | The data execution is completed and successful. |
ERROR | Enum | The data execution is completed and has errors. |
NOT_STARTED | Enum | The data execution has not started. |
DataExecutionStatus
Methods
Method | Return type | Brief description |
---|---|---|
get | Data | Gets the error code of the data execution. |
get | String | Gets the error message of the data execution. |
get | Data | Gets the state of the data execution. |
get | Date | Gets the time the last data execution completed regardless of the execution state. |
get | Date | Gets the time the data last successfully refreshed. |
is | Boolean | Returns true if the data from last successful execution is truncated, or false
otherwise. |
DataSource
Methods
Method | Return type | Brief description |
---|---|---|
cancel | void | Cancels all currently running refreshes of data source objects linked to this data source. |
create | Data | Creates a calculated column. |
create | Data | Creates a data source pivot table from this data source in the first cell of a new sheet. |
create | Data | Creates a data source table from this data source in the first cell of a new sheet. |
get | Data | Returns the calculated column in the data source that matches the column name. |
get | Data | Returns all the calculated columns in the data source. |
get | Data | Returns all the columns in the data source. |
get | Data | Returns the data source sheets associated with this data source. |
get | Data | Gets the data source specification. |
refresh | void | Refreshes all data source objects linked to the data source. |
update | Data | Updates the data source specification and refreshes the data source objects linked with this data source with the new specification. |
update | Data | Updates the data source specification and refreshes the linked data
source sheets with the new specification. |
wait | void | Waits until all the current executions of the linked data source objects complete, timing out after the provided number of seconds. |
DataSourceChart
Methods
Method | Return type | Brief description |
---|---|---|
cancel | Data | Cancels the data refresh associated with this object if it's currently running. |
force | Data | Refreshes the data of this object regardless of the current state. |
get | Data | Gets the data source the object is linked to. |
get | Data | Gets the data execution status of the object. |
refresh | Data | Refreshes the data of the object. |
wait | Data | Waits until the current execution completes, timing out after the provided number of seconds. |
DataSourceColumn
Methods
Method | Return type | Brief description |
---|---|---|
get | Data | Gets the data source associated with the data source column. |
get | String | Gets the formula for the data source column. |
get | String | Gets the name for the data source column. |
has | Boolean | Returns whether the column has an array dependency. |
is | Boolean | Returns whether the column is a calculated column. |
remove() | void | Removes the data source column. |
set | Data | Sets the formula for the data source column. |
set | Data | Sets the name of the data source column. |
DataSourceFormula
Methods
Method | Return type | Brief description |
---|---|---|
cancel | Data | Cancels the data refresh associated with this object if it's currently running. |
force | Data | Refreshes the data of this object regardless of the current state. |
get | Range | Returns the Range representing the cell where this data source formula is anchored. |
get | Data | Gets the data source the object is linked to. |
get | String | Returns the display value of the data source formula. |
get | String | Returns the formula for this data source formula. |
get | Data | Gets the data execution status of the object. |
refresh | Data | Refreshes the data of the object. |
set | Data | Updates the formula. |
wait | Data | Waits until the current execution completes, timing out after the provided number of seconds. |
DataSourceParameter
Methods
Method | Return type | Brief description |
---|---|---|
get | String | Gets the parameter name. |
get | String | Gets the source cell the parameter is valued based on, or null if the parameter type is
not Data . |
get | Data | Gets the parameter type. |
DataSourceParameterType
Properties
Property | Type | Description |
---|---|---|
DATA_SOURCE_PARAMETER_TYPE_UNSUPPORTED | Enum | A data source parameter type that is not supported in Apps Script. |
CELL | Enum | The data source parameter is valued based on a cell. |
DataSourcePivotTable
Methods
Method | Return type | Brief description |
---|---|---|
add | Pivot | Adds a new pivot column group based on the specified data source column. |
add | Pivot | Adds a new filter based on the specified data source column with the specified filter criteria. |
add | Pivot | Adds a new pivot value based on the specified data source column without any summarize function. |
add | Pivot | Adds a new pivot value based on the specified data source column with the specified summarize function. |
add | Pivot | Adds a new pivot row group based on the specified data source column. |
as | Pivot | Returns the data source pivot table as a regular pivot table object. |
cancel | Data | Cancels the data refresh associated with this object if it's currently running. |
force | Data | Refreshes the data of this object regardless of the current state. |
get | Data | Gets the data source the object is linked to. |
get | Data | Gets the data execution status of the object. |
refresh | Data | Refreshes the data of the object. |
wait | Data | Waits until the current execution completes, timing out after the provided number of seconds. |
DataSourceRefreshSchedule
Methods
Method | Return type | Brief description |
---|---|---|
get | Data | Gets the refresh schedule frequency, which specifies how often and when to refresh. |
get | Data | Gets the scope of this refresh schedule. |
get | Time | Gets the time window of the next run of this refresh schedule. |
is | Boolean | Determines whether this refresh schedule is enabled. |
DataSourceRefreshScheduleFrequency
Methods
Method | Return type | Brief description |
---|---|---|
get | Integer[] | Gets the days of the month as numbers (1-28) on which to refresh the data source. |
get | Weekday[] | Gets the days of the week on which to refresh the data source. |
get | Frequency | Gets the frequency type. |
get | Integer | Gets the start hour (as a number 0-23) of the time interval during which the refresh schedule runs. |
DataSourceRefreshScope
Properties
Property | Type | Description |
---|---|---|
DATA_SOURCE_REFRESH_SCOPE_UNSUPPORTED | Enum | The data source refresh scope is unsupported. |
ALL_DATA_SOURCES | Enum | The refresh applies to all data sources in the spreadsheet. |
DataSourceSheet
Methods
Method | Return type | Brief description |
---|---|---|
add | Data | Adds a filter applied to the data source sheet. |
as | Sheet | Returns the data source sheet as a regular sheet object. |
auto | Data | Auto resizes the width of the specified column. |
auto | Data | Auto resizes the width of the specified columns. |
cancel | Data | Cancels the data refresh associated with this object if it's currently running. |
force | Data | Refreshes the data of this object regardless of the current state. |
get | Integer | Returns the width of the specified column. |
get | Data | Gets the data source the object is linked to. |
get | Data | Returns all filters applied to the data source sheet. |
get | Object[] | Returns all the values for the data source sheet for the provided column name. |
get | Object[] | Returns all the values for the data source sheet for the provided column name from the provided
start row (based-1) and up to the provided num . |
get | Sort | Gets all the sort specs in the data source sheet. |
get | Data | Gets the data execution status of the object. |
refresh | Data | Refreshes the data of the object. |
remove | Data | Removes all filters applied to the data source sheet column. |
remove | Data | Removes the sort spec on a column in the data source sheet. |
set | Data | Sets the width of the specified column. |
set | Data | Sets the width of the specified columns. |
set | Data | Sets the sort spec on a column in the data source sheet. |
set | Data | Sets the sort spec on a column in the data source sheet. |
wait | Data | Waits until the current execution completes, timing out after the provided number of seconds. |
DataSourceSheetFilter
Methods
Method | Return type | Brief description |
---|---|---|
get | Data | Returns the data source column this filter applies to. |
get | Data | Returns the Data that this filter belongs to. |
get | Filter | Returns the filter criteria for this filter. |
remove() | void | Removes this filter from the data source object. |
set | Data | Sets the filter criteria for this filter. |
DataSourceSpec
Methods
Method | Return type | Brief description |
---|---|---|
as | Big | Gets the spec for BigQuery data source. |
as | Looker | Gets the spec for Looker data source. |
copy() | Data | Creates a Data based on this data source's settings. |
get | Data | Gets the parameters of the data source. |
get | Data | Gets the type of the data source. |
DataSourceSpecBuilder
Methods
Method | Return type | Brief description |
---|---|---|
as | Big | Gets the builder for BigQuery data source. |
as | Looker | Gets the builder for Looker data source. |
build() | Data | Builds a data source specification from the settings in this builder. |
copy() | Data | Creates a Data based on this data source's settings. |
get | Data | Gets the parameters of the data source. |
get | Data | Gets the type of the data source. |
remove | Data | Removes all the parameters. |
remove | Data | Removes the specified parameter. |
set | Data | Adds a parameter, or if the parameter with the name exists, updates its source cell for data
source spec builders of type Data . |
DataSourceTable
Methods
Method | Return type | Brief description |
---|---|---|
add | Data | Adds columns to the data source table. |
add | Data | Adds a filter applied to the data source table. |
add | Data | Adds a sort spec on a column in the data source table. |
add | Data | Adds a sort spec on a column in the data source table. |
cancel | Data | Cancels the data refresh associated with this object if it's currently running. |
force | Data | Refreshes the data of this object regardless of the current state. |
get | Data | Gets all the data source columns added to the data source table. |
get | Data | Gets the data source the object is linked to. |
get | Data | Returns all filters applied to the data source table. |
get | Range | Gets the Range this data source table spans. |
get | Integer | Returns the row limit for the data source table. |
get | Sort | Gets all the sort specs in the data source table. |
get | Data | Gets the data execution status of the object. |
is | Boolean | Returns whether the data source table is syncing all columns in the associated data source. |
refresh | Data | Refreshes the data of the object. |
remove | Data | Removes all the columns in the data source table. |
remove | Data | Removes all the sort specs in the data source table. |
set | Data | Updates the row limit for the data source table. |
sync | Data | Sync all current and future columns in the associated data source to the data source table. |
wait | Data | Waits until the current execution completes, timing out after the provided number of seconds. |
DataSourceTableColumn
Methods
Method | Return type | Brief description |
---|---|---|
get | Data | Gets the data source column. |
remove() | void | Removes the column from the Data . |
DataSourceTableFilter
Methods
Method | Return type | Brief description |
---|---|---|
get | Data | Returns the data source column this filter applies to. |
get | Data | Returns the Data that this filter belongs to. |
get | Filter | Returns the filter criteria for this filter. |
remove() | void | Removes this filter from the data source object. |
set | Data | Sets the filter criteria for this filter. |
DataSourceType
Properties
Property | Type | Description |
---|---|---|
DATA_SOURCE_TYPE_UNSUPPORTED | Enum | A data source type that is not supported in Apps Script. |
BIGQUERY | Enum | A BigQuery data source. |
LOOKER | Enum | A Looker data source. |
DataValidation
Methods
Method | Return type | Brief description |
---|---|---|
copy() | Data | Creates a builder for a data validation rule based on this rule's settings. |
get | Boolean | Returns true if the rule shows a warning when input fails data validation, or false if it rejects the input entirely. |
get | Data | Gets the rule's criteria type as defined in the Data enum. |
get | Object[] | Gets an array of arguments for the rule's criteria. |
get | String | Gets the rule's help text, or null if no help text is set. |
DataValidationBuilder
Methods
Method | Return type | Brief description |
---|---|---|
build() | Data | Constructs a data validation rule from the settings applied to the builder. |
copy() | Data | Creates a builder for a data validation rule based on this rule's settings. |
get | Boolean | Returns true if the rule shows a warning when input fails data validation, or false if it rejects the input entirely. |
get | Data | Gets the rule's criteria type as defined in the Data enum. |
get | Object[] | Gets an array of arguments for the rule's criteria. |
get | String | Gets the rule's help text, or null if no help text is set. |
require | Data | Sets the data validation rule to require that the input is a boolean value; this value is rendered as a checkbox. |
require | Data | Sets the data validation rule to require that the input is the specified value or blank. |
require | Data | Sets the data validation rule to require that the input is one of the specified values. |
require | Data | Sets the data validation rule to require a date. |
require | Data | Sets the data validation rule to require a date after the given value. |
require | Data | Sets the data validation rule to require a date before the given value. |
require | Data | Sets the data validation rule to require a date that falls between, or is either of, two specified dates. |
require | Data | Sets the data validation rule to require a date equal to the given value. |
require | Data | Sets the data validation rule to require a date that does not fall between, and is neither of, two specified dates. |
require | Data | Sets the data validation rule to require a date on or after the given value. |
require | Data | Sets the data validation rule to require a date on or before the given value. |
require | Data | Sets the data validation rule to require that the given formula evaluates to true . |
require | Data | Sets the data validation rule to require a number that falls between, or is either of, two specified numbers. |
require | Data | Sets the data validation rule to require a number equal to the given value. |
require | Data | Sets the data validation rule to require a number greater than the given value. |
require | Data | Sets the data validation rule to require a number greater than or equal to the given value. |
require | Data | Sets the data validation rule to require a number less than the given value. |
require | Data | Sets the data validation rule to require a number less than or equal to the given value. |
require | Data | Sets the data validation rule to require a number that does not fall between, and is neither of, two specified numbers. |
require | Data | Sets the data validation rule to require a number not equal to the given value. |
require | Data | Sets the data validation rule to require that the input contains the given value. |
require | Data | Sets the data validation rule to require that the input does not contain the given value. |
require | Data | Sets the data validation rule to require that the input is equal to the given value. |
require | Data | Sets the data validation rule to require that the input is in the form of an email address. |
require | Data | Sets the data validation rule to require that the input is in the form of a URL. |
require | Data | Sets the data validation rule to require that the input is equal to one of the given values. |
require | Data | Sets the data validation rule to require that the input is equal to one of the given values, with an option to hide the dropdown menu. |
require | Data | Sets the data validation rule to require that the input is equal to a value in the given range. |
require | Data | Sets the data validation rule to require that the input is equal to a value in the given range, with an option to hide the dropdown menu. |
set | Data | Sets whether to show a warning when input fails data validation or whether to reject the input entirely. |
set | Data | Sets the help text that appears when the user hovers over the cell on which data validation is set. |
with | Data | Sets the data validation rule to criteria defined by Data values,
typically taken from the criteria and arguments of an existing rule. |
DataValidationCriteria
Properties
Property | Type | Description |
---|---|---|
DATE_AFTER | Enum | Requires a date that is after the given value. |
DATE_BEFORE | Enum | Requires a date that is before the given value. |
DATE_BETWEEN | Enum | Requires a date that is between the given values. |
DATE_EQUAL_TO | Enum | Requires a date that is equal to the given value. |
DATE_IS_VALID_DATE | Enum | Requires a date. |
DATE_NOT_BETWEEN | Enum | Requires a date that is not between the given values. |
DATE_ON_OR_AFTER | Enum | Require a date that is on or after the given value. |
DATE_ON_OR_BEFORE | Enum | Requires a date that is on or before the given value. |
NUMBER_BETWEEN | Enum | Requires a number that is between the given values. |
NUMBER_EQUAL_TO | Enum | Requires a number that is equal to the given value. |
NUMBER_GREATER_THAN | Enum | Require a number that is greater than the given value. |
NUMBER_GREATER_THAN_OR_EQUAL_TO | Enum | Requires a number that is greater than or equal to the given value. |
NUMBER_LESS_THAN | Enum | Requires a number that is less than the given value. |
NUMBER_LESS_THAN_OR_EQUAL_TO | Enum | Requires a number that is less than or equal to the given value. |
NUMBER_NOT_BETWEEN | Enum | Requires a number that is not between the given values. |
NUMBER_NOT_EQUAL_TO | Enum | Requires a number that is not equal to the given value. |
TEXT_CONTAINS | Enum | Requires that the input contains the given value. |
TEXT_DOES_NOT_CONTAIN | Enum | Requires that the input does not contain the given value. |
TEXT_EQUAL_TO | Enum | Requires that the input is equal to the given value. |
TEXT_IS_VALID_EMAIL | Enum | Requires that the input is in the form of an email address. |
TEXT_IS_VALID_URL | Enum | Requires that the input is in the form of a URL. |
VALUE_IN_LIST | Enum | Requires that the input is equal to one of the given values. |
VALUE_IN_RANGE | Enum | Requires that the input is equal to a value in the given range. |
CUSTOM_FORMULA | Enum | Requires that the input makes the given formula evaluate to true . |
CHECKBOX | Enum | Requires that the input is a custom value or a boolean; rendered as a checkbox. |
DateTimeGroupingRule
Methods
Method | Return type | Brief description |
---|---|---|
get | Date | Gets the type of the date-time grouping rule. |
DateTimeGroupingRuleType
Properties
Property | Type | Description |
---|---|---|
UNSUPPORTED | Enum | A date-time grouping rule type that is not supported. |
SECOND | Enum | Group date-time by second, from 0 to 59. |
MINUTE | Enum | Group date-time by minute, from 0 to 59. |
HOUR | Enum | Group date-time by hour using a 24-hour system, from 0 to 23. |
HOUR_MINUTE | Enum | Group date-time by hour and minute using a 24-hour system, for example 19:45 . |
HOUR_MINUTE_AMPM | Enum | Group date-time by hour and minute using a 12-hour system, for example 7:45 PM . |
DAY_OF_WEEK | Enum | Group date-time by day of week, for example Sunday . |
DAY_OF_YEAR | Enum | Group date-time by day of year, from 1 to 366. |
DAY_OF_MONTH | Enum | Group date-time by day of month, from 1 to 31. |
DAY_MONTH | Enum | Group date-time by day and month, for example 22-Nov . |
MONTH | Enum | Group date-time by month, for example Nov . |
QUARTER | Enum | Group date-time by quarter, for example Q1 (which represents Jan-Mar). |
YEAR | Enum | Group date-time by year, for example 2008. |
YEAR_MONTH | Enum | Group date-time by year and month, for example 2008-Nov . |
YEAR_QUARTER | Enum | Group date-time by year and quarter, for example 2008 Q4 . |
YEAR_MONTH_DAY | Enum | Group date-time by year, month, and day, for example 2008-11-22 . |
DeveloperMetadata
Methods
Method | Return type | Brief description |
---|---|---|
get | Integer | Returns the unique ID associated with this developer metadata. |
get | String | Returns the key associated with this developer metadata. |
get | Developer | Returns the location of this developer metadata. |
get | String | Returns the value associated with this developer metadata, or null if this metadata has
no value. |
get | Developer | Returns the visibility of this developer metadata. |
move | Developer | Moves this developer metadata to the specified column. |
move | Developer | Moves this developer metadata to the specified row. |
move | Developer | Moves this developer metadata to the specified sheet. |
move | Developer | Moves this developer metadata to the top-level spreadsheet. |
remove() | void | Deletes this metadata. |
set | Developer | Sets the key of this developer metadata to the specified value. |
set | Developer | Sets the value associated with this developer metadata to the specified value. |
set | Developer | Sets the visibility of this developer metadata to the specified visibility. |
DeveloperMetadataFinder
Methods
Method | Return type | Brief description |
---|---|---|
find() | Developer | Executes this search and returns the matching metadata. |
on | Developer | Configures the search to consider intersecting locations that have metadata. |
with | Developer | Limits this search to consider only metadata that match the specified ID. |
with | Developer | Limits this search to consider only metadata that match the specified key. |
with | Developer | Limits this search to consider only metadata that match the specified location type. |
with | Developer | Limits this search to consider only metadata that match the specified value. |
with | Developer | Limits this search to consider only metadata that match the specified visibility. |
DeveloperMetadataLocation
Methods
Method | Return type | Brief description |
---|---|---|
get | Range | Returns the Range for the column location of this metadata, or null if the
location type is not Developer . |
get | Developer | Gets the type of location. |
get | Range | Returns the Range for the row location of this metadata, or null if the
location type is not Developer . |
get | Sheet | Returns the Sheet location of this metadata, or null if the location type is
not Developer . |
get | Spreadsheet | Returns the Spreadsheet location of this metadata, or null if the location
type is not Developer . |
DeveloperMetadataLocationType
Properties
Property | Type | Description |
---|---|---|
SPREADSHEET | Enum | The location type for developer metadata associated with the top-level spreadsheet. |
SHEET | Enum | The location type for developer metadata associated with a whole sheet. |
ROW | Enum | The location type for developer metadata associated with a row. |
COLUMN | Enum | The location type for developer metadata associated with a column. |
DeveloperMetadataVisibility
Properties
Property | Type | Description |
---|---|---|
DOCUMENT | Enum | Document-visible metadata is accessible from any developer project with access to the document. |
PROJECT | Enum | Project-visible metadata is only visible to and accessible by the developer project that created the metadata. |
Dimension
Properties
Property | Type | Description |
---|---|---|
COLUMNS | Enum | The column (vertical) dimension. |
ROWS | Enum | The row (horizontal) dimension. |
Direction
Properties
Property | Type | Description |
---|---|---|
UP | Enum | The direction of decreasing row indices. |
DOWN | Enum | The direction of increasing row indices. |
PREVIOUS | Enum | The direction of decreasing column indices. |
NEXT | Enum | The direction of increasing column indices. |
Drawing
Methods
Method | Return type | Brief description |
---|---|---|
get | Container | Gets information about where the drawing is positioned in the sheet. |
get | Integer | Returns the actual height of this drawing in pixels. |
get | String | Returns the name of the macro attached to this drawing. |
get | Sheet | Returns the sheet this drawing appears on. |
get | Integer | Returns the actual width of this drawing in pixels. |
get | Number | Returns the z-index of this drawing. |
remove() | void | Deletes this drawing from the spreadsheet. |
set | Drawing | Sets the actual height of this drawing in pixels. |
set | Drawing | Assigns a macro function to this drawing. |
set | Drawing | Sets the position where the drawing appears on the sheet. |
set | Drawing | Sets the actual width of this drawing in pixels. |
set | Drawing | Sets the z-index of this drawing. |
EmbeddedAreaChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
reverse | Embedded | Reverses the drawing of series in the domain axis. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the style for points in the line. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the range for the chart. |
set | Embedded | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
set | Embedded | Sets the horizontal axis text style. |
set | Embedded | Adds a title to the horizontal axis. |
set | Embedded | Sets the horizontal axis title text style. |
set | Embedded | Sets the vertical axis text style. |
set | Embedded | Adds a title to the vertical axis. |
set | Embedded | Sets the vertical axis title text style. |
use | Embedded | Makes the range axis into a logarithmic scale (requires all values to be positive). |
EmbeddedBarChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
reverse | Embedded | Reverses the drawing of series in the domain axis. |
reverse | Embedded | Reverses the direction in which the bars grow along the horizontal axis. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the range for the chart. |
set | Embedded | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
set | Embedded | Sets the horizontal axis text style. |
set | Embedded | Adds a title to the horizontal axis. |
set | Embedded | Sets the horizontal axis title text style. |
set | Embedded | Sets the vertical axis text style. |
set | Embedded | Adds a title to the vertical axis. |
set | Embedded | Sets the vertical axis title text style. |
use | Embedded | Makes the range axis into a logarithmic scale (requires all values to be positive). |
EmbeddedChart
Methods
Method | Return type | Brief description |
---|---|---|
as | Data | Casts to a data source chart instance if the chart is a data source chart, or null
otherwise. |
get | Blob | Return the data inside this object as a blob converted to the specified content type. |
get | Blob | Return the data inside this object as a blob. |
get | Integer | Returns a stable identifier for the chart that is unique across the spreadsheet containing the
chart or null if the chart is not in a spreadsheet. |
get | Container | Returns information about where the chart is positioned within a sheet. |
get | Chart | Returns the strategy to use for handling hidden rows and columns. |
get | Chart | Returns the merge strategy used when more than one range exists. |
get | Integer | Returns the number of rows or columns the range that are treated as headers. |
get | Chart | Returns the options for this chart, such as height, colors, and axes. |
get | Range[] | Returns the ranges that this chart uses as a data source. |
get | Boolean | If true , the rows and columns used to populate the chart are switched. |
modify() | Embedded | Returns an Embedded that can be used to modify this chart. |
EmbeddedChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
EmbeddedColumnChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
reverse | Embedded | Reverses the drawing of series in the domain axis. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the range for the chart. |
set | Embedded | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
set | Embedded | Sets the horizontal axis text style. |
set | Embedded | Adds a title to the horizontal axis. |
set | Embedded | Sets the horizontal axis title text style. |
set | Embedded | Sets the vertical axis text style. |
set | Embedded | Adds a title to the vertical axis. |
set | Embedded | Sets the vertical axis title text style. |
use | Embedded | Makes the range axis into a logarithmic scale (requires all values to be positive). |
EmbeddedComboChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
reverse | Embedded | Reverses the drawing of series in the domain axis. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the range for the chart. |
set | Embedded | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
set | Embedded | Sets the horizontal axis text style. |
set | Embedded | Adds a title to the horizontal axis. |
set | Embedded | Sets the horizontal axis title text style. |
set | Embedded | Sets the vertical axis text style. |
set | Embedded | Adds a title to the vertical axis. |
set | Embedded | Sets the vertical axis title text style. |
use | Embedded | Makes the range axis into a logarithmic scale (requires all values to be positive). |
EmbeddedHistogramChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
reverse | Embedded | Reverses the drawing of series in the domain axis. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the range for the chart. |
set | Embedded | Uses stacked lines, meaning that line and bar values are stacked (accumulated). |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
set | Embedded | Sets the horizontal axis text style. |
set | Embedded | Adds a title to the horizontal axis. |
set | Embedded | Sets the horizontal axis title text style. |
set | Embedded | Sets the vertical axis text style. |
set | Embedded | Adds a title to the vertical axis. |
set | Embedded | Sets the vertical axis title text style. |
use | Embedded | Makes the range axis into a logarithmic scale (requires all values to be positive). |
EmbeddedLineChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
reverse | Embedded | Reverses the drawing of series in the domain axis. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the style to use for curves in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the style for points in the line. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the range for the chart. |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
set | Embedded | Sets the horizontal axis text style. |
set | Embedded | Adds a title to the horizontal axis. |
set | Embedded | Sets the horizontal axis title text style. |
set | Embedded | Sets the vertical axis text style. |
set | Embedded | Adds a title to the vertical axis. |
set | Embedded | Sets the vertical axis title text style. |
use | Embedded | Makes the range axis into a logarithmic scale (requires all values to be positive). |
EmbeddedPieChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
reverse | Embedded | Reverses the drawing of series in the domain axis. |
set3D() | Embedded | Sets the chart to be three-dimensional. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
EmbeddedScatterChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
set | Embedded | Sets the background color for the chart. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the colors for the lines in the chart. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the position of the legend with respect to the chart. |
set | Embedded | Sets the text style of the chart legend. |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the style for points in the line. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets the title of the chart. |
set | Embedded | Sets the text style of the chart title. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
set | Embedded | Makes the horizontal axis into a logarithmic scale (requires all values to be positive). |
set | Embedded | Sets the range for the horizontal axis of the chart. |
set | Embedded | Sets the horizontal axis text style. |
set | Embedded | Adds a title to the horizontal axis. |
set | Embedded | Sets the horizontal axis title text style. |
set | Embedded | Makes the vertical axis into a logarithmic scale (requires all values to be positive). |
set | Embedded | Sets the range for the vertical axis of the chart. |
set | Embedded | Sets the vertical axis text style. |
set | Embedded | Adds a title to the vertical axis. |
set | Embedded | Sets the vertical axis title text style. |
EmbeddedTableChartBuilder
Methods
Method | Return type | Brief description |
---|---|---|
add | Embedded | Adds a range to the chart this builder modifies. |
as | Embedded | Sets the chart type to AreaChart and returns an Embedded . |
as | Embedded | Sets the chart type to BarChart and returns an Embedded . |
as | Embedded | Sets the chart type to ColumnChart and returns an Embedded . |
as | Embedded | Sets the chart type to ComboChart and returns an Embedded . |
as | Embedded | Sets the chart type to HistogramChart and returns an Embedded . |
as | Embedded | Sets the chart type to LineChart and returns an Embedded . |
as | Embedded | Sets the chart type to PieChart and returns an Embedded . |
as | Embedded | Sets the chart type to ScatterChart and returns an Embedded . |
as | Embedded | Sets the chart type to TableChart and returns an Embedded . |
build() | Embedded | Builds the chart to reflect all changes made to it. |
clear | Embedded | Removes all ranges from the chart this builder modifies. |
enable | Embedded | Sets whether to enable paging through the data. |
enable | Embedded | Enables paging and sets the number of rows in each page. |
enable | Embedded | Enables paging, sets the number of rows in each page and the first table page to display (page numbers are zero based). |
enable | Embedded | Adds basic support for right-to-left languages (such as Arabic or Hebrew) by reversing the column order of the table, so that column zero is the right-most column, and the last column is the left-most column. |
enable | Embedded | Sets whether to sort columns when the user clicks a column heading. |
get | Chart | Returns the current chart type. |
get | Container | Return the chart Container , which encapsulates where the chart appears on the
sheet. |
get | Range[] | Returns a copy of the list of ranges currently providing data for this chart. |
remove | Embedded | Removes the specified range from the chart this builder modifies. |
set | Embedded | Changes the type of chart. |
set | Embedded | Sets the row number for the first row in the data table. |
set | Embedded | Sets the strategy to use for hidden rows and columns. |
set | Embedded | Sets the index of the column according to which the table should be initially sorted (ascending). |
set | Embedded | Sets the index of the column according to which the table should be initially sorted (descending). |
set | Embedded | Sets the merge strategy to use when more than one range exists. |
set | Embedded | Sets the number of rows or columns of the range that should be treated as headers. |
set | Embedded | Sets advanced options for this chart. |
set | Embedded | Sets the position, changing where the chart appears on the sheet. |
set | Embedded | Sets whether the chart's rows and columns are transposed. |
show | Embedded | Sets whether to show the row number as the first column of the table. |
use | Embedded | Sets whether alternating color style is assigned to odd and even rows of a table chart. |
Filter
Methods
Method | Return type | Brief description |
---|---|---|
get | Filter | Gets the filter criteria on the specified column, or null if the column doesn't have
filter criteria applied to it. |
get | Range | Gets the range this filter applies to. |
remove() | void | Removes this filter. |
remove | Filter | Removes the filter criteria from the specified column. |
set | Filter | Sets the filter criteria on the specified column. |
sort(columnPosition, ascending) | Filter | Sorts the filtered range by the specified column, excluding the first row (the header row) in the range this filter applies to. |
FilterCriteria
Methods
Method | Return type | Brief description |
---|---|---|
copy() | Filter | Copies this filter criteria and creates a criteria builder that you can apply to another filter. |
get | Boolean | Returns the criteria's boolean type, for example, CELL_EMPTY . |
get | Object[] | Returns an array of arguments for boolean criteria. |
get | String[] | Returns the values that the filter hides. |
get | Color | Returns the background color used as filter criteria. |
get | Color | Returns the foreground color used as a filter criteria. |
get | String[] | Returns the values that the pivot table filter shows. |
FilterCriteriaBuilder
Methods
Method | Return type | Brief description |
---|---|---|
build() | Filter | Assembles the filter criteria using the settings you add to the criteria builder. |
copy() | Filter | Copies this filter criteria and creates a criteria builder that you can apply to another filter. |
get | Boolean | Returns the criteria's boolean type, for example, CELL_EMPTY . |
get | Object[] | Returns an array of arguments for boolean criteria. |
get | String[] | Returns the values that the filter hides. |
get | Color | Returns the background color used as filter criteria. |
get | Color | Returns the foreground color used as a filter criteria. |
get | String[] | Returns the values that the pivot table filter shows. |
set | Filter | Sets the values to hide. |
set | Filter | Sets the background color used as filter criteria. |
set | Filter | Sets the foreground color used as filter criteria. |
set | Filter | Sets the values to show on a pivot table. |
when | Filter | Sets the filter criteria to show empty cells. |
when | Filter | Sets the filter criteria to show cells that aren't empty. |
when | Filter | Sets filter criteria that shows cells with dates that are after the specified date. |
when | Filter | Sets filter criteria that shows cells with dates that are after the specified relative date. |
when | Filter | Sets filter criteria that shows cells with dates that are before the specified date. |
when | Filter | Sets filter criteria that shows cells with dates that are before the specified relative date. |
when | Filter | Sets filter criteria that shows cells with dates that are equal to the specified date. |
when | Filter | Sets filter criteria that shows cells with dates that are equal to the specified relative date. |
when | Filter | Sets the filter criteria to show cells with dates that are equal to any of the specified dates. |
when | Filter | Sets the filter criteria to show cells that aren't equal to the specified date. |
when | Filter | Sets the filter criteria to show cells with dates that aren't equal to any of the specified dates. |
when | Filter | Sets the filter criteria to show cells with a specified formula (such as =B:B<C:C ) that
evaluates to true . |
when | Filter | Sets the filter criteria to show cells with a number that falls between, or is either of, 2 specified numbers. |
when | Filter | Sets the filter criteria to show cells with a number that's equal to the specified number. |
when | Filter | Sets the filter criteria to show cells with a number that's equal to any of the specified numbers. |
when | Filter | Sets the filter criteria to show cells with a number greater than the specified number |
when | Filter | Sets the filter criteria to show cells with a number greater than or equal to the specified number. |
when | Filter | Sets the filter criteria to show cells with a number that's less than the specified number. |
when | Filter | Sets the filter criteria to show cells with a number less than or equal to the specified number. |
when | Filter | Sets the filter criteria to show cells with a number doesn't fall between, and is neither of, 2 specified numbers. |
when | Filter | Sets the filter criteria to show cells with a number that isn't equal to the specified number. |
when | Filter | Sets the filter criteria to show cells with a number that isn't equal to any of the specified numbers. |
when | Filter | Sets the filter criteria to show cells with text that contains the specified text. |
when | Filter | Sets the filter criteria to show cells with text that doesn't contain the specified text. |
when | Filter | Sets the filter criteria to show cells with text that ends with the specified text. |
when | Filter | Sets the filter criteria to show cells with text that's equal to the specified text. |
when | Filter | Sets the filter criteria to show cells with text that's equal to any of the specified text values. |
when | Filter | Sets the filter criteria to show cells with text that isn't equal to the specified text. |
when | Filter | Sets the filter criteria to show cells with text that isn't equal to any of the specified values. |
when | Filter | Sets the filter criteria to show cells with text that starts with the specified text. |
with | Filter | Sets the filter criteria to a boolean condition defined by Boolean values, such
as CELL_EMPTY or NUMBER_GREATER_THAN . |
FrequencyType
Properties
Property | Type | Description |
---|---|---|
FREQUENCY_TYPE_UNSUPPORTED | Enum | The frequency type is unsupported. |
DAILY | Enum | Refresh daily. |
WEEKLY | Enum | Refresh weekly, on given days of the week. |
MONTHLY | Enum | Refresh monthly, on given days of the month. |
GradientCondition
Methods
Method | Return type | Brief description |
---|---|---|
get | Color | Gets the color set for the maximum value of this gradient condition. |
get | Interpolation | Gets the interpolation type for the maximum value of this gradient condition. |
get | String | Gets the max value of this gradient condition. |
get | Color | Gets the color set for the midpoint value of this gradient condition. |
get | Interpolation | Gets the interpolation type for the mid-point value of this gradient condition. |
get | String | Gets the mid-point value of this gradient condition. |
get | Color | Gets the color set for the minimum value of this gradient condition. |
get | Interpolation | Gets the interpolation type for the minimum value of this gradient condition. |
get | String | Gets the minimum value of this gradient condition. |
Group
Methods
Method | Return type | Brief description |
---|---|---|
collapse() | Group | Collapses this group. |
expand() | Group | Expands this group. |
get | Integer | Returns the control toggle index of this group. |
get | Integer | Returns the depth of this group. |
get | Range | Returns the range over which this group exists. |
is | Boolean | Returns true if this group is collapsed. |
remove() | void | Removes this group from the sheet, reducing the group depth of the range by
one. |
GroupControlTogglePosition
Properties
Property | Type | Description |
---|---|---|
BEFORE | Enum | The position where the control toggle is before the group (at lower indices). |
AFTER | Enum | The position where the control toggle is after the group (at higher indices). |
InterpolationType
Properties
Property | Type | Description |
---|---|---|
NUMBER | Enum | Use the number as as specific interpolation point for a gradient condition. |
PERCENT | Enum | Use the number as a percentage interpolation point for a gradient condition. |
PERCENTILE | Enum | Use the number as a percentile interpolation point for a gradient condition. |
MIN | Enum | Infer the minimum number as a specific interpolation point for a gradient condition. |
MAX | Enum | Infer the maximum number as a specific interpolation point for a gradient condition. |
LookerDataSourceSpec
Methods
Method | Return type | Brief description |
---|---|---|
copy() | Data | Creates a Data based on this data source's settings. |
get | String | Gets the name of the Looker explore in the model. |
get | String | Gets the URL of the Looker instance. |
get | String | Gets the name of the Looker model in the instance. |
get | Data | Gets the parameters of the data source. |
get | Data | Gets the type of the data source. |
LookerDataSourceSpecBuilder
Methods
Method | Return type | Brief description |
---|---|---|
build() | Data | Builds a data source specification from the settings in this builder. |
copy() | Data | Creates a Data based on this data source's settings. |
get | String | Gets the name of the Looker explore in the model. |
get | String | Gets the URL of the Looker instance. |
get | String | Gets the name of the Looker model in the instance. |
get | Data | Gets the parameters of the data source. |
get | Data | Gets the type of the data source. |
remove | Looker | Removes all the parameters. |
remove | Looker | Removes the specified parameter. |
set | Looker | Sets the explore name in the Looker model. |
set | Looker | Sets the instance URL for Looker. |
set | Looker | Sets the Looker model name in the Looker instance. |
set | Looker | Adds a parameter, or if the parameter with the name exists, updates its source cell for data
source spec builders of type Data . |
NamedRange
Methods
Method | Return type | Brief description |
---|---|---|
get | String | Gets the name of this named range. |
get | Range | Gets the range referenced by this named range. |
remove() | void | Deletes this named range. |
set | Named | Sets/updates the name of the named range. |
set | Named | Sets/updates the range for this named range. |
OverGridImage
Methods
Method | Return type | Brief description |
---|---|---|
assign | Over | Assigns the function with the specified function name to this image. |
get | String | Returns the alt text description for this image. |
get | String | Returns the alt text title for this image. |
get | Range | Returns the cell where an image is anchored. |
get | Integer | Returns the horizontal pixel offset from the anchor cell. |
get | Integer | Returns the vertical pixel offset from the anchor cell. |
get | Integer | Returns the actual height of this image in pixels. |
get | Integer | Returns the inherent height of this image in pixels. |
get | Integer | Returns the inherent height of this image in pixels. |
get | String | Returns the name of the function assigned to this image. |
get | Sheet | Returns the sheet this image appears on. |
get | Integer | Returns the actual width of this image in pixels. |
remove() | void | Deletes this image from the spreadsheet. |
replace(blob) | Over | Replaces this image with the one specified by the provided Blob . |
replace(url) | Over | Replaces this image with the one from the specified URL. |
reset | Over | Resets this image to its inherent dimensions. |
set | Over | Sets the alt-text description for this image. |
set | Over | Sets the alt text title for this image. |
set | Over | Sets the cell where an image is anchored. |
set | Over | Sets the horizontal pixel offset from the anchor cell. |
set | Over | Sets the vertical pixel offset from the anchor cell. |
set | Over | Sets the actual height of this image in pixels. |
set | Over | Sets the actual width of this image in pixels. |
PageProtection
PivotFilter
Methods
Method | Return type | Brief description |
---|---|---|
get | Filter | Returns the filter criteria for this pivot filter. |
get | Pivot | Returns the Pivot that this filter belongs to. |
get | Integer | Returns the number of the source data column this filter operates on. |
get | Data | Returns the data source column the filter operates on. |
remove() | void | Removes this pivot filter from the pivot table. |
set | Pivot | Sets the filter criteria for this pivot filter. |
PivotGroup
Methods
Method | Return type | Brief description |
---|---|---|
add | Pivot | Adds a manual grouping rule for this pivot group. |
are | Boolean | Returns whether labels are displayed as repeated. |
clear | Pivot | Removes any grouping rules from this pivot group. |
clear | Pivot | Removes any sorting applied to this group. |
get | Date | Returns the date-time grouping rule on the pivot group, or null if no date-time
grouping rule is set. |
get | Dimension | Returns whether this is a row or column group. |
get | Pivot | Returns the pivot group limit on the pivot group. |
get | Integer | Returns the index of this pivot group in the current group order. |
get | Pivot | Returns the Pivot which this grouping belongs to. |
get | Integer | Returns the number of the source data column this group summarizes. |
get | Data | Returns the data source column the pivot group operates on. |
hide | Pivot | Hides repeated labels for this grouping. |
is | Boolean | Returns true if the sort is ascending, returns false if the sort order is
descending. |
move | Pivot | Moves this group to the specified position in the current list of row or column groups. |
remove() | void | Removes this pivot group from the table. |
remove | Pivot | Removes the manual grouping rule with the specified group . |
reset | Pivot | Resets the display name of this group in the pivot table to its default value. |
set | Pivot | Sets the date-time grouping rule on the pivot group. |
set | Pivot | Sets the display name of this group in the pivot table. |
set | Pivot | Sets the pivot group limit on the pivot group. |
set | Pivot | Sets a histogram grouping rule for this pivot group. |
show | Pivot | When there is more than one row or column grouping, this method displays this grouping's label for each entry of the subsequent grouping. |
show | Pivot | Sets whether to show total values for this pivot group in the table. |
sort | Pivot | Sets the sort order to be ascending. |
sort | Pivot | Sorts this group by the specified Pivot for the values from the opposite . |
sort | Pivot | Sets the sort order to be descending. |
totals | Boolean | Returns whether total values are currently shown for this pivot group. |
PivotGroupLimit
Methods
Method | Return type | Brief description |
---|---|---|
get | Integer | Gets the count limit on rows or columns in the pivot group. |
get | Pivot | Returns the pivot group the limit belongs to. |
remove() | void | Removes the pivot group limit. |
set | Pivot | Sets the count limit on rows or columns in the pivot group. |
PivotTable
Methods
Method | Return type | Brief description |
---|---|---|
add | Pivot | Creates a new pivot value in the pivot table calculated from the specified formula with
the specified name . |
add | Pivot | Defines a new pivot column grouping in the pivot table. |
add | Pivot | Creates a new pivot filter for the pivot table. |
add | Pivot | Defines a new pivot value in the pivot table with the specified summarize . |
add | Pivot | Defines a new pivot row grouping in the pivot table. |
as | Data | Returns the pivot table as a data source pivot table if the pivot table is linked to a Data , or null otherwise. |
get | Range | Returns the Range representing the cell where this pivot table is anchored. |
get | Pivot | Returns an ordered list of the column groups in this pivot table. |
get | Pivot | Returns an ordered list of the filters in this pivot table. |
get | Pivot | Returns an ordered list of the pivot values in this pivot table. |
get | Pivot | Returns an ordered list of the row groups in this pivot table. |
get | Range | Returns the source data range on which the pivot table is constructed. |
get | Dimension | Returns whether values are displayed as rows or columns. |
remove() | void | Deletes this pivot table. |
set | Pivot | Sets the layout of this pivot table to display values as columns or rows. |
PivotTableSummarizeFunction
Properties
Property | Type | Description |
---|---|---|
CUSTOM | Enum | A custom function, this value is only valid for calculated fields. |
SUM | Enum | The SUM function |
COUNTA | Enum | The COUNTA function |
COUNT | Enum | The COUNT function |
COUNTUNIQUE | Enum | The COUNTUNIQUE function |
AVERAGE | Enum | The AVERAGE function |
MAX | Enum | The MAX function |
MIN | Enum | The MIN function |
MEDIAN | Enum | The MEDIAN function |
PRODUCT | Enum | The PRODUCT function |
STDEV | Enum | The STDEV function |
STDEVP | Enum | The STDEVP function |
VAR | Enum | The VAR function |
VARP | Enum | The VARP function |
PivotValue
Methods
Method | Return type | Brief description |
---|---|---|
get | Pivot | R |