sh = gc.open('My poor gym results')

sht1 = gc.open_by_key('0BmgG6nO_6dprdS1MN3d3MkdPa142WFRrdnRRUWl1UFE')

sht2 = gc.open_by_url('https://docs.google.com/spreadsheet/ccc?key=0Bm...FE&hl')

sh = gc.create('A new spreadsheet')

sh.share('otto@example.com', perm_type='user', role='writer')

worksheet = sh.get_worksheet(0)

worksheet = sh.worksheet("January")

worksheet = sh.sheet1

worksheet_list = sh.worksheets()

worksheet = sh.add_worksheet(title="A worksheet", rows="100", cols="20")

sh.del_worksheet(worksheet)

val = worksheet.acell('B1').value

val = worksheet.cell(1, 2).value

cell = worksheet.acell('B1', value_render_option='FORMULA').value

# or

cell = worksheet.cell(1, 2, value_render_option='FORMULA').value

values_list = worksheet.row_values(1)

values_list = worksheet.col_values(1)

list_of_lists = worksheet.get_all_values()

list_of_dicts = worksheet.get_all_records()

cell = worksheet.find("Dough")

print("Found something at R%sC%s" % (cell.row, cell.col))

amount_re = re.compile(r'(Big|Enormous) dough')
cell = worksheet.find(amount_re)

cell_list = worksheet.findall("Rug store")

criteria_re = re.compile(r'(Small|Room-tiering) rug')
cell_list = worksheet.findall(criteria_re)

value = cell.value
row_number = cell.row
column_number = cell.col

worksheet.update('B1', 'Bingo!')

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

worksheet.update('A1:B2', [[1, 2], [3, 4]])

worksheet.format('A1:B1', {'textFormat': {'bold': True}})

worksheet.format("A2:B2", {
    "backgroundColor": {
      "red": 0.0,
      "green": 0.0,
      "blue": 0.0
    },
    "horizontalAlignment": "CENTER",
    "textFormat": {
      "foregroundColor": {
        "red": 1.0,
        "green": 1.0,
        "blue": 1.0
      },
      "fontSize": 12,
      "bold": True
    }
})

import pandas as pd

dataframe = pd.DataFrame(worksheet.get_all_records())

import pandas as pd

worksheet.update([dataframe.columns.values.tolist()] + dataframe.values.tolist())

import numpy as np
array = np.array(worksheet.get_all_values())

import numpy as np

array = np.array([[1, 2, 3], [4, 5, 6]])

# Write the array to worksheet starting from the A2 cell
worksheet.update('A2', array.tolist())