Instead of using column alphabets while formatting, can I use column headers in xlsxwriter

Nov 8 '19 Comments: 1 Answers: 1

1

Can I use column header names instead of column alphabets for editing in pandas xlsxwriter?

This is for python 3.x using pandas and latest xlsx writer

worksheet.set_column('F:H', 30)

I want something like

worksheet.set_column('colname1:colname2', 30)

I don't want to use dictionary or assign column names to the default cell notation, it…

Open Full Question

Can I use column header names instead of column alphabets for editing in pandas xlsxwriter?

This is for python 3.x using pandas and latest xlsx writer

worksheet.set_column('F:H', 30)
I want something like

worksheet.set_column('colname1:colname2', 30)