将工作表从一个电子表格复制到另一个电子表格
是否可以使用 gdata API 将电子表格或工作表从一个电子表格复制到另一个电子表格？ 现在，我将所有单元格从一个工作表复制到另一个工作表。 每个请求一个单元格。 太慢了。 我读到“细胞批处理”并编写了这段代码：
src_key = 'rFQqEnFWuR6qoU2HEfdVuTw'; dst_key = 'rPCVJ80MHt7K2EVlXNqytLQ'
sheetcl = gdata.spreadsheet.service.SpreadsheetsService('[email protected]','p')
dcs = gdata.docs.service.DocsService('[email protected]', 'p')
src_worksheets = sheetcl.GetWorksheetsFeed(src_key)
dst_worksheets = sheetcl.GetWorksheetsFeed(dst_key)
for src_worksheet, dst_worksheet in zip(src_worksheets.entry, dst_worksheets.entry):
sheet_id = src_worksheet.id.text.split('/')[-1]
dst_sheet_id = dst_worksheet.id.text.split('/')[-1]
cells_feed = sheetcl.GetCellsFeed(src_key, sheet_id)
dst_cells_feed = sheetcl.GetCellsFeed(dst_key, dst_sheet_id)
for cell in cells_feed.entry:
dst_cells_feed.AddInsert(cell)
sheetcl.ExecuteBatch(dst_cells_feed, dst_cells_feed.GetBatchLink().href)
但它不起作用。 我认为原因是内循环中的每个单元格都有其 id，其中包含电子表格 id：
>>> cell.id.text
'http://spreadsheets.google.com/feeds/cells/rFQqEnFWuR6qoU2HEfdVuTw/default/private/full/R1C1'
>>>
Is it possible to copy spreadsheets with gdata API or worksheets from one spreadsheet to other? For now i copy all cells from one worksheet to another. One cell per request. It is too slow. I read about "cell batch processing" and write this code:
src_key = 'rFQqEnFWuR6qoU2HEfdVuTw'; dst_key = 'rPCVJ80MHt7K2EVlXNqytLQ'
sheetcl = gdata.spreadsheet.service.SpreadsheetsService('[email protected]','p')
dcs = gdata.docs.service.DocsService('[email protected]', 'p')
src_worksheets = sheetcl.GetWorksheetsFeed(src_key)
dst_worksheets = sheetcl.GetWorksheetsFeed(dst_key)
for src_worksheet, dst_worksheet in zip(src_worksheets.entry, dst_worksheets.entry):
sheet_id = src_worksheet.id.text.split('/')[-1]
dst_sheet_id = dst_worksheet.id.text.split('/')[-1]
cells_feed = sheetcl.GetCellsFeed(src_key, sheet_id)
dst_cells_feed = sheetcl.GetCellsFeed(dst_key, dst_sheet_id)
for cell in cells_feed.entry:
dst_cells_feed.AddInsert(cell)
sheetcl.ExecuteBatch(dst_cells_feed, dst_cells_feed.GetBatchLink().href)
But it doesn't work. As I suppose reason is that each cell in inner loop has its id which consist of spreadsheet_id:
>>> cell.id.text
'http://spreadsheets.google.com/feeds/cells/rFQqEnFWuR6qoU2HEfdVuTw/default/private/full/R1C1'
>>>
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可能应该使用单元格范围查询来一次获取整行，然后插入行 在目标电子表格中。
You probably should be using a cell range query to get a whole row at a time, then inserting rows in the target spreadsheet.