Search code examples
pythonexcelchartsexport-to-excel

use python to generate graph in 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.

Solution

  • 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.