Quip Spreadsheet

An opinionated client to search, retrieve, and parse Quip spreadsheets using the Quip Automation API.

It provides a client to pull data from the Quip API as well as classes to interact with folders, spreadsheets, pages, and rows.

Install

pip install quip-spreadsheet

Usage

# Import
from quip_spreadsheet.quip import QuipPage
# Initialize Client
quip = QuipClient(QUIP_ACCESS_TOKEN, QUIP_BASE_URL)
# Search by term
threads = quip.search_threads("My Spreadsheet", count=1)
# Load the content of a spreadsheet
spreadsheet = threads.spreadsheets[0]
spreadsheet.load_content()
# Get a specific page of a spreadsheet
page = spreadsheet.get_named_page("Sheet1")
# Get a specific row from a page
row = page.get_nth_row(pointer)
# Get cells content from a row
cells = row.get_row_cells_content(include_index=False)

License

MIT

Contributing & Developing

PRs are welcome as long as documented, accompained by passing unit tests and in scope with the project.

To setup the development environment run:

pipenv install --dev

or manually install all the development dependencies found in the Pipfile.