How do I create a sheet in excel when my results come up with no data?

[helenjin1]

I'm running a workflow that creates multiple sheets in one excel. Some of the sheets sometimes will result in no data. I want to still create a sheet for that result. How do I do so?

[BrandonB · Accepted solution]

You can union a text input (configure the union tool to have this in second position) at the end with the same headers but no values in the cells so that way it will still write the headers without any data. When there is data there will simply be a row of nulls at the bottom which won't be visible in Excel below your normal data, but when there isn't any data, it will still write the Excel sheet.