创建链接以从Google云端硬盘下载整个电子表格 [英] Creating a link to download whole spreadsheet from Google Drive

问题描述

我想在Google云端硬盘上为我的电子表格创建下载链接，而我读到了类似的内容:

I want to create download link for my spreadsheet on google drive and I read about something like that:

https://docs.google.com/spreadsheets/d/MY_SPREADSHEET/export?format=csv

但是它只下载第一张纸.我已经读过有关 GID 参数的信息，但是我不想花时间开发一些可以从API获取所有GID的东西，然后下载每张工作表.有没有一种方法可以导致下载整个电子表格的链接?

But it only downloads first sheet. I've read about GID parameter, but I don't want to spend time developing something that will get all GID's from API, and then download every sheet. Is there any way to have one link that leads to download of whole spreadsheet?

推荐答案

您可能希望尝试在

在浏览器中打开您的Google Spreadsheet，将工作表设为公开"(或带有链接的任何人)，并记下共享URL.应该是这样的:

Open your Google Spreadsheet in the browser, make the sheet Public (or Anyone with a link) and make a note of the shared URL. It should be something like this:

https://docs.google.com/spreadsheets/d/FILE_ID/edit?usp=sharing

直接下载链接使用的格式与Google文档类似，并且显示为:

The direct download links use a similar format as Google Documents and will read like:

https://docs.google.com/spreadsheets/d/FILE_ID/export?format=xlsx https://docs.google.com/spreadsheets/d/FILE_ID/export?format=pdf

除此之外，您可能还想尝试在此

In addition to that, you may want to also try using the suggested URL in this SO post and see if it will help.

https://docs.google.com/spreadsheets/u/1/d/${id}/export?format=csv&id=${id}&gid=${gid}

这篇关于创建链接以从Google云端硬盘下载整个电子表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！