Google Spreadsheets Python API
Project description
Super simple Google Spreadsheets Python API.
Features
- Google Sheets API v4.
- Open a spreadsheet by title, key or url.
- Read, write, and format cell ranges.
- Sharing and access control.
- Batching updates.
Example
import gspread gc = gspread.service_account() # Open a spreadsheet by title sh = gc.open("Iris Data") # Get the first sheet wk = sh.sheet1 # Update a range of cells using the top left corner address wk.update('A1', [['Species', 'Sepal length'], ['Iris setosa', 5.1]]) # Format the header wk.format('A1:B1', {'textFormat': {'bold': True}})
License
MIT
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size gspread-3.7.0-py3-none-any.whl (28.3 kB) | File type Wheel | Python version py3 | Upload date | Hashes View |
Filename, size gspread-3.7.0.tar.gz (37.5 kB) | File type Source | Python version None | Upload date | Hashes View |