"Publish to web" on Google Sheets not working properly

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.



Read more here: https://stackoverflow.com/questions/64902111/publish-to-web-on-google-sheets-not-working-properly

Content Attribution

This content was originally published by Fabiano Castello at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: