Excel File Output tab names

[joenewman]

I'm trying to output multiple excel files, with multiple different tab names. It seems to work using the highlighted method at the top... but not below when attempting to add the path. Any help appreciated, thanks.

[alexnajm]

Hi @joenewman,

It'll be difficult to diagnose without seeing the configurations of the Formulas and the Render tools - is it possible to send screenshots of those, or better yet the workflow itself with some of the information redacted?

-Alex

[apathetichell]

Without more information my hunch is you are adding sheet name to a path you are trying to write to in Render. That's not how Render works. Sheet's are vertical section breaks in the layout tool in Render.

In addition once rendered - you cannot write to the same file again in a second render tool - you will overwrite the original.

[joenewman]

Hi @alexnajm @apathetichell 

See the attached workflow.

Thanks.

[alexnajm]

Hi @joenewman,

It worked for me after changing the "Output File" in the Render tool from "test.xlsx" to ".\test.xlsx"!

-Alex

[joenewman]

Hi @alexnajm , 

Thank you for this! The problem I seem to be having now is it should be outputting a each table to a different tab with the respective area of concern as the tab name. It all seems to be outputting to one tab and using the Area of Concern from the first table as the tab name.

Again - Any help is appreciated.

Thanks.

[alexnajm]

Hi @joenewman,

Awesome! The sheet name should be added in that same Formula tool - so ...".xlsx|||Sheet1$" or ".xlsx|||"+[SheetName].

Once you feel good about the solution, can you accept it as a solution? Thank you!

-Alex

[apathetichell]

@alexnajm  - that format is for output data. For render that will break your file... 

@joenewman reconfigure your layout tool to this

remove your formula tool after

note:  you can render a file exactly 1 time. If you render to the same file more than one time - each successive render tool will overwrite it.

[apathetichell]

@joenewman- can you mark the solution as correct and confirm that you fixed your layout tool and removed the sheet specifier from the final render column?