Reading spreadsheets

[Alexandre Rademaker]

JSON + XSLT? 

Sent from my iPhone

> On 22 May 2019, at 06:57, Hans Hübner <hans.huebner at 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 at gmail.com>:
>> On Wed, May 22, 2019 at 10:36 AM Nick Levine <nick at 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/
>> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.common-lisp.net/pipermail/pro/attachments/20190522/7d092f9c/attachment.html>