Hello,
i used the XLS-Formatter.
In my exported Excel-File i got two diffrent currency-formats: One column “Provisons-Basis €” is correct, the second column “Provision €” is wrong. Wrong because the €-Symbol is missing.
Both Columns are formatted as Double:
Einstellung für Column “Provision €”
Exported excel file
I can´t find the mistake in my configurations of the nodes.
Thx in advance
I have been leaning harder on this node, which dramatically simplifies Excel formatting and formula structure.
I’ve never used these nodes before, but looking at your images the decimal and thousands separators in your excel workbook and the text formatting string are different (the formatting string uses thousand separators with comma, decimal with period; whereas, your worksheets are period for thousands separator and then comma for decimal).
The first column you have a period in the numbers, which Excel will pick up as currency format, whereas the second column does not, so picks up as a general number.
Don’t know if that is your problem, but it is what I see.
DiaAzul
I think you would have to upload some sample data in an exported workflow. When I encounter things like this kind of thing, it usually requires some troubleshooting.
@iCFO ,
Your suggestion will help. But you will also need to change the locale settings for your computer to match the environment of the OP. I’m not sure to what extent KNIME nodes are locale aware and in sync with the host operating system. We’ve always standardised on commas for thousand separators and periods for decimals to avoid problems, but that doesn’t apply to everyone.
True, but it could be something more easily found on the KNIME side like character encoding for commas or hidden characters.
Hi @DiaAzul,
I think I used the same formatting
#,##0.00 €;[Black]#,##0.00 €
on both XLS Formatter nodes. But in the exported Excel table after the nodes the formatting is different.
I hope I haven’t overlooked anything
Thx in advance
Hi @iCFO ,
thank you for this cool Node.
But the result is the same 
The template file has the correct formatting.
_AB021_ABSCHLUSS-Angepasst_als_KNIME-Template.xlsx (26.0 KB)
Are there any “missing values” in that column? Try replacing missing values with zero (using the missing values node) for the column that is not formatting as currency.
Hi @iCFO ,
no missing values.
I got this error:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>error063320_01.xml
The column in question is set to string instead of double. If you can’t convert it to double, then try to remove the commas first with Regex replace. If there are problems converting to double after that, then this could be a character encoding issue.
Result
Result II - Column “Provisions-Basis €” without “€-Symbol”
Changed the format in the template too “Währung” 
But got still this error-message:
Looks like the output is working now. I am sadly limited to the English language, so I can’t read the error message in the image.
@iCFO
Yes it works 
Thank you for your help and the tip too this nice node.
Error-Message:
The file could not be opened by Excel readable content has been repaired or removed.
Repaired records: table from /xl/tables/table1.xml part (table)
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>error172360_01.xml
I found and solved the problem.
I put another String-to-Number node in front of the Excel writer node and converted the Commission € column to double format. After that, the XLS formatter nodes output everything correctly.
Thank you for your help!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
