[python-win32] Fwd: [Tutor] Format columns in Excel

[Terje Johan Abrahamsen]

I am trying to change a column in Excel with Win32Com. So far I have
tried this:

class chkxl:
    xlApp = Dispatch("Excel.Application")
    xlApp.Workbooks.Open("agent.xls")
    agent = xlApp.Workbooks("agent.xls").Sheets("Sheet1")
def __init__(self):
    chkxl.agent.Columns(10).Style.Name = "number"

(There is more to it, so for example chkxl.agent.Cells(2,2).Value =
"Hello" works)

The style.Name = "number" I found with the helper in Excel. It is
supposed to work in VBA, but doesn't seem to work in Python. What
would I write to get it to make the column into numbers?

Thanks,
Terje





_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com