[Solved] Read Excel Text Header Using Python

by

[ad_1]

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

[ad_2]

solved Read Excel Text Header Using Python