Change Excel sheet name in file generated from Render tool
- 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
Hi,
The attached workflow does what I want except for 1 thing:
The Excel file has sheet names "sheet1" & "sheet2".
Is there a way to change this (without opening the file and manually changing them)
Ideally I want the sheet names to be the same as the field names fed into the Layout tool.
Solved! Go to Solution.
- Labels:
- Reporting
- 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
@DavidPthanks very much for your help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @DavidP this workflow helped me alot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DavidP I'm trying to use this solution and the columns come out huge. I've tried changing the layout width several different ways but it never works. I had it set up as Horizontal and it worked but I need multiple named sheets. Any suggestions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks! That was just what I needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
the workflow works! however, how do i have the sheets to still be generated with the respective headers and sheet name even if there is no data? thanks!