使用 Drive API 在 Google Drive 中创建空电子表格

问题描述

我想在 Google 云端硬盘中创建一个空的 Google 表格(仅使用元数据创建).当我参考 Google SpreadSheet API 文档时,它说要使用DocumentsList API,但它已被弃用,而是要求我使用 Google Drive API.在 Drive API 文档中,我找不到任何创建空工作表的方法.任何人都知道如何做到这一点?

I want to create an empty Google Sheet (created only with metadata) in Google Drive. When I referred to the Google SpreadSheet API documentation, it says to use the DocumentsList API, but it's deprecated and instead asks me to use the Google Drive API. In the Drive API docs, I could not find any way to create an empty Sheet. Anyone have a clue on how to do this?


解决方案

您可以使用 Drive API 通过将 MIME 类型 设置为 application/vnd.google-apps.spreadsheet:

You can do this using the Drive API by setting the MIME type to application/vnd.google-apps.spreadsheet:

在 Python 中执行此操作:

To do this in Python:

from apiclient.discovery import build
service = build('drive', 'v2')

import httplib2
credentials = ... # Obtain OAuth 2.0 credentials
http = credentials.authorize(httplib2.Http())

body = {
  'mimeType': 'application/vnd.google-apps.spreadsheet',
  'title': 'Name of Spreadsheet',
}
file = service.files().insert(body=body).execute(http=http)
# or for version 3 it would be
# file = service.files().create(body=body).execute(http=http)

前往 Google APIs Explorer 试试看!

相关文章