gws-sheets

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

sheets (v4)

PREREQUISITE: Read
../gws-shared/SKILL.md
for auth, global flags, and security rules. If missing, run
gws generate-skills
to create it.

bash

gws sheets <resource> <method> [flags]

前置要求： 请阅读
../gws-shared/SKILL.md
了解认证、全局标志和安全规则。如果该文件缺失，请运行
gws generate-skills
命令创建它。

bash

gws sheets <resource> <method> [flags]

Helper Commands

辅助命令

Command	Description
`+append`	Append a row to a spreadsheet
`+read`	Read values from a spreadsheet

命令	描述
`+append`	向电子表格追加一行
`+read`	读取电子表格中的值

API Resources

API 资源

spreadsheets

```
batchUpdate
```
— Applies one or more updates to the spreadsheet. Each request is validated before being applied. If any request is not valid then the entire request will fail and nothing will be applied. Some requests have replies to give you some information about how they are applied. The replies will mirror the requests. For example, if you applied 4 updates and the 3rd one had a reply, then the response will have 2 empty replies, the actual reply, and another empty reply, in that order.
- ```
create
```
  — Creates a spreadsheet, returning the newly created spreadsheet.
- ```
get
```
  — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. By default, data within grids is not returned. You can include grid data in one of 2 ways: * Specify a field mask listing your desired fields using the
```
fields
```
  URL parameter in HTTP * Set the includeGridData URL parameter to true.
- ```
getByDataFilter
```
  — Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID. For more information, see Read, write, and search metadata. This method differs from GetSpreadsheet in that it allows selecting which subsets of spreadsheet data to return by specifying a dataFilters parameter. Multiple DataFilters can be specified.
- ```
developerMetadata
```
  — Operations on the 'developerMetadata' resource
- ```
sheets
```
  — Operations on the 'sheets' resource
- ```
values
```
  — Operations on the 'values' resource

```
batchUpdate
```
— 对电子表格应用一个或多个更新。每个请求在应用前都会被验证。如果任何请求无效，整个请求将失败，且不会应用任何更改。部分请求会返回回复，告知您它们的应用情况。回复将与请求一一对应。例如，如果您应用了4个更新，其中第3个有回复，那么响应将包含2个空回复、实际回复和另一个空回复，顺序与请求一致。
- ```
create
```
  — 创建一个电子表格，返回新创建的电子表格。
- ```
get
```
  — 返回指定ID的电子表格。调用者必须指定电子表格ID。默认情况下，不会返回网格中的数据。您可以通过以下两种方式之一包含网格数据：* 使用HTTP请求中的
```
fields
```
  URL参数指定包含所需字段的字段掩码 * 将includeGridData URL参数设置为true。
- ```
getByDataFilter
```
  — 返回指定ID的电子表格。调用者必须指定电子表格ID。更多信息，请参阅读取、写入和搜索元数据。此方法与GetSpreadsheet的不同之处在于，它允许通过指定dataFilters参数来选择要返回的电子表格数据子集。可以指定多个DataFilter。
- ```
developerMetadata
```
  — 对'developerMetadata'资源的操作
- ```
sheets
```
  — 对'sheets'资源的操作
- ```
values
```
  — 对'values'资源的操作

Discovering Commands

命令探索

Before calling any API method, inspect it:

bash

undefined

在调用任何API方法之前，请先查看它：

bash

undefined

Browse resources and methods

浏览资源和方法

gws sheets --help

Inspect a method's required params, types, and defaults

查看方法的必填参数、类型和默认值

gws schema sheets.<resource>.<method>


Use `gws schema` output to build your `--params` and `--json` flags.

gws schema sheets.<resource>.<method>


使用`gws schema`的输出来构建您的`--params`和`--json`标志。