[Solved] Read Excel Text Header Using Python

by


The comments actually helped me get the answer by pointing me to openpyxl. I’m posting it here if anyone else had it.

import openpyxl
wb = openpyxl.load_workbook('Roster Report.xlsx')
header_text = str(wb.active.HeaderFooter)
wb.close()

I didn’t see a way in xlrd to read the header, only to write it.

2

solved Read Excel Text Header Using Python