I have a workspace the writes to an excel file based off an excel template. The template has all of the rows set to filtered. How can I get the final output to include the filtered rows so I don't have to apply the filter every time I open the generated workbook?
Question
How can I get FME to write an excel file with the column filter applied?
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.
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.
+12- Contributor
Hi,
Until unless you maintain
1. column as user attribute
2. row with xlsx_row_id
3. Sheet name as Feature Type Name
4. Writer mode as Update Cell Contents
it wont be any problem in writing in excel even if filter is applied
+59- Safer
Unfortunately, I don't think that what you want to do is possible right now. Can you contact the support team with your request (http://safe.com/support)? Give them the reference PR#54202 which I think is an existing enhancement request for the same functionality. They will be able to tell you if it is the same issue, and if there is a workaround.