Encountered non-unique sheet names

0     3     Edited Jan 18, 2017 by Anonymous

I receive the following error message while looping on sheets: "Encountered non-unique sheet names".

I only receive this when I rename the sheet from its original title (“Sheet”). If I do make the name change, reverting the name back to “Sheet” does not solve the issue. I was wondering if there was a way to solve this problem without creating a new sheet and pasting everything over. Furthermore, if there’s a way to name the exported pages (perhaps with the @groups1 names?) that would be excellent to hear!


Comments

0

Rob Smith Jan 18, 2017

If you delete the sheet name altogether (click to edit, then delete all characters and leave it blank), then RB will automatically assign a unique sheet name upon export.

The other option is to create a unique sheet name using syntax and loop iteration values. In order to use syntax in the sheet name, you enclose the syntax in curly braces. And an example of a loop iteration value is @label. So here’s an example of what you could use for the sheet name:

{@label}

The above would use the label of the loop instance as the sheet name. Just keep in mind that names in Excel have restrictions on length and don’t allow certain special characters – so you’ll probably want to keep the labels simple and short.

0

Keeping the name null and including a bracketed {@groups1} seemed to allow for export. The bracketed names still produced “Sheet 1”, “Sheet 2”, etc. however, when the names were “Banner 1” “Banner 2” etc. Should I be calling a different iteration value? – Anonymous 1/18/2017 2:40:39 PM

0

It makes sense that the export succeeded using `{@groups1}` since the values are unique— but yes, you should be using `{@label}` instead of `{@groups1}`. Groups1 is the name of the variable that contains your banner groups, but instead you want the variable that contains your label. – Rob Smith 1/18/2017 2:41:24 PM

Leave a Comment

Please sign in to leave a comment.