Can I insert matplotlib graphs into Excel programmatically?

by

Openpyxl actually does support image embedding, and might work better for those using .png or existing .xlsx files! The code below appends an image to cell A1 of input.xlsx and saves the file as output.xlsx.

import matplotlib.pyplot as plt
import openpyxl

# Your plot generation code here...
plt.savefig("myplot.png", dpi = 150)

wb = openpyxl.load_workbook('input.xlsx')
ws = wb.active

img = openpyxl.drawing.image.Image('myplot.png')
img.anchor(ws.cell('A1'))

ws.add_image(img)
wb.save('output.xlsx')

EDIT 2023: Looks like people are still reading this almost 7 years later! I’ve updated Line 7 in the original code to reflect the update for those copy/pasting.

EDIT June 2020: I’ve been informed openpyxl has changed since time of writing. Line 7 has been changed from:

img = openpyxl.drawing.Image('myplot.png')

img = openpyxl.drawing.image.Image('myplot.png')

There is an extra .image in there now.

More Related Contents:

  1. How can I plot separate Pandas DataFrames as subplots?
  2. Heatmap in matplotlib with pcolor?
  3. Histogram Matplotlib
  4. Format y axis as percent
  5. Aligning rotated xticklabels with their respective xticks
  6. matplotlib: overlay plots with different scales?
  7. How can I remove the top and right axis in matplotlib?
  8. Python Matplotlib figure title overlaps axes label when using twiny
  9. How to display a 3D plot of a 3D array isosurface in matplotlib mplot3D or similar?
  10. matplotlib.pyplot will not forget previous plots – how can I flush/refresh?
  11. custom matplotlib plot : chess board like table with colored cells
  12. 3D animation using matplotlib
  13. How to plot and annotate grouped bars in seaborn / matplotlib
  14. How do you plot a vertical line on a time series plot in Pandas?
  15. Updating z data on a surface_plot in Matplotlib animation
  16. Repeating x axis labels for all facets using FacetGrid in seaborn
  17. Plotting: ValueError: x and y must have same first dimension
  18. How to force integer tick labels
  19. Edit existing excel workbooks and sheets with xlrd and xlwt
  20. datetime x-axis matplotlib labels causing uncontrolled overlap
  21. Python matplotlib decrease size of colorbar labels
  22. canvas.mpl_connect in jupyter notebook
  23. Move spines in matplotlib 3d plot?
  24. Combine two Pyplot patches for legend
  25. Plotting a 3d cube, a sphere and a vector
  26. How do I align gridlines for two y-axis scales?
  27. Change tick frequency on X (time, not number) frequency
  28. Specifying the order of layers
  29. automatically position text box in plot
  30. Matplotlib – Wrong overlapping when plotting two 3D surfaces on the same axes

Leave a Comment