Two tables into one excel file with Render

Hi All,

I created two tables (one for data that needs to be entered, one for data that has duplicates) from a large excel file and I want to save them into the same excel file, but in two different sheets. I tried using the layout tool but I would end up with the two tables in the same sheet.

Any suggestions?

Reporting

Output

Accepted answers

binu_acs

@JMill attaching a sample workflow which matches your requirement

20201126 - RenderToMultipleTabs.yxmd

All comments

davidskaife

Hi @JMill

Is there a specific reason you need to use the Render tool? You can accomplish the same thing using the Output tools:

Point both outputs to the same Excel file, remembering to change the Sheet name, and change the Output Option to 'Overwrite Sheet or Range'. I'd stick a 'Block Until Done' tool in as per the example so that each section of the workflow finishes before the next runs so you don't get errors with Excel still being open.

I've attached a sample workflow for you to look at.

David

Multiple Tab Output.yxmd

binu_acs

@JMill attaching a sample workflow which matches your requirement

20201126 - RenderToMultipleTabs.yxmd

JMill

This worked great! Thank you for your help

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335