Skip to main content
Question

How to read filtered content from Excel worksheet

  • November 8, 2023
  • 3 replies
  • 187 views
fme_hans
Contributor
Forum|alt.badge.img+6

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
  • dustinInfluencer
  • 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+11
  • ranga_tolapiContributor
  • 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+6
  • fme_hansContributor
  • Author
  • Contributor
  • November 9, 2023

Thanks,

 

I missed that option. It works.

 

 

Community Stats

32,751
Posts
124,208
Replies
41,263
Members
Terms & ConditionsAccessibility statement
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.