Hello, 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: MS Excel Quattro Lotus OO Calc Gnumeric Kspread 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 Excel itself? OO Calc: I know that PyUNO exists, but I know nothing about what it can actually do? 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 the results) - 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 user-defined formats. TIA, Sincerely, Wolfgang Keller -- http://mail.python.org/mailman/listinfo/python-list
