Spreadsheet with Python scripting and database interface?
wolfgang.keller.nospam at gmx.de
Fri Jul 29 10:21:48 CEST 2005
I'm looking for a spreadsheet application (MacOS X prefered, but
Windows, Linux ar available as well) with support for Python scripting
(third-party "plug-ins" are ok) and a database interface.
Applications that I know of (that they exist) are:
Which ones have I forgotten?
Which ones have support for Python scripting?
Excel: I know of a module that allows to script Excel in Python from
outside (COM scripting on Windows and Applescript on MacOS are know as
well), but I don't know of any possibility to do Python scripting with
OO Calc: I know that PyUNO exists, but I know nothing about what it can
Kspread: Koffice seems to have Python scripting support, but I have no
clue what you can actually do with it?
The database interface should ideally allow to:
- map database tables, views, query results to tables/lists (with as
little programming as possible)
- allow editing of records within those tables/lists (and write back
- supply possibilities to handle relationships (via foreign keys)
between records in different tables in a user-friendly way (I have
something like hyperlinks in mind)
The database software to interface with is Postgres.
The application "should" also provide good support for naming of
cells/columns/rows/regions (including namespaces for files, sheets) and
More information about the Python-list