Question

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

  • 7 December 2015
  • 2 replies
  • 3 views

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

Badge +2

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

Userlevel 4
Badge +25

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.

Reply