Excel file interface for Python 2.3?

[Hamilton, William]

I'm in need of a module that will let me create Excel workbooks from within
Python. Something like PyExcelerator, but it needs to work with Python 2.3.
(A third-party limitation that I have no control over.) Can anyone point me
to what I need? All my searches keep leading back to PyExcelerator.

--
-Bill Hamilton

[John Machin]

On Jun 12, 11:01 pm, "Hamilton, William " <[e-mail]:

I'm in need of a module that will let me create Excel workbooks from within
Python. Something like PyExcelerator, but it needs to work with Python 2.3.
(A third-party limitation that I have no control over.) Can anyone point me
to what I need? All my searches keep leading back to PyExcelerator.

xlwt is a fork of pyExcelerator that I'm maintaining. It works with
Python 2.3 and later.

https://secure.simplistix.co.uk/svn/xlwt/trunk

[kyosohma]

On Jun 12, 8:01 am, "Hamilton, William " <[e-mail]:

I'm in need of a module that will let me create Excel workbooks from within
Python. Something like PyExcelerator, but it needs to work with Python 2.3.
(A third-party limitation that I have no control over.) Can anyone point me
to what I need? All my searches keep leading back to PyExcelerator.

--
-Bill Hamilton

You can also use COM if you're on Windows, via PyWin32. Hammond's book
talks about it a little here: http://www.oreilly.com/catalog/pytho...pter/ch12.html

I also saw some information about this in Core Python Programming by
Chun.

Example code follows:

<code>

import win32com.client as win32
def excel():
app = 'Excel'
xl = win32.gencache.EnsureDispatch('%s.Application' % app)
ss = xl.Workbooks.Add()
sh = ss.ActiveSheet
xl.Visible = True
sleep(1)

sh.Cells(1,1).Value = 'Python-to-%s Demo' % app
sleep(1)
for i in RANGE:
sh.Cells(i,1).Value = 'Line %d' % i
sleep(1)
sh.Cells(i+2,1).Value = "Th-th-th-that's all folks!"
ss.Close(False)
xl.Application.Quit()

</code>

Admittedly, COM is kind of confusing. But it's there if you need it.

Mike

[kyosohma]

On Jun 12, 8:38 am, [e-mail] wrote:

On Jun 12, 8:01 am, "Hamilton, William " <[e-mail]:

I'm in need of a module that will let me create Excel workbooks from within
Python. Something like PyExcelerator, but it needs to work with Python 2.3.
(A third-party limitation that I have no control over.) Can anyone point me
to what I need? All my searches keep leading back to PyExcelerator.

--
-Bill Hamilton

You can also use COM if you're on Windows, via PyWin32. Hammond's book
talks about it a little here:http://www.oreilly.com/catalog/pytho...pter/ch12.html

I also saw some information about this in Core Python Programming by
Chun.

Example code follows:

<code>

import win32com.client as win32
def excel():
app = 'Excel'
xl = win32.gencache.EnsureDispatch('%s.Application' % app)
ss = xl.Workbooks.Add()
sh = ss.ActiveSheet
xl.Visible = True
sleep(1)

sh.Cells(1,1).Value = 'Python-to-%s Demo' % app
sleep(1)
for i in RANGE:
sh.Cells(i,1).Value = 'Line %d' % i
sleep(1)
sh.Cells(i+2,1).Value = "Th-th-th-that's all folks!"

ss.Close(False)
xl.Application.Quit()

</code>

Admittedly, COM is kind of confusing. But it's there if you need it.

Mike

Oops...forgot that to mention that I import the sleep function from
the time module in the above code. Sorry about that.

Mike