You could restore/set formats with the Continental nodes. I am not sure if you could extract your current style and then bring it back after you have exported (and overwritten) your current excel sheet (containing your styles and formats).
Yes, a little difficult. I know antoher application wtih which you can do it easily. But I don’t have it at work for the moment (i’ve asked for but it’s not free and companies are sometimes afraid to invest)
If your Excel file(s) have same/similar and stable structure you can utilize Continental nodes. Create one or more flows defining desired format and after you read data into KNIME and process it write it down with format you had. Should be feasible.
Still I agree that process other application uses is simpler. You mind sharing the application’s name?
It’s a French application called Amadea (editor : Isoft) but it’s not free as Knime
@mlauber71 I’ve tried the link with Python (solution I prefer to continental nodes and without simple solution) but I have errors. Would you have an example that works with every thing required (python code and library, excel fils input and output and knime project). I’d like to look.
Else, I will proceed by an export simple and formulas such as vlookup in Excel to present figures the way they were before.
I think the most practical approach would be to separate the data and the formatting in Excel. SO you could just export the data from KNIME into da ‘data sheet’ and the sheets in Excel stay the same. That obviously provides some challanges with consistency etc.
Unfortunately I do not have a full Python example for your case, and I am not entirely familiar with the Continental nodes. But you could check out my repository on the KNIME hub for example containing python and excel. They might give you and idea - but you would have to invest some additional work.