Python Spreadsheet with Python as Core Macro Language
![](https://secure.gravatar.com/avatar/996afee3aa77d7f2382485cf7f7425cd.jpg?s=120&d=mm&r=g)
Has anyone seen a Python spreadsheet with Python as the core macro language? I'm aware of IronPython and this is about as close as I have seen to what I am looking for except that it runs on the wrong OS and can't use the standard python libraries. :) I've run into a few other options that look promising, just not.quite.theresuch as GNU Numeric, OpenOffice, and Picalo. All I'm looking for is a basic grid that i can use to dynamically test functions and to print results for evaluation. Perhaps what is needed is a new project using a wxPython grid? - Luis
![](https://secure.gravatar.com/avatar/5c9fb379c4e97b58960d74dcbfc5dee5.jpg?s=120&d=mm&r=g)
On Wed, Mar 12, 2008 at 10:20:43AM -0400, luis cota wrote:
Has anyone seen a Python spreadsheet with Python as the core macro language?
Resolver (http://resolversystems.com/) but it is based on ironpython. Gaël
![](https://secure.gravatar.com/avatar/ac4e2152839c56c5326cd95ae54296e9.jpg?s=120&d=mm&r=g)
On Wed, Mar 12, 2008 at 2:30 PM, Gael Varoquaux <gael.varoquaux@normalesup.org> wrote:
On Wed, Mar 12, 2008 at 10:20:43AM -0400, luis cota wrote:
Has anyone seen a Python spreadsheet with Python as the core macro language?
Resolver (http://resolversystems.com/) but it is based on ironpython.
I'm not affiliated in any way, but I think Resolver One looks like a great product. It's not open source but has a sensible license (free for academic/non-commercial use provided any created sheet is under an open source license). They are also working on getting CPython extensions (numpy and maybe one day scipy) working with IronPython: http://code.google.com/p/ironclad/ Robin
![](https://secure.gravatar.com/avatar/3d4fcb0bbf6d3bfd68b59aff0573c7fe.jpg?s=120&d=mm&r=g)
luis cota wrote:
Has anyone seen a Python spreadsheet with Python as the core macro language?
![](https://secure.gravatar.com/avatar/86e8669ab2aca4fd5e81f447341826a4.jpg?s=120&d=mm&r=g)
I haven't taken advantage of the feature, but I believe Python is the scripting language used across all components of the OpenOffice integrated software. Brandon ________________________________ From: scipy-user-bounces@scipy.org [mailto:scipy-user-bounces@scipy.org] On Behalf Of luis cota Sent: Wednesday, March 12, 2008 10:21 AM To: SciPy-user@scipy.org; enthought-dev@mail.enthought.com Subject: [SciPy-user] Python Spreadsheet with Python as Core Macro Language Has anyone seen a Python spreadsheet with Python as the core macro language? I'm aware of IronPython and this is about as close as I have seen to what I am looking for except that it runs on the wrong OS and can't use the standard python libraries. :) I've run into a few other options that look promising, just not.quite.there such as GNU Numeric, OpenOffice, and Picalo. All I'm looking for is a basic grid that i can use to dynamically test functions and to print results for evaluation. Perhaps what is needed is a new project using a wxPython grid? - Luis
![](https://secure.gravatar.com/avatar/f5b5e1fb641ac64de524f3ed442cbf36.jpg?s=120&d=mm&r=g)
luis cota wrote:
Has anyone seen a Python spreadsheet with Python as the core macro language?
I'm aware of IronPython and this is about as close as I have seen to what I am looking for except that it runs on the wrong OS and can't use the standard python libraries. :)
Do you mean Resolver One (www.resolversystems.com)? There is no technical reason IronPython can't run on Mono instead of the MS CLR, but I have no idea if any particular app is portable.
I've run into a few other options that look promising, just not.quite.there such as GNU Numeric, OpenOffice, and Picalo. All I'm looking for is a basic grid that i can use to dynamically test functions and to print results for evaluation.
A quick search shows that PyQt4 and KSpread can be used together vi Kross (search for "kspread scripting"). I would be surprised if there isn't a Gnome app with similar functionality.
Perhaps what is needed is a new project using a wxPython grid?
I guess this really depends on what you're aiming for. If there is another spreadsheet which offers most of the features you want, its probably more advisable to try to add the python functionality to it rather than writing your own. Bryce
![](https://secure.gravatar.com/avatar/39916bae984cb93b797efd2b175f59c0.jpg?s=120&d=mm&r=g)
Gnumeric provides some support for Python scripting: http://www.gnome.org/projects/gnumeric/download.shtml (I have not tried this functionality.) Cheers, Alan Isaac
![](https://secure.gravatar.com/avatar/49543f01f2f4a1f8f4a84ff19ea0b9a6.jpg?s=120&d=mm&r=g)
I find Picalo is a very interesting 'spreadsheet'. Not very traditional, but similiar in functionality with a serious python scripting interface. www.picalo.org Gabriel On Wed, Mar 12, 2008 at 10:20:43AM -0400, luis cota wrote:
Has anyone seen a Python spreadsheet with Python as the core macro language?
I'm aware of IronPython and this is about as close as I have seen to what I am looking for except that it runs on the wrong OS and can't use the standard python libraries. :)
I've run into a few other options that look promising, just not.quite.there such as GNU Numeric, OpenOffice, and Picalo. All I'm looking for is a basic grid that i can use to dynamically test functions and to print results for evaluation.
Perhaps what is needed is a new project using a wxPython grid?
- Luis
_______________________________________________ SciPy-user mailing list SciPy-user@scipy.org http://projects.scipy.org/mailman/listinfo/scipy-user
![](https://secure.gravatar.com/avatar/6194b135cba546afa82516de1537de49.jpg?s=120&d=mm&r=g)
Hi Luis, Could you clarify what you mean by "Python Spreadsheet" ? If you want something entirely implemented in Python, then like most of OpenOffice, KDE-office, Gnumeric and so on would be excluded .... Also: maybe it would help, to say something about what this is for ?! Do you need cross platform for Linux, OS-X and Windows ? Since the GUI part is practically given with some simple wxPython code, one could instead ask for a "spreadsheed engine" !! This would be a (small) set of functions which can analysis the dependencies a given spreadsheet and evaluate the cells in a (non-circular) sequence taking the found dependencies into account. Might already exist ... !? Regards, Sebastian On Wed, Mar 12, 2008 at 3:20 PM, luis cota <lo.maximo73@gmail.com> wrote:
Has anyone seen a Python spreadsheet with Python as the core macro language?
I'm aware of IronPython and this is about as close as I have seen to what I am looking for except that it runs on the wrong OS and can't use the standard python libraries. :)
I've run into a few other options that look promising, just not.quite.there such as GNU Numeric, OpenOffice, and Picalo. All I'm looking for is a basic grid that i can use to dynamically test functions and to print results for evaluation.
Perhaps what is needed is a new project using a wxPython grid?
- Luis
_______________________________________________ SciPy-user mailing list SciPy-user@scipy.org http://projects.scipy.org/mailman/listinfo/scipy-user
![](https://secure.gravatar.com/avatar/0062f83e4887adac3dc7a406cd18fee9.jpg?s=120&d=mm&r=g)
On Wed, Mar 12, 2008 at 09:40:09PM +0100, Sebastian Haase wrote:
Since the GUI part is practically given with some simple wxPython code, one could instead ask for a "spreadsheed engine" !! This would be a (small) set of functions which can analysis the dependencies a given spreadsheet and evaluate the cells in a (non-circular) sequence taking the found dependencies into account. Might already exist ...
Indeed. See attached. Not the highest performance code, but it should be enough to get one started. All you need is to parse the expressions to identify cell references for building the dependency graph. - Paul
![](https://secure.gravatar.com/avatar/996afee3aa77d7f2382485cf7f7425cd.jpg?s=120&d=mm&r=g)
Thanks for the responses - I've used ResolverOne quite a bit and am fond of its capabilities. My primary needs are to have a "spreadsheet interface" that allows me to call functions using "=myfunc(A1, A2)" which are defined in python code. Most of my work makes use of standard python libraries, so using ResolverOne had me rewriting a lot of the same code that I don't want to rewrite (math/science manipulation stuff). Also, I'd like to use it as a viewer of intermediate states of data. eg - seeing what the data looks like at each step in the overall analytic system. I've checked out a lot of those tools - picalo looks very cool, though not quite what im looking for at the moment. OpenOffice looked so promising, until I began inspecting the PyUNO bridge - that stuff looks very heavy when compared ti Resolver, which would be exactly right if I could use C Python libs.... I've also thought about embedding Python into MS Excel through XLW - this currently seems like a great option, though i'm trying to avoid windows code altogether. Hoping someone has some options ....plz! - Luis On Wed, Mar 12, 2008 at 5:59 PM, Paul Kienzle <pkienzle@nist.gov> wrote:
On Wed, Mar 12, 2008 at 09:40:09PM +0100, Sebastian Haase wrote:
Since the GUI part is practically given with some simple wxPython code, one could instead ask for a "spreadsheed engine" !! This would be a (small) set of functions which can analysis the dependencies a given spreadsheet and evaluate the cells in a (non-circular) sequence taking the found dependencies into account. Might already exist ...
Indeed. See attached. Not the highest performance code, but it should be enough to get one started. All you need is to parse the expressions to identify cell references for building the dependency graph.
- Paul
_______________________________________________ SciPy-user mailing list SciPy-user@scipy.org http://projects.scipy.org/mailman/listinfo/scipy-user
![](https://secure.gravatar.com/avatar/0e31f673b2f054ea61da64e35bd52cc0.jpg?s=120&d=mm&r=g)
hi Luis, are you looking for something like this: http://oase.uci.kun.nl/~mientki/data_www/pic/jalcc/help/jalcc_swb_akto.html http://oase.uci.kun.nl/~mientki/data_www/pic/jalcc/help/jallcc_signal_workbe... cheers, Stef luis cota wrote:
Thanks for the responses - I've used ResolverOne quite a bit and am fond of its capabilities. My primary needs are to have a "spreadsheet interface" that allows me to call functions using "=myfunc(A1, A2)" which are defined in python code.
Most of my work makes use of standard python libraries, so using ResolverOne had me rewriting a lot of the same code that I don't want to rewrite (math/science manipulation stuff).
Also, I'd like to use it as a viewer of intermediate states of data. eg - seeing what the data looks like at each step in the overall analytic system.
I've checked out a lot of those tools - picalo looks very cool, though not quite what im looking for at the moment.
OpenOffice looked so promising, until I began inspecting the PyUNO bridge - that stuff looks very heavy when compared ti Resolver, which would be exactly right if I could use C Python libs....
I've also thought about embedding Python into MS Excel through XLW - this currently seems like a great option, though i'm trying to avoid windows code altogether. Hoping someone has some options ....plz!
- Luis
On Wed, Mar 12, 2008 at 5:59 PM, Paul Kienzle <pkienzle@nist.gov <mailto:pkienzle@nist.gov>> wrote:
On Wed, Mar 12, 2008 at 09:40:09PM +0100, Sebastian Haase wrote: > Since the GUI part is practically given with some simple wxPython > code, one could instead ask for a "spreadsheed engine" !! This would > be a (small) set of functions which can analysis the dependencies a > given spreadsheet and evaluate the cells in a (non-circular) sequence > taking the found dependencies into account. Might already exist ...
Indeed. See attached. Not the highest performance code, but it should be enough to get one started. All you need is to parse the expressions to identify cell references for building the dependency graph.
- Paul
_______________________________________________ SciPy-user mailing list SciPy-user@scipy.org <mailto:SciPy-user@scipy.org> http://projects.scipy.org/mailman/listinfo/scipy-user
------------------------------------------------------------------------
_______________________________________________ SciPy-user mailing list SciPy-user@scipy.org http://projects.scipy.org/mailman/listinfo/scipy-user
Het UMC St Radboud staat geregistreerd bij de Kamer van Koophandel in het handelsregister onder nummer 41055629. The Radboud University Nijmegen Medical Centre is listed in the Commercial Register of the Chamber of Commerce under file number 41055629.
![](https://secure.gravatar.com/avatar/39916bae984cb93b797efd2b175f59c0.jpg?s=120&d=mm&r=g)
On Wed, 12 Mar 2008, luis cota apparently wrote:
Resolver, which would be exactly right if I could use C Python libs.
Ask them about this? My guess is that they will be very interested.
I've also thought about embedding Python into MS Excel through XLW - this currently seems like a great option, though i'm trying to avoid windows code altogether.
Might be easier with Gnumeric? fwiw, Alan Isaac
participants (11)
-
Alan G Isaac
-
Bill Dandreta
-
Bryce Hendrix
-
Gabriel Gellner
-
Gael Varoquaux
-
luis cota
-
Nuttall, Brandon C
-
Paul Kienzle
-
Robin
-
Sebastian Haase
-
Stef Mientki