python excel生成图_使用python在excel中生成图形

I have been trying to generate data in Excel.

I generated .CSV file.

So up to that point it's easy.

But generating graph is quite hard in Excel...

I am wondering, is python able to generate data AND graph in excel?

If there are examples or code snippets, feel free to post it :)

Or a workaround can be use python to generate graph in graphical format like .jpg, etc or .pdf file is also ok..as long as workaround doesn't need dependency such as the need to install boost library.

解决方案

You have 2 options:

If you are on windows, you can use pywin32 (included in ActivePython) library to automate Excel using OLE automation.

from win32com.client import Dispatch

ex = Dispatch("Excel.Application")

# you can use the ex object to invoke Excel methods etc.

If all you want to just generate basic plots etc. you can use matplotlib.