Hi,
I create a filter in an Excel worksheet and then I want to read the filtered result with FME. Is that possible? Or do I have to copy the filter result to a second worksheet?
Question
How to read filtered content from Excel worksheet
+31- Influencer
If you are referring to specific cells being filtered, you can filter the cell range in the Sheets to Read section of the reader parameters.
https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_reader.htm
+9- Contributor
Excel Reader - You can enable Apply Filter(s) under Advanced section, to read the filtered records.
