JSON + XSLT? Sent from my iPhone
> On 22 May 2019, at 06:57, Hans Hübner <hans.hueb...@gmail.com> wrote: > > 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 <luis...@gmail.com>: >> On Wed, May 22, 2019 at 10:36 AM Nick Levine <n...@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/ >>
