Skip to main content
Solved

Excel writer : active tab selection

  • November 8, 2019
  • 1 reply
  • 36 views

p.jeremie
Contributor
Forum|alt.badge.img+6

Hello,

I wonder if it is possible to choose which tab will be the active one after the creation/update of a Excel workbook with the Excel Writer.

In my workspace I update a Excel workbook in which I have an 'history' tab. This one seems to be the last updated by FME because every time I run the workspace it is this tab that is active when I re-open the file in Excel.

What I want is to set active my first tab with the actual data in it so the final user won't need to change tab every time the file is updated by the workspace.

Hope the question is clear enough.

Best answer by p.jeremie

I answer to myself : I achieved to do what I want with changing the order of the writers in the navigator pane.

Note : I have two different writers for the same Excel output file, but I can't remember why I ended up with these two writers... I remember that with one I didn't achieve to get what I want.

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

1 reply

p.jeremie
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • Best Answer
  • November 8, 2019

I answer to myself : I achieved to do what I want with changing the order of the writers in the navigator pane.

Note : I have two different writers for the same Excel output file, but I can't remember why I ended up with these two writers... I remember that with one I didn't achieve to get what I want.


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