gspread 0.0.9

Google Spreadsheets Python library

gspread — Google Spreadsheets Python library

gspread is a client library for interacting with Google Spreadsheets.

Features

• Open a spreadsheet by its title, url or key.

• Extract range, entire row or column values.

• Independent of Google Data Python client library.

Example

The following code is a Python program that connects to Google Data API and fetches a cell’s value from a spreadsheet:

import gspread

# Login with your Google account
gc = gspread.login('[e-mail]','password')

# Spreadsheets can be opened by their title in Google Docs
spreadsheet = gc.open("where's all the money gone 2011")

# Select worksheet by index
worksheet = spreadsheet.get_worksheet(0)

# Get a cell value
val = worksheet.cell(1, 2).value

The cell’s value can be easily updated:

worksheet.update_cell(1, 2, 'Bingo!')

To fetch a cell range, specify it by common notation:

cell_list = worksheet.range('A1:A7')

After some processing, this range can be updated in batch:

for cell in cell_list:
    cell.value = 'O_o'

worksheet.update_cells(cell_list)

Docs & API

Head to gspread’s page.

Code

Check gspread on GitHub.

License

MIT

Download