Renaming Excel Spreadsheets

[James Matthews]

---------- Forwarded message ----------
From: Waldemar Osuch <waldemar.osuch at gmail.com>
Date: Tue, Aug 26, 2008 at 7:59 PM
Subject: Re: [python-win32] Fwd: Renaming Excel Spreadsheets
To: Python-Win32 List <python-win32 at python.org>


On Tue, Aug 26, 2008 at 12:57 PM, James Matthews <nytrokiss at gmail.com>
wrote:
>
>
> ---------- Forwarded message ----------
> From: Greg Lindstrom <gslindstrom at gmail.com>
> Date: Tue, Aug 26, 2008 at 11:54 AM
> Subject: Renaming Excel Spreadsheets
> To: python-list at python.org
>
>
> Hello,
>
> I am working with Python to create Excel spreadsheets and have run into a
> couple of problems I hope you can help me with.
>
> First...are there any bindings/libraries into Open Office?
>
> Now, back to Excel.
>
> --> Does anyone know a way to create N worksheets?  By default, 3 are
> created, but I would like more.
>
> --> Is it possible to rename a worksheet inside of the workbook (change
> "Sheet1" to "July 08", for example).
>
> I've been working with Mark Hammond's book on Windows programming with
> Python, but these have me stumped.
>
> Better yet, an Open Source reporting system (ala Crystal Reports) would
keep
> me from having to write this.  I've looked at Jasper and DataVision;
>
> Thanks,
> --greg
>

That should get you started

>>> from win32com.client import Dispatch
>>> app = Dispatch('Excel.Application')
>>> app.Visible = True
>>> wrk = app.Workbooks.Add()
>>> wrk.Sheets.Count
3
>>> sh = wrk.Sheets.Add()
>>> wrk.Sheets.Count
4
>>> sh.Name
u'Sheet4'
>>> sh.Name = 'New Name 4'
>>> wrk.Sheets[0].Name
u'New Name 4'
>>> wrk.Sheets[2].Name
u'Sheet2'
>>> wrk.Sheets[2].Name = 'Hello'
>>> wrk.Save()
>>> wrk.Close(0)
>>> app.Quit()
>>>

But I would recommend using xlwt (friendly fork of pyExcelerator) for
Excel generation.
It lets you bypass having to install Microsoft Office.
https://secure.simplistix.co.uk/svn/xlwt/trunk/README.html

The OpenOffice comes with its own version of python that can be used
for automation.
http://wiki.services.openoffice.org/wiki/Python

Another option is to manipulate the OpenOffice documents directly.
http://openoffice-python.origo.ethz.ch/

Or create OpenOffice document as a template with all the formatting you
desire
and generate new document by judicious modification of the template's XML.
The OpenOffice documents are just a bunch of XML files zipped together.
Change the extension to *.zip and use your favorite unzipping program
to see for yourself.

Waldemar
_______________________________________________
python-win32 mailing list
python-win32 at python.org
http://mail.python.org/mailman/listinfo/python-win32



-- 
http://www.goldwatches.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20080826/27b26e74/attachment-0001.html>