Does the Excel Cell Updater also "write formats?"
HI dear KNIMErs,
I have been dealing a lot with Exce Cell Updater recently.
I always had the impression that this writes the pure values but recently I found out it also “overwrites” formats which I find quite unusual and unexpected. Because the overall USP of this specific node is
“prepare and bring your own Excel file, let KNIME do the data transformation and write only values”
The example I had had a pre-formatted cell (background color, border, date format) and when writing from the Excel Cell Updater all of that disappeared and it wrote the date in the standard KNIME ISO date format into it.
Is that how it’s supposed to be?
Before
After