EXCEL READER USING FLOW VARIABLE

[Nanda_Rukmana]

Hello,

I want to try use flow variable for excel reader. The Goal is I use file with the last modified without change the location manually so I try to use flow variable.

I got trouble on excel reader when I had use flow variable it show notice on the bottom //The “XLS LOCATION” parameter is controlled by a variable.

Then, when I click OK appear notice like this

fyi, I am new using KNIME.

hope anyone to solve my problem, tq.

[armingrudd]

Hi @Nanda_Rukmana,

Are you reading a CSV file with the Excel Reader (XLS) node?

If the file is CSV then use the File Reader node instead.

[ipazin]

Hi there @Nanda_Rukmana,

Welcome to KNIME Community Forum!

and if you don’t use flow variable you can successfully read your data into KNIME?

I have tried to get error message you did but keep failing. This node should by default select first sheet with data if not specified differently.

Br,
Ivan

[Nanda_Rukmana]

Dear Mr. Arming,

thank you it’s work.

regards,
Nanda