Read list of xls file

KNIME Analytics Platform
#1

Hi,

I just try to read (*.xlsx) from a list of file the sheet "details" (in each file the same name)

List file -> Table row to variable loop start -> xls reader = doesent work........

List file -> Table row to variable loop start -> read xls sheet name = doesent work......

Any suggestion ?

;-) Mitch

 

 

#2

Hi Mitch, 

I can give it a try if you upload a couple of dummy files. 

Regards,

Aaron

 

#3

Great Aaron,

I'll send you 3 fles with ~25 lines....

Objectif is, at the end, to obtain 1 file with all data from sheet "details"

Cheers

#4

Hi Mitch, 

It sounds like you were on the right track, and your example works fine using th efirst approach that you describe for me.  I wonder if you are using an older version of KNIME or if something else is going on?  See attached.

Cheers,

Aaron

Edit: Adding attachemnt. 

 

#5

Hi Aaron,

I'm running 2.9.4 Version

....I don't see your attachment....

Cheers

#6

Sorry, file is attached. I believe the workflow will run with only minor complaints in KNIME 2.9.

#7

Thank's Aaron,

finally....it's work

Cheers, Mitch