Exporting Image to an Existing Excel File

[Skapoor1]

Hi All 

I have been trying to export an image from my disk to one of the tabs in an existing excel file . The aforementioned excel file contains different tabs. I want to export the image in a new tab. I am using render tool but i have not been able to write it to a new tab within this file. It prompts me to a separate file.

Can you please guide!

Thanks in advance.

[DavidP]

Hi @Skapoor1 

The Render tool can not append data to an existing Excel file - it will always overwrite the file.

The only way that I know to get around this in Alteryx is to load the data from all the sheets with input data tools and then use the Reporting tools to rebuild your entire Excel file, including your new image.

If there is no formatting on the other sheets in the file, you could do the same as above, but then use the Render tool to create an excel file with just the image and then use Output Data tools to create the other sheets in the same file. 

If you can share some data (input and expected output), we can help you better.

[Skapoor1]

Hi DavidP 

Thanks for your reply. I have an excel file with multiple tabs and an image produced from other process. I want to produce an output file with other tabs as is and an additional tab with just the image. I have also attached the output for your reference.

[Skapoor1]

Hi @DavidP 

Thanks for your reply. I have an excel file with multiple tabs and an image produced from other process. I want to produce an output file with other tabs as is and an additional tab with just the image. I have also attached the output for your reference.

[csmith11]

This topic came up in a more recent post where I added a possible solution. See discussion below.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-embed-picture-in-an-existing-ex...