Reading spreadsheets

Hans Hübner hans.huebner at gmail.com
Wed May 22 09:57:11 UTC 2019


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/bdf88a3b/attachment.html>


More information about the pro mailing list