谷歌电子表格直接下载链接只有一个工作表为excel [英] Google spreadsheet direct download link for only ONE sheet as excel
问题描述
我想知道是否有可能只下载谷歌电子表格的表格1作为excel?我已经看到很少的SO帖子显示了将excel导出为整个表格的方法,但我只需要导出一个表格。这是否可能?如果是的话,怎么样?
您可以使用'GID'下载特定的表格。
每张工作表都有一个GID,您可以在
电子表格的网址中找到特定工作表的GID。然后,您可以使用此链接下载特定工作表 -
https://docs.google.com/spreadsheets/d/ / export?format = xlsx& gid =
例如:
https://docs.google.com/spreadsheets/d
$ bKEY是电子表格的唯一ID。
blockquote>
I was wondering if its possible to download say only sheet 1 of a google spreadsheet as excel? I have seen few SO posts that show the method to export the WHOLE sheet as excel, but I need to just export one sheet. Is it at all possible? and if yes, how?
解决方案You can download a specific sheet using the 'GID'.
Each sheet has a GID, you can find GID of specific sheet in the URL of spreadsheet. Then you can use this link to download specific sheet -
https://docs.google.com/spreadsheets/d//export?format=xlsx&gid=
KEY is the unique ID of the spreadsheet.
这篇关于谷歌电子表格直接下载链接只有一个工作表为excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!