butterdb vs xlwings: What are the differences?
butterdb: A Python ORM for Google Drive Spreadsheets. butterdb is a library to help you work with Google Spreadsheet data. It lets you model your data as Python objects, to be easily manipulated or created; xlwings: Use Python in Excel without add-ins. Replace your VBA code with Python, a powerful yet easy-to-use programming language that is highly suited for numerical analysis. Supports Windows & Mac!.
butterdb and xlwings can be categorized as "Spreadsheets as a Backend" tools.
Some of the features offered by butterdb are:
- Store data in Google Spreadsheets (the cloud!!!)
- Models from classes
- Fields as attributes. decimals, ints and strings only (as far as I know)
On the other hand, xlwings provides the following key features:
- Easy deployment: The receiver of an xlwings-powered spreadsheets only needs Python with minimal dependencies — or nothing at all when shipped with the Python runtime.
- Cross-Platform: xlwings works with Microsoft Excel on Windows and Mac.
- Plug-and-Play: No cumbersome installation of Excel add-ins or license keys.
butterdb and xlwings are both open source tools. xlwings with 1.38K GitHub stars and 259 forks on GitHub appears to be more popular than butterdb with 344 GitHub stars and 13 GitHub forks.