<h3>如何使用Python将值附加到Google电子表格。</h3>
<ol>
<li><p>按照<a href="https://developers.google.com/sheets/api/quickstart/python" rel="nofollow noreferrer">quickstart</a>进行设置。确保您完全按照所有步骤操作!对于开始使用API的每个项目,您都需要这样做,因此您最好按照此处的说明进行操作。确保在继续之前获得预期的输出</p>
</li>
<li><p>然后,您可以修改快速启动,使获取<code>service</code>成为一个单独的函数:</p>
</li>
</ol>
<pre class="lang-py prettyprint-override"><code>def getService():
creds = None
if os.path.exists('token.json'):
creds = Credentials.from_authorized_user_file('token.json', SCOPES)
if not creds or not creds.valid:
if creds and creds.expired and creds.refresh_token:
creds.refresh(Request())
else:
flow = InstalledAppFlow.from_client_secrets_file(
'credentials.json', SCOPES)
creds = flow.run_local_server(port=0)
with open('token.json', 'w') as token:
token.write(creds.to_json())
return build('sheets', 'v4', credentials=creds)
</code></pre>
<ol start=“3”>
<li>一旦您拥有了服务,就可以调用Sheets API。例如:</li>
</ol>
<pre class="lang-py prettyprint-override"><code>service = getService()
appendValues(service)
values = [
[time, todayMaxProfit, todayMaxLoss, pl, len(orderList), int(orderList[0][4]+orderList[1][4])]
]
body = {'values': values}
result = service.spreadsheets().values().append(
spreadsheetId="13rdolwpUD4h4RTuEgn1QbtgPMpJiZGMFubdh4loAfNQ", range="Sheet1!A1",
valueInputOption="RAW", body=body).execute()
</code></pre>
<p>请注意<code>values</code>必须采用的格式是二维列表:</p>
<pre><code>[
[A1, B1, C1],
[A2, B2, C2]
]
</code></pre>
<p>使用<a href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append" rel="nofollow noreferrer">^{<cd3>}</a>方法,只需按原样将行添加到工作表的末尾。<code>append</code>有几个参数:</p>
<ul>
<li>spreadsheetId—要向其添加值的电子表格的<code>id</code></li>
<li>范围-找到数据的大致范围。Sheets API将尝试评估工作表中的数据,并猜测最后一行在哪里。通常,如果一个表从<code>A1</code>到底部填充了数据,则可以将其保留为<code>A1</code>,或者如果有标题或空格,可以保留为<code>C5</code>。其思想是将API指向要附加到的数据集合</李>
<li>valueInputOption-这通常可以保留为“原始”,在传递数据时只插入数据</李>
<li>主体,这里有二维数据列表</李>
</ul>
<h3>参考文献</h3>
<ul>
<li><a href="https://developers.google.com/sheets/api/guides/values" rel="nofollow noreferrer">Guide to Reading and Writing Values</a></li>
<li><a href="https://developers.google.com/sheets/api/quickstart/python" rel="nofollow noreferrer">Quickstart</a></li>
<li><a href="https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append" rel="nofollow noreferrer">^{<cd3>}</a></li>
</ul>