Hello everyone! I am new to Knime platform and seeking for your advise on how to implement this idea.
I already have an excel template file that needs to append each sheet then create a new file using the variable from flow variable. Using the excel writer node, I am able to append the said sheets.
However my issue is it overwrites the original template that I am currently using. What I am trying to accomplish is to create new file instead after it read and append the template.
You can absolutely read in an excel file, change the file name via a flow variable and write it back with newly appended sheets. Is this what you primarily want to do, or is this a workaround because you are losing your formatting?
The trick to keeping your formatting is that you never overwrite a sheet that contains a template or a working area. Keep the excel output from KNIME on separate support sheets and then reference them as ranges into your template / work area sheets on the excel side.
You can always read in your template sheets if you need that data, just don’t overwrite those sheets back from KNIME.