Manage your spreadsheets with dictsheet in Python. A easy to use Google spreadsheets Python API. Manage information in the sheet in rows. Based on gspread
Features:
- Open a Google Spreadsheet with title and google credentials.
- Mange the spreadsheet row by row.
- Get/set sheet mapping.
- Append a row.
- Update a row or element(s) in a row.
- Iterate rows in a spread sheet.
- Obtain OAuth2 credentials from Google Developers Console
- Obtain the sheet title.
- Start using dictsheet:
import gspread
from oauth2client.service_account import ServiceAccountCredentials
from dict_sheet import Dict_Sheet
# The Credential file obtained from Google
CREDENTIAL_FILE = 'My Projecthah-xxxxxxx.json'
#Title of the sheet
SHEET_NAME = u'titleOfTheSheet'
# Create credentials
scope = ['https://spreadsheets.google.com/feeds']
credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIAL_FILE, scope)
# Use gspread to connect to Google Spread Sheet
gc = gspread.authorize(credentials)
sh = gc.open(SHEET_NAME)
wks = sh.get_worksheet(0)
# Initialize dictsheet
dict_wks = Dict_Sheet(wks=wks)
# Basic usage
# Get mapping
print dict_wks.mapping
# Set mapping
map = {"name":1, "phone":2, "address":3}
dict_wks.mapping = map
# Appending
dict_wks.append({"name": "Chandler Huang","phone": 987654321})
# Updating (2 is the row number)
dict_wks.update({2: {"name": "Kelly"}, 6:{"phone": 12345}})
# Iterating
for idx, dict_data in dict_wks.items():
print idx, ' : ',dict_data
# Clearing a row
dict_wks[4].clear()Python 2.6+ or Python 3+, gspread
pip install dictsheetChandler Huang, Xander Li