Dynamic Excel sheet names

[JCornn]

I have a workflow that gathers the file paths of Excel files in a directory, then creates a field called [SheetPath], in which the [FullPath] of every .xlsx file in the directory is combined with “|||’Sheet 1 $’”. The screenshot below is of a demo workflow that shows what I am currently doing:

What I am wondering is if it is possible for me to generalize the expression in the formula tool to allow for [SheetPath] to replace “Sheet 1” with any given sheet name (e.g. “Sheet A”, “Sheet B”, etc.)?

Note: To be clear, the screenshot above is only an example; it is not my actual workflow. Please assume that I am not able to pass the [FullPath] field from beginning to end in my actual workflow.

[JagdeeshN · Accepted solution]

Hi @JCornn ,

You can possible do this by changing the file URL in a  Formula Tool. That way you can dynamically assign the sheet name and within the output toll change the entire path.

Hope this helps.

Best,

Jagdeesh

[JCornn]

Hi @JagdeeshN ,

I have not used that process before. Would you have an example?

Thank you

[JagdeeshN]

Hi @JCornn,

Please find attached a sample workflow.

Hope this helps.

Best,

Jagdeesh