{"id":3389,"date":"2023-02-27T20:00:00","date_gmt":"2023-02-27T11:00:00","guid":{"rendered":"https:\/\/python-academia.com\/en\/?p=3389"},"modified":"2023-02-26T21:56:33","modified_gmt":"2023-02-26T12:56:33","slug":"matplotlib-excel-paste","status":"publish","type":"post","link":"https:\/\/python-academia.com\/en\/matplotlib-excel-paste\/","title":{"rendered":"[matplotlib]How to Insert Graphs into Excel"},"content":{"rendered":"\n

This article shows how to insert graphs into Excel.<\/span><\/p>\n\n\n\n

<\/i>Contents<\/span><\/p>

\n

\u25c6How to insert a graph created using matplotlib into Excel.<\/p>\n\n\n\n

  • How to save a graph as an image and then insert it into Excel<\/li>
  • [Supplement]How to keep a graph in PC memory and then insert it into Excel<\/li><\/ul>\n\n\n\n

    <\/p>\n<\/div><\/div>\n\n\n\n

    <\/div>\n\n\n\n

    How to save a graph as an image and then insert it into Excel<\/h2>\n\n\n\n

    I show how to save a graph as an image and then insert it into Excel.<\/span><\/p>\n\n\n\n

    By using “openpyxl”, a graph is inserted into Excel.<\/p>\n\n\n\n

    <\/div>\n\n\n\n

    This is the example code.<\/p>\n\n\n\n

    import matplotlib.pyplot as plt\nimport openpyxl\n\n\npath_fig = r'test\\test.png'\npath_excel = r'test\\test.xlsx'\n\n\n\n# Create graph\ndata_x = [1,2,3,4,5]\ndata_y = [x*x for x in data_x]\n\nfig, ax = plt.subplots(figsize = (5,5), facecolor='lightblue')\n\nax.plot(data_x, data_y, linestyle='solid', marker='o')\n\nax.set_xlabel('x')\nax.set_ylabel('y')\n\nplt.show()\nfig.savefig(path_fig)\n\n\n\n# Insert graph into excel\nwb = openpyxl.load_workbook(path_excel)\nsh = wb.create_sheet('graph')\n\nimg = openpyxl.drawing.image.Image(path_fig)\nsh.add_image(img, 'B2')\n\nwb.save(path_excel)\nwb.close()<\/code><\/pre>\n\n\n\n
    <\/div>\n\n\n\n
    When the above code is executed, a graph is inserted into Excel.<\/p>\n\n\n
    \n
    \"\"<\/figure><\/div>\n\n\n
    <\/div>\n\n\n\n
    > fig.savefig(path_fig)<\/p>\n\n\n\n
    Save the graph as an image using “savefig” method.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    > wb = openpyxl.load_workbook(path_excel)
    > sh = wb.create_sheet(‘graph’)<\/p>\n\n\n\n
    An existing Excel file is opened and a new sheet is created.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    > img = openpyxl.drawing.image.Image(fig_path)
    > sh.add_image(img, ‘B2’)<\/p>\n\n\n\n
    By using “openpyxl”, the graph is loaded and pasted at “B2 cell”.<\/p>\n\n\n\n
    <\/div>\n\n\n\n
    sponsored link<\/p>\n\n\n\n\n
    \n