[jira] [Reopened] (TIKA-2734) Tika addes extra characters at the end of text in extracting from excel file

["feng ye (JIRA)" <ji...@apache.org>]

     [ 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)