473,720 Members | 2,687 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Spreadsheet with Python scripting and database interface?

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
6 3580
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
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
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
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
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
> 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2221
by: Alan Sheehan | last post by:
Hi, I am considering scripting a large C++ application. In particular I am interested in test driving and end-user scripting the "application layer" in Python and giving it access to a large collection of C++ objects and their methods. I note that SWIG is a mature tool and refers to supporting Python v1.x.
13
35555
by: Allison Bailey | last post by:
Hi Folks, I'm a brand new Python programmer, so please point me in the right direction if this is not the best forum for this question.... I would like to open an existing MS Excel spreadsheet and extract information from specific worksheets and cells. I'm not really sure how to get started with this process. I ran the COM Makepy utility from my PythonWin (IDE from ActiveSTate),
7
2467
by: Chris | last post by:
Hi I am posting this on both the perl and python groups My intention is not to start a war or anything else, I would just like some pragmatic advice. My apologies to the python group I am not very conversant with Python at this stage. that could change soon though.
42
4093
by: Fred Ma | last post by:
Hello, This is not a troll posting, and I've refrained from asking because I've seen similar threads get all nitter-nattery. But I really want to make a decision on how best to invest my time. I'm not interested on which language is better in *general*, just for my purpose. My area of research is in CAD algorithms, and I'm sensing the need to resort to something more expedient than C++, bash scripting, or sed scripting.
1
1894
by: Chris Cottee | last post by:
Hi, I am trying to extend PAMIE (sourceforge project to functionally test web sites using com and python) and I wondered if anyone had done this sort of thing before and had any pointers. My main reason for doing this is that the website I want to test is so full of frames and javascript that it seems painful to try to fix httpunit to be able to cope with it. The difficulties I am having are in getting IE to behave repeatably, handling...
63
5152
by: Davor | last post by:
Is it possible to write purely procedural code in Python, or the OO constructs in both language and supporting libraries have got so embedded that it's impossible to avoid them? Also, is anyone aware of any scripting language that could be considered as "Python minus OO stuff"? (As you can see I'm completely new to Python and initially believed it's a nice&simple scripting language before seeing all this OO stuff that was added in over...
118
6716
by: 63q2o4i02 | last post by:
Hi, I've been thinking about Python vs. Lisp. I've been learning Python the past few months and like it very much. A few years ago I had an AI class where we had to use Lisp, and I absolutely hated it, having learned C++ a few years prior. They didn't teach Lisp at all and instead expected us to learn on our own. I wasn't aware I had to uproot my thought process to "get" it and wound up feeling like a moron. In learning Python I've...
12
2358
by: rurpy | last post by:
Is there an effcient way (more so than cgi) of using Python with Microsoft IIS? Something equivalent to Perl-ISAPI?
8
2121
by: Allen | last post by:
Does anyone agree with me? If you have used Matlab, welcome to discuss it.
0
8834
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8727
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9212
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9127
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9056
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8002
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6664
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5973
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4483
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.