output data to excel in different tabs

Question

Hi,

I have segregated my output into different containers and now i want to output container wise data into different tabs. For instance, i have one set of tools in a container which is generating high level information so that needs to be pasted on first tab. then in second contained information is drilled down to 1 more level and wish to paste it to second tab and so on. Please help how can I do that.

CKP · Accepted Answer

Hi @SamSurya

Here is a sample workflow that splits data to 2 different Excel tabs within the same workbook. You'll need a Block Until Done tool to prevent the file being in use when saving each tab.

To name the tabs, in the output tool, add 3 pipes after the file name followed by the tab name. Example: MultiTabExample.xlsx|||TabA

I hope this helps