I am trying to take a render output and appending it to an Excel document (if possible).
What I’m doing is I created a chart in the Interactive Chart tool and rendered it to an Excel file. Now I want to take these charts and append them to another Excel file's sheet that already has summary data.
Solved! Go to Solution.
Hi -
So I don’t have a solution for the method as you describe it, but it is possible another way. The render tool doesn’t have any option to only overwrite a sheet, so it just makes a new file every time.
The solution is to create a full report that combines the summary table with the graphs and renders them at the SAME TIME to the desired excel file.
Sample workflow as follows, hope this helps!