Using Render tool to format multiple sheets in the same file

User1

Hello,

I built a workflow that creates rows of data, which I want to export to several separate excel files.
For this, I generated a Field "File Address" that contains the full path (FilePath) where I want to save my grouped data.

Important information : some of the FilePath drive to the same excel file, but with different sheet names.

I can easily generate my Excel files with the Output Tool, with workbooks and worksheets with the right names and in the right folders.

However, I would like to give a basic format to these recorded files:
• HEADER in bold, colored.
• If possible, but not mandatory, Columns with optimized widths

I tried many things, via the Table tool and Render Tool but without success. I still have this error: "Error: x64 Designer: x64 Designer: InboundNamedPipe :: ReadFile: Not enough bytes read. The communication channel has been closed. "

I think that this comes from the generation of different sheets at the same time, in the same file.

You will find attached my simplified data and workflow.

Is it possible to render different sheets in the same file with the render tool ?

Does someone have an idea to fix it ?

Thank you very much for your help.

Data_To_Render.yxmd

danrh

Take a look at the attached.

In the Table tool, group by the fields that contain the sheet names and the file names.  In the Layout tool, select "Each Group of Methods" as your Layout Mode, group by both the sheet and file names again, and set Orientation to "Vertical with Section Breaks".  If you want to re-name the tabs in the excel file, change Section Name to whatever field has the tab names.  In the Report Text tool, select that you want to "Attach text to existing field" and select the "Layout" field.  Insert/format fields and/or text to your liking in the text box.  In the Render tool, select to "Group Data Into Separate Reports" with a Separator of "Insert Section Breaks Between Records".

You'll need to play around until the formatting is how you need it, but this should get you pretty close.

Good luck!

solution.yxmd