Automating Excel macro using python

I am using python in Linux to automate an excel. I have finished writing data into excel by using pyexcelerator package.

Now comes the real challenge. I have to add another tab to the existing sheet and that tab should contain the macro run in the first tab. All these things should be automated. I Googled a lot and found win32come to do a job in macro, but that was only for windows.

Anyone have any idea of how to do this, or can 开发者_开发知识库you guide me with few suggestions.

---

Excel Macros are per sheets, so, I am afraid, you need to copy the macros explicitly if you created new sheet, instead of copying existing sheet to new one.

---

You might find that Resolver One is better for what you want - it's a python-scriptable spreadsheet.

---

Maybe manipulating your .xls with Openoffice and pyUno is a better way. Way more powerful.