Render PNG to Paste in Excel?

[heatherkeyser]

Hi ya'll. I'm wondering if it's possible to have Alteryx lay the PNG that I create with Render into an excel sheet in certain cells? 

[jrlindem]

Interesting question.  I don't think you can do this directly with any of the render or normal output tools.  But I do think you can do this with the Python tool in Alteryx.  I've never done it myself so can't provide an example, but maybe others can chime in.  I did a quick search on this, and the results suggest using the openpyxl or xlsxwriter libraries to help accomplish this.

Hope that helps,  -Jay

[heatherkeyser]

Thanks Jay! I was also seeing Python as a potential solution, but it is far from my strong suit. It would be awesome if someone could help me figure it out though since it's the last step in my routine that I'm trying to make completely automated (meaning, instead of having to copy and paste the Rendered images into my output excel)

[jrlindem · Accepted solution]

Since an Alteryx workflow stream, when being brought into Python, is treated as a dataframe, you should be able to take what you have and then adapt that into Python.

Quick internet search + copilot (or LLM or your choosing) suggests this shouldn't be too big a lift (I say that with completely no comprehension of what it will actually take lolol).  Here's a stackoverflow article that talks about the Python side....

How to fit an image exactly inside an Excel cell using Python and XlsxWriter? - Stack Overflow

Sorry I'm not of more direct help, but maybe this gets you closer.  -Jay