When you say "content can not be parsed", do you mean you're getting an error, an exception, no text, incorrect text, something else?

Which headers/footers are you expecting to see? Print ones? On screen ones? Something else?

Do you have a very small sample file with headers in that can be used to show the problem?

No errer occured. The txt file was produced.
I attached a xls file.
The file's headers has three cakes words and the footers has one cakes word.
But the produced txt file has no cakes word.

Ah, I see, it's the print headers/footers you're expecting that are missing

This will need additional code in both the XLS and XSLX parsers, to find the print headers and footers, then extract them

Could you provide me the patch for the extraction.
Thank you!

I've attached a patch which includes the fix, a unit test to verify the fix for XLS files and another unit test to verify that header and footer extraction from XLSX files already works OK.
The test data files are attached separately in case they can't be extracted out of the patch file.

r1688834.. Thank you Aeham Abushwashi!

SUCCESS: Integrated in tika-trunk-jdk1.7 #779 (See https://builds.apache.org/job/tika-trunk-jdk1.7/779/)
TIKA-1400 (tallison: http://svn.apache.org/viewvc/tika/trunk/?view=rev&rev=1688834)

• /tika/trunk/CHANGES.txt
• /tika/trunk/tika-parsers/src/main/java/org/apache/tika/parser/microsoft/ExcelExtractor.java
• /tika/trunk/tika-parsers/src/test/java/org/apache/tika/parser/microsoft/ExcelParserTest.java
• /tika/trunk/tika-parsers/src/test/java/org/apache/tika/parser/microsoft/ooxml/OOXMLParserTest.java
• /tika/trunk/tika-parsers/src/test/resources/test-documents/testEXCEL_headers_footers.xls
• /tika/trunk/tika-parsers/src/test/resources/test-documents/testEXCEL_headers_footers.xlsx