Invalid Block Type

[PedroGalindo]

For some reason, KNIME doesn’t manage to read an Excel file.

I searched for a solution, but couldn’t find any.

Could you help me?

Thanks in Advance
Pedro Galindo

[ArjenEX]

Would you happen to able to upload an (anonymized) version of that Excel sheet?

It indeed seems like a rare issue based on the number of forum search results so troubleshooting that only based a screenshot is extemely difficult.

[PedroGalindo]

Share.knwf (6.8 KB)

Hi @ArjenEX,

I can’t share the Excel file because it’s too big.

[mlauber71]

@PedroGalindo it is very difficult to tell what might go wrong without the sample file.

You could provide us with a Logfile in DEBUG mode in order to get an idea what is happening:

Files Corrupted During File Transfer

@djarrett I could not initially find any problems. You could get rid of the vernalis error messages by installing RDKit. Could you create a LOG in DEBUG mode? Open the existing log and delete the content: [image] or delete the file from the workspace directory {workspace_directory}/.metadata/knime/knime.log activate the DEBUG level. Make sure that it would not contain any sensitive informations and remember to set it back to WARN after you are finished: [image] You might want to include f…

edit: your Excel path contains a myriad of spacial characters. One thing you could do is to try and read the file from a relative path near your workflow.

If this does not help you could explore more methods to import your Excel file with R and Python and see if that could help:

Import EXCEL - a meta workflow trying to answer questions about importing...

[PedroGalindo]

@mlauber71,

This is the log generated in DEBUG Mode:

KNIME Log - Excel Reader Error.txt (15.3 KB)