Select first sheet in an Excel File

Hi @franco69​ 

There is a Attribute Format in Excel that you can enable = xlsx_row_id:

After you can use the tester for filter the position 1.

Thanks in Advance,

Danilo

Thx for that.......maybe i need that later.....

BUT in this case i need to chose the first SHEET in any excel file NOT the first row or column.

Thx

and GREETZ

Franco

Thanks for your answer.

I suggest you to use the transformer FeatureReader as configuration Output Ports = Single Output Ports:

When you execute this transformer, the first Sheet will be enable for you and use th transformer Counter.

Thanks in Advance,

Danilo

@franco69​ You can read the data twice. Add the Excel reader and set "Single Merged Feature Type" on the Add Reader dialog. Once you've added the reader in the Navigator set the Max Features to Read = 1. Pass this into the FeatureReader. Read the excel file and set Feature Types to Read: fme_feature_type and also set Output Ports: Single Output Port as @danilo_fme​ suggests. This should read only the first sheet.

Option 2: You can also use adjacent features in the AttributeCreator, but it's a little more convoluted.

I've attached an example workspace (FME 2022.1)

Something doesnt really working......maybe i have mentioned the wrong stuff

i took the first sheet fmwt. but always skipping...nothing reading

i read multiple files with one folder

but i need only first sheet (in this case e.g. KREUZUNGSNAME and in the other Probenliste......)from every excel file (attachement)

when this is what you meant....i do something wrong

because FME reads nothing ...only skipping (attachement logfile)

Thx for help

Greetz

Franco

@franco69​ On the surface that looks correct, but I can't tell what parameters you set. If you want to send me your Excel files I can take a look (mark at safe.com)