spreadsnake

raw JSON →
1.0a1 verified Sat May 09 auth: no python

A Python spreadsheet API for reading, writing, and manipulating spreadsheet files (e.g., Excel, CSV). Currently in alpha (v1.0a1), release cadence is unknown.

pip install spreadsnake==1.0a1
error ModuleNotFoundError: No module named 'spreadsnake'
cause spreadsnake is not installed or not in the current environment.
fix
Run 'pip install spreadsnake==1.0a1'.
error AttributeError: module 'spreadsnake' has no attribute 'load_workbook'
cause Incorrect import path; load_workbook is not in the package namespace if installed incorrectly.
fix
Use 'from spreadsnake import load_workbook'.
gotcha Alpha software: API is unstable and may break without notice. Pin version when using in production.
fix Use spreadsnake==1.0a1 in requirements.txt
gotcha The library may have limited file format support. Not all Excel features (e.g., formulas, charts) are supported.
fix Check documentation for supported features before relying on complex spreadsheets.
deprecated The old import pattern 'import spreadsnake as sp' is still common but not recommended; use explicit imports for better code clarity.
fix Use 'from spreadsnake import Spreadsheet, load_workbook'.

Basic usage: load, create, modify, and save spreadsheets.

from spreadsnake import load_workbook, Spreadsheet

# Load an existing spreadsheet
wb = load_workbook('example.xlsx')

# Create a new spreadsheet
new_wb = Spreadsheet()
new_wb.add_sheet('Sheet1')
sheet = new_wb['Sheet1']
sheet['A1'] = 'Hello'
new_wb.save('new_file.xlsx')