As I will use knime to generate report everyday, i found that everytime i have assigned the color for each sheet, knime will return it to default next time.
How can I set this in knime to prevent it change everyday?
As I will use knime to generate report everyday, i found that everytime i have assigned the color for each sheet, knime will return it to default next time.
How can I set this in knime to prevent it change everyday?
Hi @HKuser,
Coloring and cell & text formating of Excel files can be automated using Continental nodes:
Continental nodes come along with a very nice set of workflow examples detailing how to do the job:
There are some limitations on what can be done with this nodes but it covers a wide range of possibilities to customize Excel files.
Hope this is of help.
Best regards,
Ael
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.