How to wrap text in the header with excelwriter?

Question

I want to wrap the header text.

My code is as follows:

writer = pd.ExcelWriter(r'C:\data.xlsx', engine='xlsxwriter')
df.to_excel(writer, index = False, sheet_name='Sheet1')
workbook = writer.book
dformat = workbook.add_format({'text_wrap': True})
pd.io.formats.excel.header_style = None
worksheet = writer.sheets['Sheet1']
worksheet.set_row(0, None, dformat)
writer.save()

However, the first row, that is, the headers does not wrap.

How to solve it?

Furthermore, how to set a filter on a column, say, a filter of column value greater than 10?

Thank you.

Merelda · Accepted Answer · 2021-07-06 14:50:34Z

3

When use pandas to write the header, pandas applies their own styling.

If you want to apply your own styling to the header, you can write the data and header separately.

# Write data

writer = pd.ExcelWriter(r'C:\data.xlsx', engine='xlsxwriter')
df.to_excel(writer, index=False, sheet_name='Sheet1', header=False, startrow=1)

# Write header

for colx, value in enumerate(df.columns.values):
    writer.sheets['Sheet1'].write(0, colx, value)

# Style header

header_format = workbook.add_format({'bold': True, 'text_wrap': True, 'align': 'center'})
writer.sheets['Sheet1'].set_row(0, 30, formats['text_wrap'])

answered Jul 6, 2021 at 14:50

Merelda

1,3382 gold badges13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hendy Oct 14 at 22:37

Doesn't seem quite right. For one, I think you forgot to define formats or meant to use header_format in the call to set_row() at the end. Weirdly, the row height is applied when I try to do this, but not the wrapping.

Collectives™ on Stack Overflow

How to wrap text in the header with excelwriter?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related