Dynamic Excel sheet names
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator