Excel Headers and Footers are Ignored

[Former user]

Original issue 387 created by mrh... on 2014-01-29T11:51:51.000Z:

It appears that Headers and Footers in XLSX files are not extracted. These items exist in the sheet+xml files ad look like the following example

<headerFooter>
<oddHeader>&C&"-,Bold Italic"&12DIRECTION DES FINANCES - BUREAUX RÉGIONAUX &14FONCTIONS RÉMANENTES - APRÈS LA MISE EN OEUVRE DES COMPTES CRÉDITEURS CONSOLIDÉS EN DATE D'OCTOBRE 2013</oddHeader>
<oddFooter>&CPage &P</oddFooter>
</headerFooter>

Is this an oversight or done on purpose?

[Former user]

Comment 1. originally posted by @ysavourel on 2014-01-29T17:30:33.000Z:

[Former user]

Comment 2. originally posted by @ysavourel on 2014-04-08T00:08:51.000Z:

Probably oversight. Can you attach a sample?

[Former user]

Comment 3. originally posted by @ysavourel on 2015-03-04T06:33:50.000Z:

Whoah, this markup is ~funky~:

<oddHeader>
&L&"Calibri,Regular"&K000000Header left&C&"Calibri,Regular"&K000000Header center &P&R&"Calibri,Regular"&K000000Header right
</oddHeader>

<oddHeader> and <evenHeader> correspond to headers and footers for odd and even page numbered pages, respectively. An explanation of the strange markup used in these sections is here:

https://msdn.microsoft.com/en-us/library/documentformat.openxml.spreadsheet.evenheader%28v=office.14%29.aspx

[Former user]

Comment 4. originally posted by @ysavourel on 2015-03-04T06:34:26.000Z:

Attached sample file

[Former user]

Comment 5. originally posted by @ysavourel on 2015-03-18T18:42:51.000Z:

[Jim Hargrave (OLD)]

confirmed fixed