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.
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
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.
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.