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.
Source Distribution
gspread-5.3.2.tar.gz
(44.8 kB
view hashes)
Built Distribution
gspread-5.3.2-py3-none-any.whl
(34.7 kB
view hashes)