set header background color using code

[emkoos]

Hi. Is it possible to create styles for header using code when creating a file?

I found a solution using the event to set the AutoSizeColumns, but with the colors it doesn't work anymore, because the Save function overwrites them.

[mganss]

The invocation of the Saving event happens right before the workbook is written so I'm surprised the style gets overwritten:

ExcelMapper/ExcelMapper/ExcelMapper.cs

Lines 1012 to 1014 in efc3efd

	Saving?.Invoke(this, new SavingEventArgs(sheet));
	Workbook.Write(stream);

Have you already investigated where the overwriting occurs?