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/spreadsheet...D15o2nmleW0k4GKLaJWBzBKtVRo4c/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. Continue reading...
