Spreadsheet with Python scripting and database interface?

[Calvin Spealman]

You might want to look at kexi. It is KOffice's answer to MS Access,
and long a awaited contender it is. It has python scripting support
and works with databases natively.

On 29 Jul 2005 08:21:48 GMT, Wolfgang Keller
<wolfgang.keller.nospam at gmx.de> wrote:
> 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
>