2

I'm looking for a spreadsheet that can be controlled from outside, similar to e.g. how LibreOffice can be controlled via the UNO API.

I'd like it to have standard manual manipulation functionality - nothing extraordinary, but I'd need things like sorting, filtering, etc.

From the API side, I probably need just the basic data push functionality:

  • Programming language agnostic - e.g. some kind of REST service or something simple along those lines
  • Preferably Push API - i.e. the client would push data instead of spreadsheet pulling
  • Create / delete / display sheet
  • Populate data (basic add / remove rows would suffice, even all-or-nothing approach)
  • Styling would be a plus, not a deal breaker
2

Google Sheets would seem to meet a lot of your needs:

  • Reasonably Full Spreadsheet Functionality
  • Multiple APIs available including REST, XML & JSON based IRL Fetch
  • Bindings such as the python google-api-python-client library
  • Push API Yes
  • Styling, Sorting, Filtering, etc.
  • Populate data including Add, Remove, etc.
  • Authorisation with OAUTH/OAUTH2
  • Download As: ODF, XMLX, CSV, TSV, Zipped HTML, PDF.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.