Mailing List Archive: Zope: Users

is there a zope product for generating spreadsheets?

Index | Next | Previous | View Threaded

krmane at gmail

May 4, 2009, 2:07 PM

Post #1 of 11 (2578 views)
Permalink

is there a zope product for generating spreadsheets?

hello all,
I am right now browsing through the grok tutorial and found it to be
really amaising.

I had been confused a few days regarding how I can put my application
into zope. Thanks to all you who patiently answered my queries.

Now I am wondering whether there is a product which can generate
spreadsheet like output for some typicle data such as balance sheets or
ledgers (with cell merging capability)?

I would also like to know if there is some way I am make grok integrate
open office in a way that I can generate open office spreadsheets and
send it to a browser or open it in some way?

I know there is a python library called odfpy which can fill up
spreadsheets with data, but I don't know whether similar things are
possible with zope.

I have searched but did not find some thing like this.

so is any thing of the above possible?

happy hacking.
Krishnakant.

_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

lists at zopyx

May 4, 2009, 7:55 PM

Post #2 of 11 (2469 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

On 04.05.09 23:07, Krishnakant wrote:
> hello all,
> I am right now browsing through the grok tutorial and found it to be
> really amaising.
>
> I had been confused a few days regarding how I can put my application
> into zope. Thanks to all you who patiently answered my queries.
>
> Now I am wondering whether there is a product which can generate
> spreadsheet like output for some typicle data such as balance sheets or
> ledgers (with cell merging capability)?
>
> I would also like to know if there is some way I am make grok integrate
> open office in a way that I can generate open office spreadsheets and
> send it to a browser or open it in some way?
>
>
http://lmgtfy.com/?q=python+excel
http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search

> I know there is a python library called odfpy which can fill up
> spreadsheets with data, but I don't know whether similar things are
> possible with zope.
>
>

Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import
almost any Python package (as long as it makes sense). So where is the
problem?

-aj

--
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: info [at] zopyx - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting

Attachments:

lists.vcf (0.31 KB)

krmane at gmail

May 4, 2009, 11:23 PM

Post #3 of 11 (2473 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
> >
> http://lmgtfy.com/?q=python+excel
> http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
>
Thanks a lot, but I don't use, promote or recommend proprietory
standards, so Open office is what I am looking for integrating
> > I know there is a python library called odfpy which can fill up
> > spreadsheets with data, but I don't know whether similar things are
> > possible with zope.
> >
> >
>
> Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import
> almost any Python package (as long as it makes sense). So where is the
> problem?
>
But I read that zope has some kind of restricted python.
So will odfpy integrate?
Further more, I would like to create my application as a self containing
package like the plone installer which also installs python, zope and
other dependencies.

So I really don't know if odfpy will work.
Or for that matter any library. May be I am asking this because I am
very new to all this,
happy hacking.
Krishnakant.

_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

lists at zopyx

May 4, 2009, 11:26 PM

Post #4 of 11 (2472 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

On 05.05.09 08:23, Krishnakant wrote:
> On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
>
>>>
>>>
>> http://lmgtfy.com/?q=python+excel
>> http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
>>
>>
> Thanks a lot, but I don't use, promote or recommend proprietory
> standards, so Open office is what I am looking for integrating
>
>>> I know there is a python library called odfpy which can fill up
>>> spreadsheets with data, but I don't know whether similar things are
>>> possible with zope.
>>>
>>>
>>>
>> Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import
>> almost any Python package (as long as it makes sense). So where is the
>> problem?
>>
>>
> But I read that zope has some kind of restricted python.
> So will odfpy integrate?
> Further more, I would like to create my application as a self containing
> package like the plone installer which also installs python, zope and
> other dependencies.
>
>

Please check the available documentation.

Zope 2: External methods: unrestricted, Product code: unrestricted,
BrowserViews: unrestricted
Zope 3: Browser view, Z3 package code: unrestricted
Grok: everything unrestricted

-aj--

ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: www.zopyx.com - Email: info [at] zopyx - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting

Attachments:

lists.vcf (0.31 KB)

garry at schoolteachers

May 4, 2009, 11:52 PM

Post #5 of 11 (2463 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

Quoting Krishnakant <krmane [at] gmail>:

> On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
>> >
>> http://lmgtfy.com/?q=python+excel
>> http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
>>
> Thanks a lot, but I don't use, promote or recommend proprietory
> standards, so Open office is what I am looking for integrating
>> > I know there is a python library called odfpy which can fill up
>> > spreadsheets with data, but I don't know whether similar things are
>> > possible with zope.
>> >
>> >
>>
>> Why shouldn't that work?! Zope 2, Zope 3 and Grok allow you to import
>> almost any Python package (as long as it makes sense). So where is the
>> problem?
>>
> But I read that zope has some kind of restricted python.
> So will odfpy integrate?
> Further more, I would like to create my application as a self containing
> package like the plone installer which also installs python, zope and
> other dependencies.
>
> So I really don't know if odfpy will work.
> Or for that matter any library. May be I am asking this because I am
> very new to all this,
> happy hacking.
> Krishnakant.
There are a couple of things on Zopelabs that may be of interest:

