Hi @victor_palacios ! Thank you for the help! if it’s somewhere near 0, do I have to be using a rule engine to convert it to 0? Because in excel when we click on the rounded cell the original value displays in the formula bar, but KNIME wouldn’t be able to do that, right?
Thanks for the fast reply. I came across simple nodes such as String to Number, but when exported into Excel using Writer Node, the formatting simply goes off. This step right here only works in Knime and not when exported.
I also came across this post. This type of formatting is exactly what I need in my Excel exports (using Excel Writer Node).
If I understand correctly (I have 0 experience with Java) - the solution from @ipazin right here should solve the problem - meaning both fixing commas/dots and reformatting from String to number (double)?
@helpmeplease I think you can have the accounting format in knime only as string since knime will use its own internal storage of numbers. If you want to have this format in Excel. Maybe the way to go forward would be to just export the regular numbers and then change the format in Excel:
Another approach to this could be to use Python and Openpyxl like this - but maybe you start with the Continental nodes. I can see if I can come up with an example.
@Saishiyam thanks for the response! Would you be willing to share the workflow with me? XLS Cell formatter probably needs to be connected to other Continential Nodes in order to work properly? I can’t just convert Number to String, use this Node and export it via Writer.