JSON + XSLT?
Sent from my iPhone
On 22 May 2019, at 06:57, Hans Hübner hans.huebner@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 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/