Naming Excel Tabs

[StephenT]

Hi all,
I've been looking for a way to name output Excel tabs (not the workbook itself), in a specific format, but haven't has any luck. Apologies if this question has been asked previously.

I run a weekly process  where I email managers when their subordinates have not returned their IT equipment on leavin the firm. We need to retain the weekly data therefore new tabs need to be created

threnaming format will need to be as follows :

Coach emails for "Datatype' - "Run Date" (eg  Coach emails for Departers - 2022-11-01 OR  Coach emails for LoA - 2022-11-01

The data type and run date are existing fields created in the workflow and are displayed in the output

[Felipe_Ribeir0]

Hi @StephenT 

Could you please share a sample of your input and your expected output?

I could not exactly understand what you want to do.

[gabrielvilella]

I am not sure if I understood what is your problem. You can create the name of the sheet on a formula tool for example and use this field on the output data tool.

[davidskaife · Accepted solution]

Hi @StephenT 

You will need a Formula tool with the following setup, replacing the filepath, filename etc:

Then in your Output tool you want it set like this, taking note of the highlighted areas:

That will then output to the file and write a new tab each time it is ran. Note that the naming format you're wanting to use actually causes an error as it's too long for a tab name so you might want to think of shortening it.

I've attached a sample workflow for you to look at as well!

[StephenT]

 Thanks @davidskaife 
After a few 'user errors' I managed to got your solution working - that's exactly what i was trying to do and thanks for the reminder about the file/tab length

[kauser]

@davidskaife  this solution is very helpful for me and i am able to create new tab with new name. now i am having issue to add data in this new tab. for example can you show me how to add data into this new tab to a specific cell. i mean if want to add a data into Cell B10 to this new tab for +[Data]+"-"+[Date]. 

[davidskaife]

Hi @kauser 

To write to a specific cell, or range of cells, simply change the end of the formula to something like below:

"<file path>\Test Output.xlsx|||'Emails for "+[Data]+"-"+[Date]+"$B10:B10'"

Posting to one cell still requires a range (i.e B10:B10) otherwise it will error on opening the spreadsheet