Excel merge and center Unique values

[mlauber71]

@Ashwath5245 here is an example with merged headers. You could adapt that.

Positional file

@AlucardSTR It is possible to create complex Excel headers with the help of KNIME Continental nodes. You will have to familiarise yourself with the concept. See the links in the attached sample workflow. The workflow was initially created by @Kathrin. É possível criar cabeçalhos Excel complexos com a ajuda dos nós Continentais da KNIME. Terá de se familiarizar com o conceito. Ver as ligações no exemplo de fluxo de trabalho em anexo. O fluxo de trabalho foi inicialmente criado por @Kathrin. (…

Another option would be to use Openpyxl.

Extra simple workflow to color header row backgrounds in Excel file

@Nazaire I built a slightly different example of the use of OpenPyxl with some configuration. It would determine the number of columns and then set a pre-defined style, auto-size the columns and freeze the top row. [image] The same principles could be applied to other formats. So if you like coding you could do it with OpenPyxl [image] kn_example_python_excel_format_header.knwf (130.1 KB)