Googlesheets Delete Dimension

Tool to delete specified rows or columns from a sheet in a Google Spreadsheet. Use when you need to remove a range of rows or columns.

料金

無料 Action

統合支払い

現在未対応

• sheet_idinteger
  The unique numeric ID of the sheet (not the index/position). This ID is assigned by Google Sheets and does not change when sheets are reordered. Use GOOGLESHEETS_GET_SPREADSHEET_INFO to find the sheet ID, or use sheet_name instead. Either sheet_id or sheet_name must be provided.
• dimensionstring
  The dimension to delete (ROWS or COLUMNS).
• end_indexinteger
  The zero-based end index of the range to delete, exclusive. Must be greater than start_index and at most equal to the sheet's current row/column count. Note: Cannot delete all rows or columns from a sheet - at least one row and one column must remain.
• sheet_namestring
  The name/title of the sheet from which to delete the dimension. Using sheet_name is recommended as it's more intuitive than sheet_id. Either sheet_id or sheet_name must be provided.
• start_indexinteger
  The zero-based start index of the range to delete, inclusive. Must be less than end_index and within the sheet's current row/column count. Note: Cannot delete all rows or columns from a sheet - at least one row and one column must remain.
• spreadsheet_idstring

  必須
  The ID of the spreadsheet.
• response_rangesarray
  Limits the ranges of cells included in the response spreadsheet.
• delete_dimension_requestobject
  The details for the delete dimension request object.
• response_include_grid_databoolean
  True if grid data should be returned. This parameter is ignored if a field mask was set in the request.
• include_spreadsheet_in_responseboolean
  Determines if the update response should include the spreadsheet resource.

• data

  必須
  Data from the action execution
• errorstring
  Error if any occurred during the execution of the action
• successfulboolean

  必須
  Whether or not the action execution was successful or not

検証済みの関連ユースケースはまだリンクされていません。