Hi,
i am using the Write-to-Excel-Template Node one times and after creating a Excel-File how i want, the node “crashed” .
I restart the workflow, disconnect the Node , delete it and put a “fresh” one into the workflow.
Sometimes it helped somtimes not. 
Data input
Setting Options Write-to-Excel-Template Node
Setting Advanced Options Write-to-Excel-Template Node
Column Filter Node
comparison with the Excel-Template-File
Error-Code:
*ERROR Write To Excel Template 4:1009 Execute failed: Reason: Error while writing This Style does *
*not belong to the supplied Workbook Styles Source. *
Are you trying to assign a style from one workbook to the cell of a different workbook?
I checked the cell formatting of the template so that it matches the data (see also the image of the Columnfilter node).
I am at a loss.
Thx in advance
1 Like
Hi,
I guess this is one for @AnotherFraudUser 
1 Like
Hi @USCHUKN1ME,
could you provide the Template Excel to me without data (just the formatting and maybe the cell headers if possible)
Will checkout the issue and try to fix it
From the error message it sounds like some issues with handling certain Excel formats - so hopefully not too much of an issue to fix
@Alice_Krebs thanks for tagging 
1 Like
Hi @USCHUKN1ME,
I think I found the issue
The node did not clean up some cell formats after processing a file.
So if the node was executed a second time it failed when processing affected cells (mostly date formats)
Which version of KNIME are you using?
I updated Version 4.5-4.7, which upfully should showup in a few hours
3 Likes
HI @AnotherFraudUser ,
thank you for your quick response!
I use KNIME Version 4.7.
Greetings
Hi @USCHUKN1ME ,
Great then the update should show up for you
If issues still appear feel free to tag me
3 Likes
Hi @AnotherFraudUser ,
thx !
Do I have to re-copy the node into my workflow or how do I get to the current node?
Greetings
Hi @USCHUKN1ME,
first you need to update the extension:
e.g. through:
or Install KNIME Extension and then the newest version of AF-Utilities
Afterwards it should work directly (but I guess to be sure replace the node with a new one)
1 Like
Hello @AnotherFraudUser,
i tried both,but i got this:
AF Uitity Nodes installed:
Should i wait a little longer?
Greetings
Hi @USCHUKN1ME,
it seems you already have the updated version
However you should not have to wait - i think this is an issue that the update does not apply correctly with your installation - does happen from time to time 
Could you please add the -clean option to your knime.ini (located in your installation folder)?
Sorry for the trouble - hope that fixes the issue
should the clean option not work - could you please confirm that the error message is the same?
I just tested it again with a fresh installation and the last issue seems to be fixed on my side
@AnotherFraudUser
Try it with my old KINME.ini
ERROR Write To Excel Template 3:1009 Execute failed: Reason: Error while writing This Style does not belong to the supplied Workbook Styles Source. Are you trying to assign a style from one workbook to the cell of a different workbook?
Is it possible to deinstall the AF Utility and after a restart install it again?
Hi @USCHUKN1ME,
my 4.7 .ini looks like this
-clean
-startup
plugins/org.eclipse.equinox.launcher_1.6.400.v20210924-0641.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_64_1.2.500.v20220509-0833
--launcher.defaultAction
openFile
-vm
plugins/org.knime.binary.jre.win32.x86_64_17.0.5.20221116/jre/bin/server/jvm.dll
-vmargs
-Djava.security.properties=plugins/org.knime.binary.jre.win32.x86_64_17.0.5.20221116/security.properties
-server
-Dsun.java2d.d3d=false
-Dosgi.classloader.lock=classname
-XX:+UnlockDiagnosticVMOptions
-Dsun.net.client.defaultReadTimeout=0
-XX:CompileCommand=exclude,javax/swing/text/GlyphView,getBreakSpot
-Dknime.xml.disable_external_entities=true
--add-opens=java.base/java.lang=ALL-UNNAMED
--add-opens=java.base/java.lang.invoke=ALL-UNNAMED
--add-opens=java.base/java.net=ALL-UNNAMED
--add-opens=java.base/java.nio=ALL-UNNAMED
--add-opens=java.base/java.nio.channels=ALL-UNNAMED
--add-opens=java.base/java.util=ALL-UNNAMED
--add-opens=java.base/sun.nio.ch=ALL-UNNAMED
--add-opens=java.base/sun.nio=ALL-UNNAMED
--add-opens=java.desktop/javax.swing.plaf.basic=ALL-UNNAMED
--add-opens=java.base/sun.net.www.protocol.http=ALL-UNNAMED
-Xmx8g
-Dorg.eclipse.swt.browser.IEVersion=11001
-Dsun.awt.noerasebackground=true
-Dequinox.statechange.timeout=30000
-Darrow.enable_unsafe_memory_access=true
-Darrow.memory.debug.allocator=false
-Darrow.enable_null_check_for_get=false
--add-opens=java.security.jgss/sun.security.jgss.krb5=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.jgss=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.jgss.spi=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.krb5.internal=ALL-UNNAMED
--add-exports=java.security.jgss/sun.security.krb5=ALL-UNNAMED
could you move the -clean to the top?
Still strange that you have a different order 
Maybe re-install could work as well
Install Extension - then press already installed:
Then de-install
1 Like
I build my KNIME.Ini like yours … cross my fingers that Knime start now…
1 Update
Knime started
1 Like
*just to be sure - in my .ini the memory usage of knime is higher then the default.
If you used it exactly the same and have less memory you should reduce the
-Xmx8g
to the default
-Xmx2g
*good sign that it at least starts
@AnotherFraudUser
the workflow now runs through, even if the nodes in front of it were reset several times!
You did it!
THANK YOU!
2 Likes
Great
Sorry that it was a bit complicated with the updates - really have to figure out why that sometimes happens
Then I wish you happy kniming and nice holidays 
2 Likes
