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

aatishia

aatish-ia

Posted on November 8, 2019

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

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…

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)

💖 💪 🙅 🚩
aatishia
aatish-ia

Posted on November 8, 2019

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related