Registry / gcp / spreadsheet

spreadsheet

library1.2.1pypypiunverified

A Python tool for manipulating Google Spreadsheets. Version 1.2.1 is the latest release. The project appears to be in maintenance mode with no recent updates (last commit in 2019).

gcp crm-productivity

pip install spreadsheet

github ↗package ↗

INSTALL

IMPORT

SIG · SPREADSHEET

spreadsheet

gcppythonv1.2.1

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

Spreadsheet

✓ from spreadsheet import Spreadsheet

✗ from spreadsheet import Spreadsheet

Basic usage: authenticate with Google account, access a worksheet, and update a cell. Note: uses older Google Data API (not Sheets API v4).

from spreadsheet import Spreadsheet # Requires Google account credentials sheet = Spreadsheet('username@email.com', 'password') ws = sheet.worksheet('Sheet1') ws.update_cell(1, 1, 'Hello World')

Debug

Known issues

breakingDepends on gdata library which is no longer maintained and uses the deprecated Google Data API (not Sheets API v4). May stop working as Google sunsets older APIs.

fix

Consider migrating to google-api-python-client with google-auth for Sheets API v4.

affects: all

gotchaThe library uses username/password authentication (Google's ClientLogin) which is now disabled by Google for many accounts (OAuth 2.0 required). Authentication may fail.

fix

Use a Google App Password if 2FA enabled, or switch to a modern library like gspread or pygsheets.

affects: all

Upgrade

Version history

1.2.1latest on PyPI · released Aug 26, 2013

Audit

Dependencies

gdatarequiredRequired for Google Data API interaction

Agent activity

43 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/lyda/spreadsheet ↗

packagehttps://pypi.org/project/spreadsheet/ ↗