Skip to main content
  • EN

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?

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.

 

Excel Reader - Apply Filter(s)

Thanks,

 

I missed that option. It works.

 

 

Reply


Community Stats

30,162
Posts
114,480
Replies
37,808
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.