python win32com excel problem

[NO_SPAM]

Bart Willems wrote:
> Ray wrote:
>> Hi,
>> I tried to call "xlApp.Columns.AutoFit=1" the whole program will crash,
>> but without xlApp.Columns.AutoFit=1, everything just fine.
> 
> Autofit is a method. Also, columns are a method of a worksheet - try:
> xlApp.Worksheets.Columns("C:K").Autofit()
> (or whatever columns you need of course)
> 
>> 2. How do I set a rows format? I need to set row "F" to "Text", 
>> "o","p" to general, and
>> "Q", "R", to currency.
> 
> Same story: you will need to define the range first.
> xlApp.Worksheets.Rows("10:200").Numberformat = "General"
> I think that you actually mean columns, and not rows - columns have 
> character designators, rows have numbers. In that case, try something 
> like xlApp.Activesheet.Columns("F") = "@" (text format), or the other 
> appropiate codes for number formatting as required. I usually pick 
> "#,##0.00" to display numbers with two decimals and thousands seperators.
> 
> Cheers,
> Bart
Thanks a lot!!

Ray