资 源 简 介
I often want to apply simple database-like functions to data that I receive in spreadsheets, but I don’t want the overhead of importing the data in a database program, working with SQL, etc, etc. I would much rather be able to operate on the spreadsheets directly, code the queries in Python, etc.
The concept of this project is to use a directory of data tables stored in OpenOffice (now LibreOffice...) spreadsheets as a data warehouse, then parse data from one of more spreadsheets into Python data structures, process them using Python scripts, then export the results back to a spreadsheet.
