tika-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Allison (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TIKA-2734) Tika addes extra characters at the end of text in extracting from excel file
Date Thu, 04 Oct 2018 15:01:00 GMT

    [ https://issues.apache.org/jira/browse/TIKA-2734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16638345#comment-16638345
] 

Tim Allison commented on TIKA-2734:
-----------------------------------

Bwahahaha. :P  We added this a while ago.   I confirmed that this works for the attached file
to suppress extraction of headers/footers.

Programmatically:
{noformat}
        ParseContext parseContext = new ParseContext();
        OfficeParserConfig config = new OfficeParserConfig();
        config.setIncludeHeadersAndFooters(false);
        parseContext.set(OfficeParserConfig.class, config);
{noformat}

If you need to set this configuration via tika-config.xml, I can give an example or point
you to one.

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

Mime
View raw message