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
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
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.