Accounting Format - Excel Writer


I’m wondering if anyone has any ideas / experience with needing to write accounting format cells to Excel?

Principally, I need to be able to write the following accounting formats:

3 letter currency code and value (examples: USD 100.00 / GBP 100.00 / AUD 100.00, and so on)
Currency symbol and value (examples. $ 100.00 / £ 100.00, and so on)

I can create the format, but I need the values written in the accounting format for the end consumers of the Excel file.

My challenge is two fold:

(1) Having looked through the Continental formatting nodes and the forum, I can’t see how to write these formats
(2) The currencies will change - cell A1 maybe USD 100.00, cell A2 maybe GBP 100.00, and so on.

A snippet of what I have today:

An example of the output I’m trying to create is here (please note, the currencies change):

Does anyone have any ideas?

Thanks for any help and all the best - JD.

1 Like

See if this covers your display formats.

Thanks for the response - I’ll have a look around.

Hi @Unlockedata,

Could you please copy & paste here in text format your first data snapshot (using the formatted text option </>) ? It will help us to provide you with a solution from there. Thanks in advance.



Hi, and thank you for taking a look.

I’ve uploaded a file that I hope sets the scene and answers the question.

The consumers of the data use Excel and want the columns to be in the Accounting Number Format.

Knime Forum Example.xlsx (10.5 KB)

Thanks for any help - I’m struggling on this one.

All the best - John.

1 Like

Hi @Unlockedata

I had a look at your data to realize that the format you need is a special “accounting” format in Excel which provides this kind of formatting (Format Numbers as Currency) :

I had a look at the Continental plugin and it seems that this “accounting” format is not among those configurable by its nodes.

I believe the best people to ask are the Continental plugin developers (@Continental_KNIME_Extension_Developer) who implemented this plugin to check whether there is a possible solution to your problem.



Thank you for taking the time to look. Much appreciated.

All the best.

1 Like

Dear Ael,

Thanks for bringing this up.
Our node (XLS Cell Formatter) is not limited to the preset, but accepts arbitrary cell formats.
You could try the following format:

-[$$-en-US]* #.##0,00 ;-[$$-en-US]* -#.##0,00 ;-[$$-en-US]* “-”??_ ;-@

Best regards



I missed that this was for Excel. A much easier solution is to format the columns in excel after a write and use this node. It is pretty much my go to for Excel now since it is such a time saver Vs separate commands for every little adjustment. I tend to put a lot of work into clean presentations.


Dear @arbe

Thanks for reaching out and for your prompt reply. I’m impressed by the solution. I hope it solves @Unlockedata needs or at least gives a first option to proceed further. I believe that the problem is not just the “accounting” format but also the fact that every cell might have a different currency which complicates things. Having said this, a more elaborated solution might eventually come from the formatting you suggest. @Unlockedata, what do you think ?

Thanks too to Continental for your great Excel plugin and for making it available to the KNIME community.

Have a great day ahead !

Best regards



I get an error trying to drag and drop the node…

Me being a berk?

@aworker and @arbe - thank you. I will take a look and let you know how I get on.

Much appreciated, and all the best.

1 Like


Is NodePit setup as an Available Software Site in your Preferences? If not there are instructions below. Just make sure that the update site matches your KNIME version #. You can also install directly via downloading the ZIP file, but it will not remain linked for version updates.

Usually, you start the installation process with two information available, the update site (e.g. and the product name (e.g. NodePit for KNIME). Both information is listed on each and every node and product page on NodePit.

After starting KNIME, go to File → Preferences → Install/Update → Available Software Sites, click on Add… and paste the update site. Make sure the update site matches your current KNIME version.

1 Like

Hi @Unlockedata,

should also be availible if you go through install extensions - community - AF Utilitys :slight_smile:
If there are any issue - will try to support :slight_smile:

But strange that the drag&drop does not work - will check myself later

Hi @iCFO,
I understand the argument and I think your proposed solution works fine for static tables. I haven’t used it yet, since the industrial use cases I know often include dynamic table layouts (different number of plants, colored groups of rows, etc.). This is the strength of XLS Formatting nodes.
Also in regards to the topic of this forum topic where dynamically the formatting needs to change the currency based on data content – possible with the XLS Cell Formatter, but not with a static Excel template, as far as I know.


That may be true for a basic excel user, the limitations are very much on the other side for power users. Don’t get me wrong here… I love your nodes and use them for basic formatting in some situations. However, the template approach unlocks infinite possibilities for me.

Basic formatting: I conditionally format base global templates to be self adapting complex formatting presentations. (I reference to a separate sheet with additional conditional control settings populated by KNIME to get added flexibility) I can also conditionally hide / shoe columns and rows. This way Excel just self adapts to any changes with a few simple control / override settings.

The more important strengths: I do not issue static excel reports or user tools. Reports are meant to prompt decisions or perform some action for the users. With the template approach you can keep complex interactivity controls, visualizations, macro action controls. It opens up a lot of easily portable dashboard capabilities for scenario tests so that the users can quickly dial in decisions, or just a nice clean presentation and friendly controls that can be used to drive further automation.

1 Like

Either approach works. Preference really depends on your wheelhouse and presentation complexity. However, if you need “on the fly” conditional formatting that adapts to user interactions then template is the only current solution.

It is also not a one or the other choice thanks to the Excel Cell Updater. In some workflows I have left in place prior setups with your nodes to handle tables, then incorporated the write to template node in order to get conditional formatting in situations such as user interaction changing formula results.

1 Like

I don’t know if this is a me thing or not…I get this when following your instructions AFU.


I must be doing something wrong here…

After dragging and dropping I get the following:

I think get the following:


I tried the download URL with 4.7 too, but made no difference.

Sorry to be a nuisance - obviously, I’m missing something.

1 Like

Hi @Unlockedata

Please see this pinned topic: