未知名称“update_sheet_properties”

Question

我正在使用googleclientapythonv4并尝试使用以下代码更新工作表的属性

for sheet in result.get('sheets', ''):
    sheetId = (sheet.get("properties", {}).get("sheetId", 0))

    batch_request = {
      "requests": [
          {
              "UpdateSheetProperties": {
                  "properties": {
                      "sheetId": sheetId,
                      "gridProperties": {
                          "rowCount": 2000,
                          "columnCount": 4,
                      }
                  }
              }
          }
      ],
    }
    result = service.spreadsheets().batchUpdate(spreadsheetId=spreadsheetId, body=batch_request).execute()

运行脚本时，出现以下错误

json returned "Invalid JSON payload received. Unknown name "update_sheet_properties" at 'requests[0]': Cannot find field."

---

我做错什么了？在

Answer 1

我发现了错误

首先这应该是

"updateSheetProperties": {

而不是

^{pr2}$

我还需要有下面的一行

"fields" : "gridProperties(rowCount, columnCount)"

实际代码应该是

 for sheet in result.get('sheets', ''):
        sheetId = (sheet.get("properties", {}).get("sheetId", 0))

        batch_request = {
            "requests": [
                {
                    "updateSheetProperties": {
                        "properties": {
                            "sheetId": sheetId,
                            "gridProperties": {
                                "rowCount": 2000,
                                "columnCount": 4,
                            }
                        },
                        "fields" : "gridProperties(rowCount, columnCount)"
                    }
                }
            ],
        }
        result = service.spreadsheets().batchUpdate(spreadsheetId=spreadsheetId, body=batch_request).execute()

杰伊