XLS Reader & Cell Format

KNIME Analytics Platform
1

I have formatted in excel for every cell to be "Text". The XLS reader is still reader some columns as an "integer". How can I force the xls reader to treat everything as a string?

Thanks

Ste

2

Hello,

When I have the same problem, I work around it using the Number to String node after the XLS reader node.

Hope this helps.