4 ms·

I looked through the four documentation links on the right and was unable to find out how to cat a Google spreadsheet as anything consumable by the shell. I too

by sprayk 12y ago

I looked through the four documentation links on the right and was unable to find out how to cat a Google spreadsheet as anything consumable by the shell. I took a guess and tried cat -o gdrive.fmt=txt and csv, but those were not fruitful. Is this possible currently? edit: found mimeMap.js and saw tsv was an option. That didn't work either.

tubelite 12y ago
IIRC the Drive API does not support those conversion options. The way forward would be for an xlsx parsing JS library to convert it into CSV or a stream of Javascript objects. I didn't find any GPL-compatible library last time I checked. See https://developers.google.com/drive/web/manage-downloads https://developers.google.com/drive/web/manage-downloads for a list of export format possibilities. For spreadsheets, the only options are xlsx, odt and pdf.
- deleted 12y ago
  [deleted]
- fiatjaf 12y ago
  Google Drive document can be embedded as iframes. Wouldn't this solve this problem? Here's a proof: http://www.cellmaster.com.au/example.html http://www.cellmaster.com.au/example.html
  - sprayk 12y ago
    not for retrieving the juicy data inside the spreadsheet as objects.
    - fiatjaf 12y ago
      Oh, I didn't read the whole thread, I was just thinking about my own experience with `cat gdrive/something` showing me a lot of unreadable bytes when it could show an iframe.