4/1/2023 0 Comments Quip document![]() ![]() But there’s plenty of customers who use spreadsheets to get their jobs done and I fully believe this will be attractive to those customers. "I don’t think we will get financial kinds of companies to switch from Excel," he admitted. Meanwhile, other collaboration tools like Huddle have scored some big enterprise wins, including children’s charity Barnardo’s, engineering consultancy WSP and tax advisors Grant Thornton.īut Taylor points to the functionality of Quip Spreadsheets, and acknowledges Quip is chasing a different customer to hardcore Excel users – while boasting 10,000 companies as customers of the app, more than half of whom are outside the US. Microsoft’s Office 365 allows people to use Word and Excel on up to five tablets and up to five PCs or Macs on its Home subscription, but Taylor believes Quip has the upper hand because of the ability to include everything on one app. ![]() We’re very excited about going in the opposite direction of the legacy productivity suites. client."That’s more than Google Spreadsheets," he said. Suppose Jane updates her email to be let’s update the spreadsheet to reflect this change. client.update_spreadsheet_headers(thread_id, "Name", "Email")Ĭheck that the headers have been set correctly: spreadsheet = client.get_first_spreadsheet(thread_id) headers = client.get_spreadsheet_header_items(spreadsheet) print(headers) # prints Retrieving a spreadsheet by title title = "My Spreadsheet" jso = client.get_matching_threads(title, only_match_titles=True) # get the id of the first thread thread_id = jso Inserting records into the spreadsheet client.add_to_spreadsheet(thread_id, ["John Doe", client.add_to_spreadsheet(thread_id, ["Jane Doe", Updating records in the spreadsheet Let’s update the headers (A and B by default) to something more descriptive. We will need this as a reference to our created spreadsheet to insert/update records. Hold onto the thread_id from the server’s response. with open("template.html", "rt") as f: template = f.read() jso = client.new_document(template, title="My Spreadsheet", type="spreadsheet") This spreadsheet template consists of only two columns. Create a file called template.html as follows. You can also specify an HTML string to use as the template in the second snippet. ![]() jso = client.new_document("", title="My Spreadsheet", type="spreadsheet") Passing in an empty string as the first argument to new_document tells Quip to use its default HTML template. ( Quip API Doc) Creating a spreadsheet in Quip Threads can simply be a list of messages, i.e., a chat thread, or they may have a document in addition to a list of messages. Most of the operations in the Quip Automation API operate on threads. Quip integrates documents and messages into a single unit that we call a thread. To open a Python client: import quip ACCESS_TOKEN = "" # your access token client = quip.QuipClient(access_token=ACCESS_TOKEN)Īn entity essential to Quip API is a thread. Visit the page to generate a personal access token. ![]() You will need an access token to interact with Quip’s API. The official API documentation lives on this site. Download quip.py from my repository to continue with this tutorial. To enhance the functionalities of the API, I made a fork of its official GitHub repository and incorporated some useful pull requests not yet merged into the master branch. In this post, I will show you how to automate the process of creating, inserting into, and updating a Quip spreadsheet using its Python API client. Screenshot of a Quip spreadsheet (by Lynn Zheng) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |