Is there a way to push data into Microsoft Excel & Word from Python ?

T

The Night Blogger

Is there a way to push data to Microsoft Excel & Word from a Python
Application

Is this a cross platform feature ? I'll need to push data on MS Windows &
Mac OS X ....
 
C

Caleb Hattingh

The said:
Is there a way to push data to Microsoft Excel & Word from a Python
Application

On Windows, it's easy after you install the win32 extensions. For
example, for
python:

import win32com.client
xl = win32com.client.Dispatch('Excel.Application')

after which you can operate on "xl" (almost) as if you were coding in
VBA. I have driven Excel from python a /lot/, and it works well.
Paul Boddie has written a great tutorial---which includes some Outlook
examples, btw---over here:

http://thor.prohosting.com/~pboddie/Python/COM.html
Is this a cross platform feature ? I'll need to push data on MS Windows &
Mac OS X ....

I have zero OSX experience, but 30s of googling brings up this:

http://appscript.sourceforge.net/

Kevin Walzer mentions on this mailing list entry:

http://mail.python.org/pipermail/python-list/2006-August/400255.html

that Excel provides reasonably good support for applescript, but again,
I have no idea whether these things work; I'm just doing your googling
for you.

Assuming applescript works, you may want to write a thin wrapper over
the combination of the win32 COM interface and the applescript
interface that at least lets your business logic sit in one place. The
wrapper can use the right API depending on the platform it finds itself
on at runtime.

Regards
Caleb
 
J

John Machin

The said:
Is there a way to push data to Microsoft Excel & Word from a Python
Application

Is this a cross platform feature ? I'll need to push data on MS Windows &
Mac OS X ....

Depends on what you mean by "push". If you wish to create Excel files
but not update existing ones, you might consider pyExcelerator. It is
pure Python and therefore will run on any platform that Python will.
http://cheeseshop.python.org/pypi/pyExcelerator/

Cheers,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top