http://www.zopelabs.com/cookbook/1075841024

http://www.zopelabs.com/cookbook/994090604/1090929950

HTH
Regards
Garry

_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

bennetttm at appstate

May 5, 2009, 6:30 AM

Post #6 of 11 (2459 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

I don't know if there is a reason not to use this but no one has mentioned
PyUNO.

http://wiki.services.openoffice.org/wiki/Python

>From that page:
"OpenOffice.org ships with a python scripting language, version 2.3.4. This
Python distribution comes with the Uno module which connects the UNO API with
the python scripting language."

I'm thinking it should allow you to read from a spreadsheet and then you would
have to format output as you want.

There are a lot of other links related to pyuno, I notice one is a tutorial.

http://www.google.com/search?hl=en&q=openoffice+3+python&btnG=Search

and if you add 'calc' to the search you can narrow down the search and find
things like

"OpenOffice.org Utility Library, or ooolib in short, is actually more than one
library module. Included are a Python module (ooolib-python) and a Perl module
(ooolib-perl).

The Python module is currently focused on Calc and can be used to create
OpenDocument Format Calc spreadsheets."

Thomas

On Monday 04 May 2009 17:07:28 Krishnakant wrote:
> hello all,
> I am right now browsing through the grok tutorial and found it to be
> really amaising.
>
> I had been confused a few days regarding how I can put my application
> into zope. Thanks to all you who patiently answered my queries.
>
> Now I am wondering whether there is a product which can generate
> spreadsheet like output for some typicle data such as balance sheets or
> ledgers (with cell merging capability)?
>
> I would also like to know if there is some way I am make grok integrate
> open office in a way that I can generate open office spreadsheets and
> send it to a browser or open it in some way?
>
> I know there is a python library called odfpy which can fill up
> spreadsheets with data, but I don't know whether similar things are
> possible with zope.
>
> I have searched but did not find some thing like this.
>
> so is any thing of the above possible?
>
> happy hacking.
> Krishnakant.
>
>
> _______________________________________________
> Zope maillist - Zope [at] zope
> http://mail.zope.org/mailman/listinfo/zope
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )

--
==========================================
Thomas McMillan Grant Bennett Appalachian State University
Operations & Systems Analyst P O Box 32026
University Library Boone, North Carolina 28608
(828) 262 6587

Library Systems Help Desk: https://www.library.appstate.edu/help/
==========================================
_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

chris at simplistix

May 5, 2009, 7:32 AM

Post #7 of 11 (2466 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

Thomas Bennett wrote:
> I don't know if there is a reason not to use this but no one has mentioned
> PyUNO.
>
> http://wiki.services.openoffice.org/wiki/Python

Running open office on a server is pretty shaky...
Been there, done that, never rolled it into production 'cos it was that
shaky...

Chris

--
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk
_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

chris at simplistix

May 5, 2009, 7:33 AM

Post #8 of 11 (2466 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

garry [at] schoolteachers wrote:
> http://www.zopelabs.com/cookbook/1075841024

Eee gads that's a horrible hack...
It does work, but there are *much* better options...

> http://www.zopelabs.com/cookbook/994090604/1090929950

CSVs suck ;-)

Chris

--
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk
_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

chris at simplistix

May 5, 2009, 7:38 AM

Post #9 of 11 (2452 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

Krishnakant wrote:
> On Tue, 2009-05-05 at 04:55 +0200, Andreas Jung wrote:
>>>
>> http://lmgtfy.com/?q=python+excel
>> http://pypi.python.org/pypi?%3Aaction=search&term=excel&submit=search
>>
> Thanks a lot, but I don't use, promote or recommend proprietory
> standards, so Open office is what I am looking for integrating

Don't be a muppet. "Excel" often refers to the file format, which is
read and written by all sorts of software, not just evil empire stuff...

> But I read that zope has some kind of restricted python.
> So will odfpy integrate?

As Andreas has pointed out, you should do a bit more research before
making silly comments like this ;-)

> Further more, I would like to create my application as a self containing
> package like the plone installer which also installs python, zope and
> other dependencies.

That's got nothing to do with any of this...

> Or for that matter any library. May be I am asking this because I am
> very new to all this,

I would use the Excel file format and generate the files with:

http://pypi.python.org/pypi/xlwt

If you need to parse excel files after they are uploaded to extract
their data, I'd do so with this:

http://pypi.python.org/pypi/xlrd

Help on both of these libraries can be obtained here:

http://groups.google.com.au/group/python-excel

cheers,

Chris

--
Simplistix - Content Management, Zope & Python Consulting
- http://www.simplistix.co.uk
_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

