Manipulate spreadsheets locally using Python

$ pip install gspread
$ pip install oauth2client

import gspread 
from oauth2client.service_account import ServiceAccountCredentials
from pprint import pprint 

scope = ["https://spreadsheets.google.com/feeds",'https://www.googleapis.com/auth/spreadsheets',"https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"]

creds = ServiceAccountCredentials.from_json_keyfile_name("creds.json", scope)

client = gspread.authorize(creds)

#I'm getting the first sheet titled python.
sheet = client.open("python").sheet1

#All values are assigned to a variable called data.
data = sheet.get_all_records()

#Vertical and horizontal data can be obtained by the following methods.
row = sheet.row_values(3)
col = sheet.col_values(3)

#If you want to get only a specific cell, you can get it below.
cell = sheet.cell(3,2).value

#If you want to change or add values to your spreadsheet, you can do the following:
sheet.update_cell(3,2, "nakajo")
insertRow = [3, "nakajo", "Tangerine juice"]
sheet.insert_row(insertRow, 3)

pprint(data)

$ python sample.py

Recommended Posts