Skip to main content
Question

How can I get FME to write an excel file with the column filter applied?


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?

2 replies

pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • December 8, 2015

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


mark2atsafe
Safer
Forum|alt.badge.img+46
  • Safer
  • December 8, 2015

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.


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