| title | layout |
|---|---|
README |
default |
visicalc
Google Spreadsheets API using Python
Installation
cd ~/src/github
git clone git@github.com:davejagoda/visicalc.git
cd visicalc
pipenv install
Setup
You need a client_secrets.json file. Go here:
https://console.developers.google.com
Create a new project.
Create an OAuth2 client ID (type Other).
Save the JSON file somewhere safe.
Grant your project access:
./writeGoogleBearerToken.py -c client_secrets.json -t oauth_token.json
Resources
Reading Google Sheets in Python
Parse Error on calling GetSpreadsheetsFeed()
Sample Invocations
Activate pipenv (needed before running any of the subsequent commands):
pipenv shell
Print out details about all your spreadsheets named 'foo' using your token:
lsSpreadsheet.py -t oauth_token.json -n foo
Validate that dates are in ascending order:
validateSpreadsheet.py -t oauth_token.json -n foo -d
Validate that numbers are in ascending order:
validateSpreadsheet.py -t oauth_token.json -n foo -i