Skip to main content
Question

How to read filtered content from Excel worksheet


fme_hans
Contributor
Forum|alt.badge.img+5

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?

3 replies

dustin
Influencer
Forum|alt.badge.img+31
  • Influencer
  • November 8, 2023

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


ranga_tolapi
Contributor
Forum|alt.badge.img+9
  • Contributor
  • November 9, 2023

Excel Reader - You can enable Apply Filter(s) under Advanced section, to read the filtered records.

 

Excel Reader - Apply Filter(s)


fme_hans
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • November 9, 2023

Thanks,

 

I missed that option. It works.

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings