[SciPy-user] Python Spreadsheet with Python as Core Macro Language

[luis cota]

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 at 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 at scipy.org
> http://projects.scipy.org/mailman/listinfo/scipy-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.scipy.org/pipermail/scipy-user/attachments/20080312/5b4eeb3c/attachment.html>