Skip to main content
  • EN

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: 

 

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.

 

Reply


Community Stats

30,357
Posts
115,371
Replies
38,093
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.