By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,248 Members | 1,621 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,248 IT Pros & Developers. It's quick & easy.

Spreadsheet with Python scripting and database interface?

P: n/a
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
Jul 29 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
has
Wolfgang Keller wrote:
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?


For scripting Mac applications with Python instead of AppleScript, see:
http://freespace.virgin.net/hamish.s...appscript.html

HTH

Jul 29 '05 #2

P: n/a
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
<wo********************@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

Jul 30 '05 #3

P: n/a
Wolfgang Keller <wo********************@gmx.de> wrote:
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?

Package: gnumeric-plugins-extra
Description: additional plugins for the GNOME spreadsheet
Gnumeric ships with a number of plugins; this package contains those
plugins that require additional packages above what the 'gnumeric' package
needs.
Aug 11 '05 #4

P: n/a
On Fri, 2005-07-29 at 04:21, Wolfgang Keller 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?
[snip]
OO Calc: I know that PyUNO exists, but I know nothing about what it can
actually do?
[snip]


See http://udk.openoffice.org/python/python-bridge.html for more than
you'll ever want to know about this. In a nutshell, you can do pretty
much anything.

One thing that's not clear from your question is whether you want to
script the office from within using a macro or from the outside via
"remote control". PyUNO allows both, but Python macros are only possible
with the OpenOffice 2 scripting framework.

Hope this helps,

Carsten Haese.
Aug 11 '05 #5

P: n/a
Hello,

and thanks for your reply.
One thing that's not clear from your question is whether you want to
script the office from within using a macro or from the outside via
"remote control".
What I basically dream of is using Python as THE embedded macro
language of the spreadsheet.

Because Postgres already supports Python as a trigger/procedure
language, so I can stick with one single tool (to learn and use).
PyUNO allows both, but Python macros are only possible
with the OpenOffice 2 scripting framework.


Sincerely,

Wolfgang Keller
Aug 12 '05 #6

P: n/a
> o The Python plugin
o The Python plugin loader
o Additional Python functions


Do these provide the possibility to use Python as macro/scripting
language from within Gnumeric?

TIA,

Sincerely,

Wolfgang Keller
Aug 15 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.