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?
Page 1 / 1
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
Excel Reader - You can enable Apply Filter(s) under Advanced section, to read the filtered records.
Thanks,
I missed that option. It works.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.