Filters in Excel Sheet - how to create in FME Form?

  • 12 February 2024
  • 1 reply

Userlevel 1
Badge +14

I have a workspace that writes to a simple Excel sheet. The sheet has 3 columns: Report Name, Upload Date, and Upload Time.

In Excel you can set a Filter for each column allowing a user to filter the data in that column. 

In Excel, I added a Filter to each column, but when I write to the sheet in FME Form, the Filters disappear. Is there a way to “keep” or “add” a Filter to each column in the sheet by tweaking a Writer parameter or is there another Transformer I need to add before the Writer? The screen capture below shows what I would like the sheet to look like: 



Best answer by dustin 12 February 2024, 19:24

View original

1 reply

Userlevel 3
Badge +25

If you use the Template File parameter to point to the spreadsheet with the filters, it should retain the filters when it writes the data.