22 May
2019
22 May
'19
11:57 a.m.
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/%7Bkey%7D/gviz/tq?tqx=out:csv&she... and then you could use one of the csv libraries.
Cheers,
-- Luís Oliveira http://kerno.org/~luis/