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 <[EMAIL PROTECTED]> 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 > -- http://mail.python.org/mailman/listinfo/python-list
