Writing to a Google Document With Python

Question

I have some data that I want to write to a simple multi-column table in Google Docs. Is this way too cumbersome to even begin attempting? I would just render it in XHTML, but my client has a very specific work flow set up on Google Docs that she doesn't want me to interfere with. The Google Docs API seems more geared toward updating metadata and making simple changes to the file format than it is toward undertaking the task of writing entire documents using only raw data and a few formatting rules. Am I missing something, or are there any other libraries that might be able to achieve this?

I guess taking a read at this could help (don't know if there are better ways, but the HTML Request API would be my first try: developers.google.com/google-apps/spreadsheets — heltonbiker
– heltonbiker, Commented Jan 9, 2013 at 23:19

Thorsten Kranz · Accepted Answer · 2013-01-09 23:25:41Z

3

From the docs:

What can this API do?

The Google Documents List API allows developers to create, retrieve, update, and delete Google Docs (including but not limited to text documents, spreadsheets, presentations, and drawings), files, and collections.

So maybe you could save your data to an excel worksheet temporarily and then upload and convert this.

Saving to excel can be done with xlwt:

import xlwt
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('Sheet 1')
sheet.write(0,1,'First text')
workbook.save('test.xls')

edited Jan 9, 2013 at 23:25

answered Jan 9, 2013 at 23:19

Thorsten Kranz

12.8k2 gold badges45 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

heltonbiker Over a year ago

There is a dedicated spreadsheet api here: developers.google.com/google-apps/spreadsheets

Thorsten Kranz Over a year ago

But this cannot be used for uploading or creating. They point developers to the documents-list API linked to in my answer

user1427661 Over a year ago

I could do a spreadsheet in the worst case scenario, but the data is more conducive to a table in a word document, and not one easily convertible from a spreadsheet format either.

Thorsten Kranz Over a year ago

Then just make a compatible word-like document and upload it, e.g., look here

Collectives™ on Stack Overflow

Writing to a Google Document With Python

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related