擅长:python、mysql、java
<p>一定要遵守OAuth的所有同意。
<a href="https://developers.google.com/sheets/api/quickstart/js" rel="nofollow noreferrer">https://developers.google.com/sheets/api/quickstart/js</a></p>
<p>相关文件在这里。
<a href="https://developers.google.com/sheets/api/samples/rowcolumn#append_empty_rows_or_columns" rel="nofollow noreferrer">https://developers.google.com/sheets/api/samples/rowcolumn#append_empty_rows_or_columns</a></p>
<pre><code>function InsertNewCol() {
var requests = [];
requests.push({
"appendDimension": {
"range": {
"dimension": "COLUMNS",
"length": 3
}
}
});
gapi.client.sheets.spreadsheets.batchUpdate({
spreadsheetId: 'YourSheetID',
requests: requests
}).then(function(response) {
console.log(response);
});}
</code></pre>