I have a script that writes with no issue into a Google Sheets in Google Drive, and into multiple tabs within the Google Sheets. I then come into an issue when importing that into Tableau due to its size, but if I download said file as excel and reupload into Google Drive as Excel instead of Google Sheets, Tableau can read it no problem. The issue is that my script wont recognize the file if it's an .xlsx file instead of a plain google sheets. import pygsheets . . . #Open GS sh = gc.open(nombreHoja) wks = sh[0] #Empty GS wks.clear() #Update GS from cell A1 wks.set_dataframe(df,(1,1), extend = True) I am getting the following error: error al cargar gs Could not find a spreadsheet with title GS_AGUAS_PRUEBA.xlsx. Can someone please tell me if there is a way to write into an excel withing google sheets? Continue reading...
