ios - 如何使用 Sheets API v4 在 Swift 4 中创建新的 Google 表格

Question

我不知道如何使用 Sheets API 在 Swift 4 中创建新的 Google 表格。我还希望稍后在我的代码中使用相同的 Google 工作表，因此我需要它返回电子表格 ID 的值。这是我目前所拥有的。

func createNewSheet() {

    let url = NSURL(string: "https://sheets.googleapis.com/v4/spreadsheets")

    let task = URLSession.shared.dataTask(with: url! as URL) {
        (data, response, error) in
        print(NSString(data: data!, encoding: String.Encoding.utf8.rawValue)!)
    }
    task.resume()
    print (task)
}

Answer 1

有一个 Add a Sheet guide来自文档:

The following spreadsheets.batchUpdate request adds a sheet to a spreadsheet, while also setting the title, size, and tab color. This request returns an AddSheetResponse, consisting of an object with the created sheet's properties (such as its sheetId).

The request protocol is shown below. The Updating Spreadsheets guide shows how to implement a batch update in different languages using the Google API client libraries.

POST https://sheets.googleapis.com/v4/spreadsheets/spreadsheetId:batchUpdate
{
  "requests": [
    {
      "addSheet": {
        "properties": {
          "title": "Deposits",
          "gridProperties": {
            "rowCount": 20,
            "columnCount": 12
          },
          "tabColor": {
            "red": 1.0,
            "green": 0.3,
            "blue": 0.4
          }
        }
      }
    }
  ]
}