Question

Select first sheet in an Excel File

franco69
Rank
Badge +6

Hi Guys,

for sure someone has aked this before but i didnt find an article.....it is a very simple question

i have to handle with a lot of excel sheets 

i have to select always the first sheet in any excel file.....but sometimes they have different names

so how can i select the first one....

 

Greetz and Cheers

Franco

6 replies

danilo_fme
Rank
Userlevel 4
Badge +30

Hi @franco69​ 

 

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

 

XLS_1 

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

 

 

Thanks in Advance,

Danilo

franco69
Rank
Badge +6

Hi @franco69​ 

 

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

 

XLS_1 

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

 

danilo_fme
Rank
Userlevel 4
Badge +30

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:

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

 

Thanks in Advance,

Danilo

M
Badge +2

@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)

 

franco69
Rank
Badge +6

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......)excelsheet1excelsheet02from every excel file (attachement)

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

 

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

logfile_skippingThx for help

Greetz

Franco

 

 

M
Badge +2

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......)excelsheet1excelsheet02from every excel file (attachement)

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

 

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

logfile_skippingThx 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)

Reply


Community Stats

28,670
Posts
109,369
Replies
36,531
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.