Excel reading challenge

@paulc1

You want to use fme to read the data that you select by excell-query in Excel ?

You don't need to do that, as you can execute the same query using fme.

Just use a tester to test the selection. Or even add the drop downs as choice parameter, to acquire the selection. (it is almost the same as what you do in Excell)

I'm sorry,not sure I follow...I didn't build the spreadsheet - the data is delivered as an Excel SS...I'm just trying to digest it.

Hi @paulc1 See https://knowledge.safe.com/articles/29689/getting-started-with-excel-2.html for a quick overview of reading Excel with FME. The Excel drop-downs must be queries of some sort. Read your entire Excel data and then query features (records) with a Tester to get a similar result. See https://knowledge.safe.com/articles/38693/the-flow-of-features-in-fme-translations.html for an introduction to the Tester.

Thanks Dan. Normally, I have little problem with reading Excel workbooks. I think what's complicating things is multiple sheets.

Cheers

Paul

Is the data in the spreadsheet itself? Without pushing any button? Or is the data collected when the button is pushed? Because if that is the case, you need to reproduce the mechanism behind the button to collect the data in FME.

If the data is in one of the sheets, you can easily select the sheet when reading the excel file.