python-google-spreadsheet A simple Python wrapper for the Google Spreadsheets API
Download

python-google-spreadsheet Ranking & Summary

python-google-spreadsheet Tags

Google Python library Python spreadsheets

python-google-spreadsheet Description

python-google-spreadsheet is a simple Python wrapper for the Google Spreadsheeta API.UsageList Spreadsheets and Worksheets: >>> from google_spreadsheet.api import SpreadsheetAPI >>> api = SpreadsheetAPI(GOOGLE_SPREADSHEET_USER, GOOGLE_SPREADSHEET_PASSWORD, GOOGLE_SPREADSHEET_SOURCE) >>> spreadsheets = api.list_spreadsheets() >>> spreadsheets >>> worksheets = api.list_worksheets(spreadsheets) >>> worksheets Please note that in order to work with a Google Spreadsheet it must be accessible to the user who's login credentials are provided. The GOOGLE_SPREADSHEET_SOURCE argument is used by Google to identify your application and track API calls.Working with a Worksheet: >>> sheet = spreadsheet.get_worksheet('tkZQWzwHEjKTWFFCAgw', 'od7') >>> rows = sheet.get_rows() >>> len(rows) 18 >>> row_to_update = rows >>> row_to_update = 'New Name' >>> sheet.update_row(0, row_to_update) {'name': 'New Name'...} >>> row_to_insert = rows >>> row_to_insert = 'Another Name' >>> sheet.insert_row(row_to_insert) {'name': 'Another Name'...} >>> sheet.delete_row(18) >>> sheet.delete_all_rows()That's it.For more information about these calls, please consult the Google Spreadsheets API Developer Guide.Product's homepage

python-google-spreadsheet Related Software