Change Excel sheet name in file generated from Render tool

[mb1824]

Hi,

The attached workflow does what I want except for 1 thing:

The Excel file has sheet names "sheet1" & "sheet2".

Is there a way to change this (without opening the file and manually changing them)

Ideally I want the sheet names to be the same as the field names fed into the Layout tool.

[DavidP · Accepted solution]

I modified your workflow to define the Sheet Names in the output file. See attached, specifically the configuration of the layout tool.

[mb1824]

@DavidPthanks very much for your help!

[vijaylnyadav]

Thanks @DavidP this workflow helped me alot.

[FreeRangeDingo]

@DavidP I'm trying to use this solution and the columns come out huge.  I've tried changing the layout width several different ways but it never works.  I had it set up as Horizontal and it worked but I need multiple named sheets.  Any suggestions?

[Computernerd]

Thanks!  That was just what I needed.

[germaiine]

the workflow works! however, how do i have the sheets to still be generated with the respective headers and sheet name even if there is no data? thanks!