我想问一个与此相关的问题:Is there a way to autofit a column in Google Sheets using gspread API for Python?
创建新工作表时,第一张工作表或“sheet1”的gid为:edit#gid=0
每次创建新图纸时都会发生这种情况。只有在添加新工作表“sheet2”时,才会得到一张带有一些实际数字的工作表gid,例如:12345
spreadsheetName = "###" # Please set Spreadsheet name.
sheetName = "###" # Please set sheet name.
ss = client.open(spreadsheetName)
sheetId = ss.worksheet(sheetName)._properties['sheetId']
body = {
"requests": [
{
"autoResizeDimensions": {
"dimensions": {
"sheetId": sheetId,
"dimension": "COLUMNS",
"startIndex": 0, # Please set the column index.
"endIndex": 2 # Please set the column index.
}
}
}
]
}
res = ss.batch_update(body)
问题是“sheetId”:只接受整数。那么如何给参数“sheetId”对应的值“edit#gid=0”?如果运行上面的代码,则会出现整数:0
谢谢大家!
目前没有回答
相关问题 更多 >
编程相关推荐