Google sheets can also be retrieved in JSON format, which is what we use to process them with XSLT. -Hans Am Mi., 22. Mai 2019 um 05:45 Uhr schrieb Luís Oliveira <luismbo@gmail.com>:
On Wed, May 22, 2019 at 10:36 AM Nick Levine <nick@nicklevine.org> wrote:
Has anyone tried reading a google spreadsheet from lisp (Allegro)? Searching produced a couple of libraries for this, and neither of them compiled cleanly (which is not where I wanted to spend my morning).
Would downloading the speadsheet in CSV format help or do you need to access formulas, mark-up, etc? The CSV URL would be
https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name} and then you could use one of the csv libraries.
Cheers,
-- Luís Oliveira http://kerno.org/~luis/