google-sheets - 谷歌电子表格直接下载链接只有一张 Excel 表格

Question

我想知道是否可以将 Google 电子表格的第 1 张表下载为 excel？我见过很少有 SO 帖子显示将整个工作表导出为 excel 的方法，但我只需要导出一张工作表。有可能吗？如果是，如何？

Answer 1

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=

ex: https://docs.google.com/spreadsheets/d/1D5vzPaOJOx402RAEF41235qQTOs28_M51ee5glzPzj0/export?format=xlsx&gid=1990092150

KEY is the unique ID of the spreadsheet.

来源: https://www.quora.com/How-do-I-download-just-one-sheet-from-google-spreadsheet/answer/Ranjith-Kumar-339?srid=2YCg