Saving style of the header of StyleFrame object to excel

Question

The header's style is not saved to the xls file when I use sf.to excel() to save a StyleFrame object. The header of an Xls file always displays in Arial 12, which seems to be a default. My sf.columns[0] immediately before invoking sf.to excel(). The font I want is in container.style.font (Calibri), however the header in the xls file is in Arial 12. XLS data rows, however, are acceptable because they reflect the style I maintained on SF's data rows.

Is it possible to modify the style of the header when using sf.to excel()?

Answer 1

The correct way to style the headers is to use the apply_headers_style method:

from StyleFrame import StyleFrame, Styler

sf = StyleFrame({'a': [1, 2], 'b': [3, 4]})
sf.apply_headers_style(Styler(font='Calibri'))
sf.to_excel().save()

This will style all the headers. A workaround if you want to style only the first column's header:

from StyleFrame import StyleFrame

sf = StyleFrame({'a': [1, 2], 'b': [3, 4]})
sf.columns[0].style.font = 'Calibri'
sf._has_custom_headers_style = True
sf.to_excel().save()