win32 question in Python

Ali aafshar at gmail.com
Tue Jul 31 12:28:31 CEST 2007


On Jul 30, 11:49 pm, Brad Johnson <Brad.John... at ballardtech.com>
wrote:
> Huang, Shun-Hsien <shuang <at> ercot.com> writes:
>
>
>
> but how do I copy a excel file into
>
> > database table by using Python?
>
> I'm not sure if this helps, but you can access the Excel Automation model very
> easily with:
>
> import win32com.client
>
> x1 = client.Dispatch("Excel.Application")
>
> Now you can use the x1 object to access any of the properties and methods in the
> Excel Automation model.

I have only used this to export data as Excel, but it may fulfill your
needs for importing:

http://sourceforge.net/projects/pyexcelerator/

Ali




More information about the Python-list mailing list