Hello
please advise how I could transmit data with Unit defined in excel to KNIME through Excel Reader Node.
Tks in advance
Hello @wooddenbowl,
don’t think you can do that. Best I can think of is to have format (currency in this case if not mistaken) defined in another column and that read into KNIME. Anyways you can’t do much with 42.0 EA in KNIME except to split it into 2 different columns…
Br,
Ivan
1 Like
Hi @ipazin,
If you won’t lose the information, bring as string, not a number and the excel need to have the same configuration (copy and past as a text, not personalized one.)
If you need to make some calc with it for the future, you can make as @wooddenbowl told you, split it to 2 columns and at the end, you can put it together with string manipulation node and save as string again.
BR,
Denis
@wooddenbowl you can use OpenPyxl with the bundled Python in KNIME to extract the format of the first line of data of an Excel sheet and store that for later use.
If you want to ‘preserve’ the formats you might have to also employ OpenPyxl and define a reference for your excel formats in Pandas and store the information as strings. The downside would be that you would have to define these settings before. But the above approach might help you with that.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.