Pywin32: How to import data into Excel?

[Tim Golden]

[Tim Golden]
> + When trying to automate anything in Excel, it's
>   usually illuminating to record a macro which does
>   what you want, and then to translate that VBA code
>   into Python.
> 

[Duncan Booth]
> Another suggestion: when automating Excel, turn off the automatic 
> recalculation (set Application.Calculation=xlManual) and then turn it
back 
> on again when you have finished.

> If you don't do this, Excel will attempt to recalculate the sheet
after 
> every update to a cell. Even if you don't have any formulae
referencing the 
> cells you change it still makes a big difference.

Thanks. Didn't know that.

TJG

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________