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.

The same principles could be applied to other formats. So if you like coding you could do it with OpenPyxl :slight_smile:

image

kn_example_python_excel_format_header.knwf (130.1 KB)

4 Likes