Headers lost

Issue #382 duplicate
Sebastian Kobylarz created an issue

Headers are lost on a simple open and save of a excel file:

wb = openpyxl.load_workbook('test.xlsx')
wb.save('here.xlsx')

Comments (6)

  1. CharlieC

    Not sure what you mean about headers but we don't support much of the specification at the moment. Sample file please.

  2. Sebastian Kobylarz reporter

    Headers are the fields that will appear on the top part of a printed page. There is a left, center and right header as well as a left, center and right footer.

  3. CharlieC

    This is what we have at the moment:

        def parse_header_footer(self, element):
            oddHeader = element.find('{%s}oddHeader' % SHEET_MAIN_NS)
            if oddHeader is not None and oddHeader.text is not None:
                self.ws.header_footer.setHeader(oddHeader.text)
            oddFooter = element.find('{%s}oddFooter' % SHEET_MAIN_NS)
            if oddFooter is not None and oddFooter.text is not None:
                self.ws.header_footer.setFooter(oddFooter.text)
    

    PRs welcome.

  4. Log in to comment