Add empty excel sheets with column headers to excel with multiple tabs

[nkrupabd]

Hi,

I have used a render tool for producing multiple tabs in a single excel but need to add few more excel sheets that has just column headers,
Can someone help me with this please.

[HomesickSurfer · Accepted solution]

Hi @nkrupabd 

Use a Text Input tool containing the column headers in record 1, add a formula tool named 'Sheetname' and expression 'Empty Sheet' or whatever you like...Union with your other data, Layout then Render with Sheetname as separator.  Use multiple Test Input tools for additional sheets

[nkrupabd]

Thank you