{Spam?} [python-win32] Having more Excel troubles.

[Bob Gailer]

At 03:36 PM 8/25/2004, Joe Goldthwaite wrote:
>Hello Again,
>
>I thought I had all my problems worked out then I ran head on into another
>one.  The application I've been trying to develop is Zope based.  I've got
>some financial reports that they can browse through using a web interface.
>What I'm trying to do is have a link on the page that will download the
>report they're viewing into a local Excel worksheet.
>
>I decided to use com because I want the worksheet to have colors, print
>settings, formatting, etc. that I already have working in VB.  I've looked
>into XML and Pyxlwriter but it looks like a new learning curve compared to
>just translating my VB com commands into Python.

I just remembered that sometimes I put the Excel VB code into an Excel 
module and invoke the module from the Python side. You might give that a 
try. In some cases that has saved my butt when (due to an Excel com bug) I 
could not set a particular property, so I wrote the VB module to set the 
property and called it from Python. This can also result in a performance 
improvement. (Especially in Word is this true).
>[snip]

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625 home
720 938 2625 cell