output data to excel in different tabs

[SamSurya]

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 solution]

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

[SamSurya]

sorry for late reply..... It really worked... thank you 🙂