I was trying to use openpyxl to read headers in some excel files I have. Despite seeing headers in Excel, the library does not return them. So I generated an example that also seems not to work. In the attached excel file, I inserted a left header. In the attached code I try to read it but always get the response "None"
from openpyxl import load_workbook wb = load_workbook("HeaderNotWorkingExample.xlsx") sheet wb.active assert sheet.header_footer.hasHeader()