Reporting in an existing Excel Spreadsheet

Question

Good afternoon,

My workflow builds a lot of data and outputs it to different Excel tabs.   As a final step, I merge and summarize the data then flow through a Table, Layout and Render Tool to export the final piece of data into that same Excel spreadsheet.    My render tool is exporting multiple report tabs based on a field in the data but it corrupts my Excel spreadsheet and removes several of my existing Tabs.   How do I get it to output my report without blowing away the other tabs.

Also.....The file that it outputs to needs to be entered by the app user.   I use a file browse tool and an Action Tool to get the file name to the Output tool.   I tried to use an Action Tool to update the value in the Render tool.....That didn't seem to work.  Anybody have a solution for that as well?

Thanks

LordNeilLord · Accepted Answer

Hey @MarshaThompson

Using the render tool is going to have this affect, do you need to use the render tool?

You can just as easily write to multiple sheets using the standard output tool