Skip to main content
Question

Write to single excel file from multiple sources

  • December 12, 2019
  • 2 replies
  • 87 views

Forum|alt.badge.img+2

Hi, I am working on a project to identify attribute values that do not match for many SDE layers (26 total). I would like to write the results into separate sheets within the same excel file; however, I currently am only able to write one sheet at a time in the same excel file. I would appreciate some advice and suggestions!

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.

2 replies

Forum|alt.badge.img+2
  • Author
  • December 12, 2019
For some reason I am not able to insert a screenshot.. I keep trying but receive an error message saying "Something Went Wrong".

Forum|alt.badge.img
  • December 12, 2019

Use a FeatureWriter. When you select Excel as format you will see that you can create multiple input ports to the transformer by dragging a connection to the "Connect Input" port. Each input port you create gives you an extra feature type when you open the parameters for the FeatureWriter and each feature type can be defined as a separate sheet in the excel file. This should do the trick for you. :-)