谷歌电子表格直接下载链接只有一个工作表为excel [英] Google spreadsheet direct download link for only ONE sheet as excel

查看:998
本文介绍了谷歌电子表格直接下载链接只有一个工作表为excel的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想知道是否有可能只下载谷歌电子表格的表格1作为excel?我已经看到很少的SO帖子显示了将excel导出为整个表格的方法,但我只需要导出一个表格。这是否可能?如果是的话,怎么样?

解决方案


您可以使用'GID'下载特定的表格。

每张工作表都有一个GID,您可以在
电子表格的网址中找到特定工作表的GID。然后,您可以使用此链接下载特定工作表 -



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



例如:
https://docs.google.com/spreadsheets/d
$ b

KEY是电子表格的唯一ID。

blockquote>

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

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=

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

KEY is the unique ID of the spreadsheet.

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

这篇关于谷歌电子表格直接下载链接只有一个工作表为excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