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).
- nick
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,
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/
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/
Am Mi., 22. Mai 2019 um 06:03 Uhr schrieb Alexandre Rademaker < arademaker@gmail.com>:
JSON + XSLT?
Sure, it is rather straightforward even: https://www.saxonica.com/papers/xmlprague-2016mhk.pdf
Offtopic, of course :)
-Hans
I didn’t know that, thanks. But you would need a library with XSLT 3.0 support. Does anyone knows about any library that implement the json-to-xml() and xml-to-json() functions? As far as I know, https://common-lisp.net/project/xuriella/ supports XSLT 1.0 only.
Best,
-- Alexandre Rademaker http://arademaker.github.io
On 22 May 2019, at 07:13, Hans Hübner hans.huebner@gmail.com wrote:
Am Mi., 22. Mai 2019 um 06:03 Uhr schrieb Alexandre Rademaker arademaker@gmail.com: JSON + XSLT?
Sure, it is rather straightforward even: https://www.saxonica.com/papers/xmlprague-2016mhk.pdf
Offtopic, of course :)
-Hans
I wrote a hack to pull information from an excel xslx sheet. I used a couple of libraries pulled from quicklisp, first to unzip the file, then to xml-parse it. The specific trick is to decode the document from the word indexes for the shared strings. So if you can save the google sheet as an excel, this technique would work.
wglb
On Wed, May 22, 2019 at 4: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).
- nick
I wrote a whole library for Golang that reads/writes Microsoft ODX XLSX, if you don't need to go down that route, I'd avoid it. Grabbing JSON from google seams like a way simpler way to process data.
So much advice. Thanks, all.
- nick
On 22 May 2019, at 18:53, Geoffrey Teale tealeg@gmail.com wrote:
I wrote a whole library for Golang that reads/writes Microsoft ODX XLSX, if you don't need to go down that route, I'd avoid it. Grabbing JSON from google seams like a way simpler way to process data.
tealeg
On Wed, 22 May 2019 at 16:46, William Lederer william.lederer@gmail.com wrote: I wrote a hack to pull information from an excel xslx sheet. I used a couple of libraries pulled from quicklisp, first to unzip the file, then to xml-parse it. The specific trick is to decode the document from the word indexes for the shared strings. So if you can save the google sheet as an excel, this technique would work.
wglb
On Wed, May 22, 2019 at 4: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).
- nick
-
Alexandre Rademaker -
Geoffrey Teale -
Hans Hübner -
Luís Oliveira -
Nick Levine -
William Lederer