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.