Search code examples
xlwingspython-pptx

xlwings: copy range and save as an image


I have an excel table that I am building using python logic via xlwings. Once calculated, I would like to copy that table (ie its range) and save it as an image (similar format to select range -> copy -> right click -> paste as image ). End goal is to use pptx to include the table in a powerpoint presentation

Is this possible?


Solution

  • I found that the best solution for this is to embed the excel range into the powerpoint presentation.

    Copy your excel range, go to the ribbon and click on the triangle under 'Paste', 'Paste Special', 'Paste Link'

    This will automatically reflect the changes in the presentation