Writing to ms excel

[Leonhard Vogt]

Marin Brkic schrieb:
> I'm trying to find a way to write data to excel cells (or to be more
> specific to an .xls file), let's say for the sake of argument, data
> readen from a file (although it will be calculated in the process).
> I've been searching, but couldn't find any examples which allows that.

If you have Excel installed you can use COM to access Excel and to
"remote-control" it in order to save a .xls file.

I have no Windows nor Excel at the moment, so I can only write something
approximative. Searching for win32com will help.

win32com.Coinitialize(...)
excel = win32com.client.Dispatch("Excel.Application")
wbook = excel.NewDocument()
sheet = wbook.Worksheets("Sheet1")
sheet.Cells(1,1) = "Abc"
wbook.Saveas("filename")
excel.close() or destroy()
win32com.coUninitialize()

The objects available are very similar to the VBA objects, so recording
a macro and translating its VBA source to python should not be hard.

HTH
Leo