visicalc's Introduction

title	layout
README	default

visicalc

Google Spreadsheets API using Python

Installation

cd ~/src/github

git clone [email protected]: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()

Product Requirements

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

visicalc's People

Contributors

Stargazers

Watchers

Forkers

ahcub

visicalc's Issues

lsSpreadsheet.py -r switch does not work

./lsSpreadsheet.py -t dj_visicalc_token.json -n fullyPopulate -v -w -r

Produces this error:

authorize
refresh
number of spreadsheets containing the name fullyPopulate is 1
1Z4Qo5pSsefqWsj4jWqF7GXfnsPPVRYXBKM52oGCM4tE fullyPopulate
number of worksheets found is 1
 od6 Sheet1 rows:1000 columns:26
number of cells found is 0
Traceback (most recent call last):
  File "./lsSpreadsheet.py", line 81, in <module>
    enumerate_documents(ss_feed, args.worksheets, args.rows, verbose=args.verbose)
  File "./lsSpreadsheet.py", line 57, in enumerate_documents
    enumerate_worksheets(spreadsheet_id, show_rows, verbose=verbose)
  File "./lsSpreadsheet.py", line 50, in enumerate_worksheets
    enumerate_rows(spreadsheet_id, worksheet_id, verbose=verbose)
  File "./lsSpreadsheet.py", line 24, in enumerate_rows
    current_row = cells_feed.entry[0].cell.row
IndexError: list index out of range