CODEWITHSUNDEEP
pythongithubquip
Sal
Sal

Reputation: 1

How to create a new sheet inside a quip spreadsheet document via quip Python API?

I had a question and was wondering if there is any possible solution to achieve this via quip python automation API.

I have some data which I am getting from a source and then creating a new quip spreadsheet every time to insert data into it. I don't want to create a new quip spreadsheet every-time, I want it to use the same spreadsheet and create a new sheet in that (similar to how we can create a new sheet in excel) and insert data into that. Is this possible using Python quip automation?

I looked into github Python API doc but couldn't find any method that would create a new sheet in the same spreadsheet. There is a method that creates a spreadsheet itself but not the sheet inside the spreadsheet.

I looked into github Python API doc but couldn't find any method that would create a new sheet in the same spreadsheet.

Upvotes: 0

Views: 2086

Answers (1)

Kyle P
Kyle P

Reputation: 11

I was able to add a new tab to an existing spreadsheet by just creating a new html table and passing that as "content" to the edit_document command, referencing the thread_id of the original table.

html_content = """\
<table title='test_tab_2'>
  <tr>
    <th>name</th>
    <th>id</th> 
  </tr>
  <tr>
    <td></td>
    <td></td>
 </tr>
</table>
"""

Upvotes: 1

Related Questions