Solved

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

Forum|Forum|1 year ago
February 12, 2024
1 reply
246 views

+18

vxn43
Supporter

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

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.

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.