when reading an excel sheet with the KNIME XLS Reader, it does not recognize blank lines. It just puts the words directly together which are seperated by blank lines in the original excel sheet.
Is there any solution for this problem?
Thanks in advance and best regards,
attached an example to illustrate where the problem lies:
In Excel cells one can have text that contains newlines characters (created with Alt-Enter) like in the example. Even if one save the file as a .csv file we could not find a way to read in these tables formatted correctly into KNIME.
Any suggestion is really appreciated.