Skip to main content
Solved

Excel Writer : Control default sheet


lgrie
Contributor
Forum|alt.badge.img+7
  • Contributor

Hello,

a while ago a user suggested to implement an "Option to control default sheet on Excel writer"

Does anyone know if this is now possible ? I am writing an Excel file with up to 100 sheets and I want to force Excel to open the first sheet by default.

 

Thanks.

Best answer by nielsgerrits

lgrie wrote:

Thanks for your suggestion, Niels.

What I did not mention is that I am using a FeatureWriter with three different entries:

My first desired sheet is a recap, misting all other sheets, which I create seperately.

Than I have my sheets and the third entrie is a ssheet listing errors occured during the process.

 

So I am not sure if your suggestion does the trick. But it is a great starting point.

I think it does, sample workspace attached.

View original
Did this help you find an answer to your question?

4 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

I do not know of an option in the writer. But I believe the last written sheet is the active one. So as a workaround, with AttributeCreators creating an order attribute, a Sorter and an AttributeFilter you can force this.


lgrie
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • May 17, 2023

Thanks for your suggestion, Niels.

What I did not mention is that I am using a FeatureWriter with three different entries:

My first desired sheet is a recap, misting all other sheets, which I create seperately.

Than I have my sheets and the third entrie is a ssheet listing errors occured during the process.

 

So I am not sure if your suggestion does the trick. But it is a great starting point.


nielsgerrits
VIP
Forum|alt.badge.img+54
  • Best Answer
  • May 17, 2023
lgrie wrote:

Thanks for your suggestion, Niels.

What I did not mention is that I am using a FeatureWriter with three different entries:

My first desired sheet is a recap, misting all other sheets, which I create seperately.

Than I have my sheets and the third entrie is a ssheet listing errors occured during the process.

 

So I am not sure if your suggestion does the trick. But it is a great starting point.

I think it does, sample workspace attached.


lgrie
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • May 17, 2023
nielsgerrits wrote:

I think it does, sample workspace attached.

This worked for me quite well! Bedankt !


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings