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 <[email protected]>: > On Wed, May 22, 2019 at 10:36 AM Nick Levine <[email protected]> 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/ > >