marco.bizzarri at gmail

May 5, 2009, 8:38 AM

Post #10 of 11 (2455 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

I could suggest taking a look at oood from erp5 project

http://www.erp5.org/HowToUseOood

it needs a little tweaking to work with calc files, but nothing impossible...

and it seems even stable...

Regards
Marco

On Tue, May 5, 2009 at 3:30 PM, Thomas Bennett <bennetttm [at] appstate> wrote:
> I don't know if there is a reason not to use this but no one has mentioned
> PyUNO.
>
> http://wiki.services.openoffice.org/wiki/Python
>
> >From that page:
> "OpenOffice.org ships with a python scripting language, version 2.3.4. This
> Python distribution comes with the Uno module which connects the UNO API with
> the python scripting language."
>
> I'm thinking it should allow you to read from a spreadsheet and then you would
> have to format output as you want.
>
> There are a lot of other links related to pyuno, I notice one is a tutorial.
>
> http://www.google.com/search?hl=en&q=openoffice+3+python&btnG=Search
>
> and if you add 'calc' to the search you can narrow down the search and find
> things like
>
> "OpenOffice.org Utility Library, or ooolib in short, is actually more than one
> library module. Included are a Python module (ooolib-python) and a Perl module
> (ooolib-perl).
>
> The Python module is currently focused on Calc and can be used to create
> OpenDocument Format Calc spreadsheets."
>
>
>
>
>
> Thomas
>
>
>
>
> On Monday 04 May 2009 17:07:28 Krishnakant wrote:
>> hello all,
>> I am right now browsing through the grok tutorial and found it to be
>> really amaising.
>>
>> I had been confused a few days regarding how I can put my application
>> into zope. Thanks to all you who patiently answered my queries.
>>
>> Now I am wondering whether there is a product which can generate
>> spreadsheet like output for some typicle data such as balance sheets or
>> ledgers (with cell merging capability)?
>>
>> I would also like to know if there is some way I am make grok integrate
>> open office in a way that I can generate open office spreadsheets and
>> send it to a browser or open it in some way?
>>
>> I know there is a python library called odfpy which can fill up
>> spreadsheets with data, but I don't know whether similar things are
>> possible with zope.
>>
>> I have searched but did not find some thing like this.
>>
>> so is any thing of the above possible?
>>
>> happy hacking.
>> Krishnakant.
>>
>>
>> _______________________________________________
>> Zope maillist - Zope [at] zope
>> http://mail.zope.org/mailman/listinfo/zope
>> ** No cross posts or HTML encoding! **
>> (Related lists -
>> http://mail.zope.org/mailman/listinfo/zope-announce
>> http://mail.zope.org/mailman/listinfo/zope-dev )
>
> --
> ==========================================
> Thomas McMillan Grant Bennett Appalachian State University
> Operations & Systems Analyst P O Box 32026
> University Library Boone, North Carolina 28608
> (828) 262 6587
>
> Library Systems Help Desk: https://www.library.appstate.edu/help/
> ==========================================
> _______________________________________________
> Zope maillist - Zope [at] zope
> http://mail.zope.org/mailman/listinfo/zope
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )
>

--
Marco Bizzarri
http://sf.net/projects/qt-asterisk/
http://notenotturne.blogspot.com/
http://iliveinpisa.blogspot.com/
_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

krmane at gmail

May 5, 2009, 11:09 AM

Post #11 of 11 (2451 views)
Permalink

Re: is there a zope product for generating spreadsheets? [In reply to]

On Tue, 2009-05-05 at 15:38 +0100, Chris Withers wrote:
> Don't be a muppet. "Excel" often refers to the file format, which is
> read and written by all sorts of software, not just evil empire stuff...
>
Issue is not the software, ut the standard. Our policy is not just to
discourage proprietory software, but also closed standards.

never the less, I just got to know that odfpy would work with my
application.

Now I will try and look at the possibility of having the browser open
the odf spreadsheet or opening calc itself.

> > But I read that zope has some kind of restricted python.
> > So will odfpy integrate?
>
> As Andreas has pointed out, you should do a bit more research before
> making silly comments like this ;-)
>
The documentation is a bit overvelming and donting, so there is a lot of
things to read before getting to what one actually wanted to know.

I come from the world of apache, php and pure python where I would not
face such problems.

But it's true that some research reveals the solution.

> > Further more, I would like to create my application as a self containing
> > package like the plone installer which also installs python, zope and
> > other dependencies.
>
> That's got nothing to do with any of this...

Yes, it is just one of those things I am worried about because I might
lavishly include all the modules I need and set my development
environment right, but I don't expect it from my customers who are not
eaven techi let alone being hackers.
So thwy will not take paines to do all the settings fromthe commandline.

Any ways things now seem to be perfectly all right with me.

thanks a million.

happy hacking.
Krishnakant.

_______________________________________________
Zope maillist - Zope [at] zope
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads