Google 电子表格直接下载链接，仅适用于 1 张 Excel 表格 [英] Google spreadsheet direct download link for only ONE sheet as excel

问题描述

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

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?

推荐答案

您可以使用GID"下载特定工作表.

You can download a specific sheet using the 'GID'.

每张sheet都有一个GID，你可以在网址中找到具体sheet的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?格式=xlsx&gid=

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

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

KEY 是电子表格的唯一 ID.

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

这篇关于Google 电子表格直接下载链接，仅适用于 1 张 Excel 表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！