“发布到网络"在Google表格上无法正常工作 [英] "Publish to web" on Google Sheets not working properly

问题描述

根据Google Appstatus的说法，昨天Google云端硬盘发生了故障.同时，我开始从几个发布到Web的XLS和CSV格式的Google表格文件中发布的应用程序中获得错误信息.24小时后，我的团队仍然犯了错误.

当我尝试使用Python阅读公共链接时，QlikView或PowerBI出现错误；当在浏览器中使用它时，它可以正常工作(如果显示html或下载XLS或CSV文件，则显示该文件).当我下载文件时，可以毫无问题地将其加载到应用程序中.

以

为例，该链接是这样的: https://docs.google.com/spreadsheets/d/e/2PACX-1vR-n29UtC60LUE4q0YB0mDW8LNlhychOlCqOv_svzL4tuUfYmTD15o2nmleW0k4GKLaJWBzBKtVRo4c/pub将HTML更改为

奇怪的是，在Python中，当我尝试加载XLSX文件时，它不起作用，但是如果我更改为HTML，它会起作用，如下所示:

#我得到一个错误:将熊猫作为pd导入

  df = pd.read_excel('https://docs.google.com/spreadsheets/d/e/2PACX-1vR-n29UtC60LUE4q0YB0mDW8LNlhychOlCqOv_svzL4tuUfYmTD15o2nmleW0k4KKLaJWBzBls) 

#我没有收到错误:

  df = pd.read_html('https://docs.google.com/spreadsheets/d/e/2PACX-1vR-n29UtC60LUE4q0YB0mDW8LNlhychOlCqOv_svzL4tuUfYmTD15o2nmleW0k4KKLaJWBzls​​) 

已下载的文件已附加.

感谢您的帮助.谢谢.

解决方案

找到的解决方案:确保将已发布的电子表格设置为公开.您还需要在右上角的共享选项中将其公开(绿色按钮)

---

我遇到了同样的问题，但是我从中学到了一些东西.一个已经发布的文件将不起作用，但是如果您发布一个新文件，它将起作用.测试该错误的简便方法也是Google的一个问题，就是打开一个新工作表并编写= ImportFile("PathToAPublishedCsv")您将看到它对于新发布的文件效果很好，但不适用于已经发布的文件.

我试图找到一个可与之聊天的Google支持，但到目前为止还没有运气

html工作的原因是，在获取已经发布的文件上的数据之前，您将获得一个中间页面，这就是一个html页面

Yesterday there was a disruption on Google Drive according to Google Appstatus. At the same time I start getting erros from several apps that READS PUBLISHED TO WEB Google sheet files in XLS and CSV format. 24 hours later my team still got erros.

When I tried to read a public link in Python, QlikView ou PowerBI I got an error; when a use it in browser it works fine (shows the file if html or download XLS ou CSV files). when I download the files I can load then in the application with no problems.

as an example, the link is this: https://docs.google.com/spreadsheets/d/e/2PACX-1vR-n29UtC60LUE4q0YB0mDW8LNlhychOlCqOv_svzL4tuUfYmTD15o2nmleW0k4GKLaJWBzBKtVRo4c/pub?output=xlsx (you can change XLSX for HTML or CSV to change the format).

Strange thing is that in Python when I try to load the XLSX file it does not work, however it does if I change to HTML, as below:

#I GET AN ERROR: import pandas as pd

df = pd.read_excel('https://docs.google.com/spreadsheets/d/e/2PACX-1vR-n29UtC60LUE4q0YB0mDW8LNlhychOlCqOv_svzL4tuUfYmTD15o2nmleW0k4GKLaJWBzBKtVRo4c/pub?output=xlsx') 

#I DO NOT GET AN ERROR:

df = pd.read_html('https://docs.google.com/spreadsheets/d/e/2PACX-1vR-n29UtC60LUE4q0YB0mDW8LNlhychOlCqOv_svzL4tuUfYmTD15o2nmleW0k4GKLaJWBzBKtVRo4c/pub?output=xlsx')

The downloaded file is attached.

Any help is appreciated. Thanks.

解决方案

Solution found : Make sure to set the published spreadsheet as public. you also need to make it public in the sharing options at the top right (green button)

---

I got the same issue, but I learned a few things around it. An already published file will not work, but if you publish a new file, it will. Easy way to test the bug is also an issue for google is to open a new sheet and write =ImportFile("PathToAPublishedCsv") you will see it works fine for newly published, but not for already published files.

I have tried to find a google support to chat with, but no luck so far

The reason for the html working is that you are getting an inbetween page before you get to the data on the already published files, and that is an html page

这篇关于“发布到网络"在Google表格上无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！