Skip to main content
Question

How to duplicate a XLS writer but unlink them from automatic updating?

  • July 31, 2017
  • 7 replies
  • 14 views

Forum|alt.badge.img

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

7 replies

Forum|alt.badge.img
I have created a rather complicated XLS writer, I duplicated it as need 2 writers. All is good here.

 

Now I need to be able to have different file names when writing, but when changing one, it "inherits" the changes to the duplicated writer.

 

How can I achieve 2 files with the same writer structure and parameters?

 

 


Forum|alt.badge.img
any ideas out there?

 

 


trentatsafe
Safer
Forum|alt.badge.img+6
  • Safer
  • 278 replies
  • August 2, 2017

Hi @hectorborromadr,

 

Are you able to just copy and paste the writer, rather than clicking the duplicate option? I believe, the copy and paste will keep the settings on the writer, while not being directly linked to one another.

Forum|alt.badge.img

thanks @trentatsafeI tried both ways... Copy-paste and Duplicate, and same thing....


fmelizard
Safer
Forum|alt.badge.img+20
  • Safer
  • 3719 replies
  • August 2, 2017

Hi @hectorborromadr, you can try fanning out in the Navigator based on an attribute. This will give you multiple Excel spreadsheets with different names while maintaining the attribute definitions you've created in your workspace.


fmelizard
Safer
Forum|alt.badge.img+20
  • Safer
  • 3719 replies
  • August 2, 2017

Hi @hectorborromadr, you can try fanning out in the Navigator based on an attribute. This will give you multiple Excel spreadsheets with different names while maintaining the attribute definitions you've created in your workspace.

 

Check out this similar post: Excel Worksheets

Forum|alt.badge.img

Hi @hectorborromadr,

 

Are you able to just copy and paste the writer, rather than clicking the duplicate option? I believe, the copy and paste will keep the settings on the writer, while not being directly linked to one another.
Hi, yes, I tried both ways with the same results