GoogleSpreadsheets

class googlespreadsheets.GoogleSpreadsheets(access_token=None)

Create a Google Spreadsheets service.

Variables:access_token –

Spreadsheet

GoogleSpreadsheets.spreadsheet(key)

Return the resource corresponding to a single spreadsheet

Worksheet

Spreadsheet.worksheet(worksheet_id, visibility, projection)

Return the resource corresponding to a single worksheet

Cell

Worksheet.cell(cell_id)

Return the resource corresponding to a single cell

Cell.get()

For single-object resources, fetch the object’s data. For collections, fetch all of the objects.

Cell.update(version, obj)

Update this resource.

Variables:
  • version (str) – the resource version you want to update.
  • obj – a Python object representing the updated resource, usually in the same format as returned from get. Refer to the upstream documentation for details.

Cells

Worksheet.cells()

Return the resource corresponding to all the cells

Cells.get(min_row=None, max_row=None, min_col=None, max_col=None)

Fetch cells for the worksheet.

Variables:
  • min_row (int) – To get cells above the indicated row.
  • max_row (int) – To get cells below the given row.
  • min_col (int) – To get cells from the indicated column.
  • max_col (int) – To get cells to the given column.

Row

Worksheet.row(row_id)

Return the resource corresponding to a single row

Row.delete(version)

Delete this resource.

Variables:version (str) – the resource version you want to delete.
Row.update(version, obj)

Update this resource.

Variables:
  • version (str) – the resource version you want to update.
  • obj – a Python object representing the updated resource, usually in the same format as returned from get. Refer to the upstream documentation for details.

Rows

Worksheet.rows()

Return the resource corresponding to all the rows

Rows.create(obj)

Create a new resource.

Variables:obj – a Python object representing the resource to be created, usually in the same as returned from get. Refer to the upstream documentation for details.
Rows.get(reverse=None, orderby=None, sq=None)

Fetch rows for the worksheet.

Variables:
  • reverse (bool) – To get rows in reverse order
  • orderby (str) – To sort the values in ascending order by a particular column.
  • sq (str) – Use it to produce a feed with entries that meet the specified criteria.
Worksheet.delete(version)

Delete this resource.

Variables:version (str) – the resource version you want to delete.
Worksheet.get()

For single-object resources, fetch the object’s data. For collections, fetch all of the objects.

Worksheet.update(version, obj)

Update this resource.

Variables:
  • version (str) – the resource version you want to update.
  • obj – a Python object representing the updated resource, usually in the same format as returned from get. Refer to the upstream documentation for details.

Worksheets

Spreadsheet.worksheets(visibility, projection)

Return the resource corresponding to all the worksheets

Worksheets.create(obj)

Create a new resource.

Variables:obj – a Python object representing the resource to be created, usually in the same as returned from get. Refer to the upstream documentation for details.
Worksheets.get()

For single-object resources, fetch the object’s data. For collections, fetch all of the objects.

Spreadsheets

GoogleSpreadsheets.spreadsheets()

Return the resource corresponding to all the spreadsheets

Spreadsheets.get()

For single-object resources, fetch the object’s data. For collections, fetch all of the objects.