[ 
https://issues.apache.org/jira/browse/TIKA-2734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

feng ye reopened TIKA-2734:
---------------------------

Hi Tim,

applied the config setting you suggested but the results still contain the 
footer contents somehow. Would you take a look? My code is copied below. 

 _if (tika.detect(bytes).contains("ms-excel")) {_
 _System.out.println("turning off footers...");_
 _ParseContext parseContext = new ParseContext();_
 _OfficeParserConfig config = new OfficeParserConfig();_
 _config.setIncludeHeadersAndFooters(false);_
 _parseContext.set(OfficeParserConfig.class, config);_
 _parseContext.set(Parser.class, tika.getParser());_
 _}_
 _String result = tika.parseToString(new ByteArrayInputStream(bytes));_

> Tika addes extra characters at the end of text in extracting from excel file
> ----------------------------------------------------------------------------
>
>                 Key: TIKA-2734
>                 URL: https://issues.apache.org/jira/browse/TIKA-2734
>             Project: Tika
>          Issue Type: Bug
>          Components: handler
>    Affects Versions: 1.18
>            Reporter: feng ye
>            Priority: Major
>         Attachments: AIRPORTSOK.xls, extra_A_Page_P.png
>
>
> when extracting text from some relatively large excel files (9000 rows or 
> so), I found an extra string of "&A PAGE &P" is added to the end of the 
> resulting text, when Tika.parseToString is called. Is it a known issue? Is 
> there any configuration that I can do that will opt out from outputting these 
> extra characters?
> did not find a good answer over google. 
> the input excel spreadsheet is attached. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to