search

computerline1z / okapi

Automatically exported from code.google.com/p/okapi
0 stars 0 forks source link

Excel Headers and Footers are Ignored #387

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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?

Original issue reported on code.google.com by mrh...@gmail.com on 29 Jan 2014 at 11:51

GoogleCodeExporter commented 9 years ago

Original comment by tingley on 29 Jan 2014 at 5:30

GoogleCodeExporter commented 9 years ago 
Probably oversight.  Can you attach a sample?

Original comment by tingley on 8 Apr 2014 at 12:08

GoogleCodeExporter commented 9 years ago 
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.even
header%28v=office.14%29.aspx

Original comment by tingley on 4 Mar 2015 at 6:33

GoogleCodeExporter commented 9 years ago 
Attached sample file

Original comment by tingley on 4 Mar 2015 at 6:34

Attachments: