pub struct Request {Show 69 fields
pub add_banding: Option<AddBandingRequest>,
pub add_chart: Option<AddChartRequest>,
pub add_conditional_format_rule: Option<AddConditionalFormatRuleRequest>,
pub add_data_source: Option<AddDataSourceRequest>,
pub add_dimension_group: Option<AddDimensionGroupRequest>,
pub add_filter_view: Option<AddFilterViewRequest>,
pub add_named_range: Option<AddNamedRangeRequest>,
pub add_protected_range: Option<AddProtectedRangeRequest>,
pub add_sheet: Option<AddSheetRequest>,
pub add_slicer: Option<AddSlicerRequest>,
pub add_table: Option<AddTableRequest>,
pub append_cells: Option<AppendCellsRequest>,
pub append_dimension: Option<AppendDimensionRequest>,
pub auto_fill: Option<AutoFillRequest>,
pub auto_resize_dimensions: Option<AutoResizeDimensionsRequest>,
pub cancel_data_source_refresh: Option<CancelDataSourceRefreshRequest>,
pub clear_basic_filter: Option<ClearBasicFilterRequest>,
pub copy_paste: Option<CopyPasteRequest>,
pub create_developer_metadata: Option<CreateDeveloperMetadataRequest>,
pub cut_paste: Option<CutPasteRequest>,
pub delete_banding: Option<DeleteBandingRequest>,
pub delete_conditional_format_rule: Option<DeleteConditionalFormatRuleRequest>,
pub delete_data_source: Option<DeleteDataSourceRequest>,
pub delete_developer_metadata: Option<DeleteDeveloperMetadataRequest>,
pub delete_dimension: Option<DeleteDimensionRequest>,
pub delete_dimension_group: Option<DeleteDimensionGroupRequest>,
pub delete_duplicates: Option<DeleteDuplicatesRequest>,
pub delete_embedded_object: Option<DeleteEmbeddedObjectRequest>,
pub delete_filter_view: Option<DeleteFilterViewRequest>,
pub delete_named_range: Option<DeleteNamedRangeRequest>,
pub delete_protected_range: Option<DeleteProtectedRangeRequest>,
pub delete_range: Option<DeleteRangeRequest>,
pub delete_sheet: Option<DeleteSheetRequest>,
pub delete_table: Option<DeleteTableRequest>,
pub duplicate_filter_view: Option<DuplicateFilterViewRequest>,
pub duplicate_sheet: Option<DuplicateSheetRequest>,
pub find_replace: Option<FindReplaceRequest>,
pub insert_dimension: Option<InsertDimensionRequest>,
pub insert_range: Option<InsertRangeRequest>,
pub merge_cells: Option<MergeCellsRequest>,
pub move_dimension: Option<MoveDimensionRequest>,
pub paste_data: Option<PasteDataRequest>,
pub randomize_range: Option<RandomizeRangeRequest>,
pub refresh_data_source: Option<RefreshDataSourceRequest>,
pub repeat_cell: Option<RepeatCellRequest>,
pub set_basic_filter: Option<SetBasicFilterRequest>,
pub set_data_validation: Option<SetDataValidationRequest>,
pub sort_range: Option<SortRangeRequest>,
pub text_to_columns: Option<TextToColumnsRequest>,
pub trim_whitespace: Option<TrimWhitespaceRequest>,
pub unmerge_cells: Option<UnmergeCellsRequest>,
pub update_banding: Option<UpdateBandingRequest>,
pub update_borders: Option<UpdateBordersRequest>,
pub update_cells: Option<UpdateCellsRequest>,
pub update_chart_spec: Option<UpdateChartSpecRequest>,
pub update_conditional_format_rule: Option<UpdateConditionalFormatRuleRequest>,
pub update_data_source: Option<UpdateDataSourceRequest>,
pub update_developer_metadata: Option<UpdateDeveloperMetadataRequest>,
pub update_dimension_group: Option<UpdateDimensionGroupRequest>,
pub update_dimension_properties: Option<UpdateDimensionPropertiesRequest>,
pub update_embedded_object_border: Option<UpdateEmbeddedObjectBorderRequest>,
pub update_embedded_object_position: Option<UpdateEmbeddedObjectPositionRequest>,
pub update_filter_view: Option<UpdateFilterViewRequest>,
pub update_named_range: Option<UpdateNamedRangeRequest>,
pub update_protected_range: Option<UpdateProtectedRangeRequest>,
pub update_sheet_properties: Option<UpdateSheetPropertiesRequest>,
pub update_slicer_spec: Option<UpdateSlicerSpecRequest>,
pub update_spreadsheet_properties: Option<UpdateSpreadsheetPropertiesRequest>,
pub update_table: Option<UpdateTableRequest>,
}Expand description
A single kind of update to apply to a spreadsheet.
This type is not used in any activity, and only used as part of another schema.
Fields§
§add_banding: Option<AddBandingRequest>Adds a new banded range
add_chart: Option<AddChartRequest>Adds a chart.
add_conditional_format_rule: Option<AddConditionalFormatRuleRequest>Adds a new conditional format rule.
add_data_source: Option<AddDataSourceRequest>Adds a data source.
add_dimension_group: Option<AddDimensionGroupRequest>Creates a group over the specified range.
add_filter_view: Option<AddFilterViewRequest>Adds a filter view.
add_named_range: Option<AddNamedRangeRequest>Adds a named range.
add_protected_range: Option<AddProtectedRangeRequest>Adds a protected range.
add_sheet: Option<AddSheetRequest>Adds a sheet.
add_slicer: Option<AddSlicerRequest>Adds a slicer.
add_table: Option<AddTableRequest>Adds a table.
append_cells: Option<AppendCellsRequest>Appends cells after the last row with data in a sheet.
append_dimension: Option<AppendDimensionRequest>Appends dimensions to the end of a sheet.
auto_fill: Option<AutoFillRequest>Automatically fills in more data based on existing data.
auto_resize_dimensions: Option<AutoResizeDimensionsRequest>Automatically resizes one or more dimensions based on the contents of the cells in that dimension.
cancel_data_source_refresh: Option<CancelDataSourceRefreshRequest>Cancels refreshes of one or multiple data sources and associated dbobjects.
clear_basic_filter: Option<ClearBasicFilterRequest>Clears the basic filter on a sheet.
copy_paste: Option<CopyPasteRequest>Copies data from one area and pastes it to another.
create_developer_metadata: Option<CreateDeveloperMetadataRequest>Creates new developer metadata
cut_paste: Option<CutPasteRequest>Cuts data from one area and pastes it to another.
delete_banding: Option<DeleteBandingRequest>Removes a banded range
delete_conditional_format_rule: Option<DeleteConditionalFormatRuleRequest>Deletes an existing conditional format rule.
delete_data_source: Option<DeleteDataSourceRequest>Deletes a data source.
delete_developer_metadata: Option<DeleteDeveloperMetadataRequest>Deletes developer metadata
delete_dimension: Option<DeleteDimensionRequest>Deletes rows or columns in a sheet.
delete_dimension_group: Option<DeleteDimensionGroupRequest>Deletes a group over the specified range.
delete_duplicates: Option<DeleteDuplicatesRequest>Removes rows containing duplicate values in specified columns of a cell range.
delete_embedded_object: Option<DeleteEmbeddedObjectRequest>Deletes an embedded object (e.g, chart, image) in a sheet.
delete_filter_view: Option<DeleteFilterViewRequest>Deletes a filter view from a sheet.
delete_named_range: Option<DeleteNamedRangeRequest>Deletes a named range.
delete_protected_range: Option<DeleteProtectedRangeRequest>Deletes a protected range.
delete_range: Option<DeleteRangeRequest>Deletes a range of cells from a sheet, shifting the remaining cells.
delete_sheet: Option<DeleteSheetRequest>Deletes a sheet.
delete_table: Option<DeleteTableRequest>A request for deleting a table.
duplicate_filter_view: Option<DuplicateFilterViewRequest>Duplicates a filter view.
duplicate_sheet: Option<DuplicateSheetRequest>Duplicates a sheet.
find_replace: Option<FindReplaceRequest>Finds and replaces occurrences of some text with other text.
insert_dimension: Option<InsertDimensionRequest>Inserts new rows or columns in a sheet.
insert_range: Option<InsertRangeRequest>Inserts new cells in a sheet, shifting the existing cells.
merge_cells: Option<MergeCellsRequest>Merges cells together.
move_dimension: Option<MoveDimensionRequest>Moves rows or columns to another location in a sheet.
paste_data: Option<PasteDataRequest>Pastes data (HTML or delimited) into a sheet.
randomize_range: Option<RandomizeRangeRequest>Randomizes the order of the rows in a range.
refresh_data_source: Option<RefreshDataSourceRequest>Refreshes one or multiple data sources and associated dbobjects.
repeat_cell: Option<RepeatCellRequest>Repeats a single cell across a range.
set_basic_filter: Option<SetBasicFilterRequest>Sets the basic filter on a sheet.
set_data_validation: Option<SetDataValidationRequest>Sets data validation for one or more cells.
sort_range: Option<SortRangeRequest>Sorts data in a range.
text_to_columns: Option<TextToColumnsRequest>Converts a column of text into many columns of text.
trim_whitespace: Option<TrimWhitespaceRequest>Trims cells of whitespace (such as spaces, tabs, or new lines).
unmerge_cells: Option<UnmergeCellsRequest>Unmerges merged cells.
update_banding: Option<UpdateBandingRequest>Updates a banded range
update_borders: Option<UpdateBordersRequest>Updates the borders in a range of cells.
update_cells: Option<UpdateCellsRequest>Updates many cells at once.
update_chart_spec: Option<UpdateChartSpecRequest>Updates a chart’s specifications.
update_conditional_format_rule: Option<UpdateConditionalFormatRuleRequest>Updates an existing conditional format rule.
update_data_source: Option<UpdateDataSourceRequest>Updates a data source.
update_developer_metadata: Option<UpdateDeveloperMetadataRequest>Updates an existing developer metadata entry
update_dimension_group: Option<UpdateDimensionGroupRequest>Updates the state of the specified group.
update_dimension_properties: Option<UpdateDimensionPropertiesRequest>Updates dimensions’ properties.
update_embedded_object_border: Option<UpdateEmbeddedObjectBorderRequest>Updates an embedded object’s border.
update_embedded_object_position: Option<UpdateEmbeddedObjectPositionRequest>Updates an embedded object’s (e.g. chart, image) position.
update_filter_view: Option<UpdateFilterViewRequest>Updates the properties of a filter view.
update_named_range: Option<UpdateNamedRangeRequest>Updates a named range.
update_protected_range: Option<UpdateProtectedRangeRequest>Updates a protected range.
update_sheet_properties: Option<UpdateSheetPropertiesRequest>Updates a sheet’s properties.
update_slicer_spec: Option<UpdateSlicerSpecRequest>Updates a slicer’s specifications.
update_spreadsheet_properties: Option<UpdateSpreadsheetPropertiesRequest>Updates the spreadsheet’s properties.
update_table: Option<UpdateTableRequest>Updates a table.