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
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.