You need to take xlsx from a public link from Google Docs and read certain parameters. How to get xlsx yourself? If there is, show a working example.

  • They say that you can communicate with the Google table as with . CSV - s976
  • Yes, but here they say that the URL format has changed a bit. - s976

1 answer 1

Currently, getting a public file from Google Docs is not a problem.

A regular public viewing link has the format

 "https://drive.google.com/open?id=1tGgG0G-bXyK_pyaLJ-zRNfHloWxHrVOsOAHofatjYiw"

Take the id parameter from it and substitute it into this link.

 "https://docs.google.com/spreadsheets/d/{id}/export?format=xlsx&id={id}"

On it we get the required xlsx, which can be saved to a file or immediately parsed.