[
https://issues.apache.org/jira/browse/TIKA-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ramchandran closed TIKA-2477.
-----------------------------
Resolution: Fixed
> Tika : Content of XLSX file extraction is not working after poi library
> upgrade
> --------------------------------------------------------------------------------
>
> Key: TIKA-2477
> URL: https://issues.apache.org/jira/browse/TIKA-2477
> Project: Tika
> Issue Type: Bug
> Components: core
> Reporter: Ramchandran
>
> Hi Team,
> I had written program to extract content of simple xlsx file. The program is
> working fine with poi-3.11 library but now I have upgraded my poi library to
> poi-3.16. Now the program is running but the output is not displayed.(Post
> upgrade only sheet name is displayed).
> Class File
> ===============
> package MSExcelParse;
> import java.io.File;
> import java.io.FileInputStream;
> import java.io.IOException;
> import org.apache.tika.exception.TikaException;
> import org.apache.tika.metadata.Metadata;
> import org.apache.tika.parser.AutoDetectParser;
> import org.apache.tika.parser.ParseContext;
> import org.apache.tika.parser.Parser;
> import org.apache.tika.sax.BodyContentHandler;
> import org.xml.sax.SAXException;
> public class MSExcelParser{
> public static void main(final String[] args) throws IOException,
> TikaException, SAXException {
>
> //detecting the file type
> BodyContentHandler handler = new BodyContentHandler();
> Metadata metadata = new Metadata();
> FileInputStream inputstream = new FileInputStream(new
> File("C:\\JavaTest\\Student.xlsx"));
> ParseContext pcontext = new ParseContext();
>
> Parser parser = new AutoDetectParser();
> parser.parse(inputstream, handler, metadata,pcontext);
>
> System.out.println("Contents of the document:" + handler.toString());
> }
> }
> .classpath file
> ============
> <?xml version="1.0" encoding="UTF-8"?>
> <classpath>
> <classpathentry kind="src" path="src"/>
> <classpathentry kind="con"
> path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.7"/>
> <classpathentry kind="lib"
> path="C:/JavaTest/commons-collections4-4.1.jar"/>
> <classpathentry kind="lib"
> path="C:/JavaTest/commons-compress-1.8.1.jar"/>
> <classpathentry kind="lib" path="C:/JavaTest/xmlbeans-2.6.0.jar"/>
> <classpathentry kind="lib" path="C:/JavaTest/poi-3.16.jar"/>
> <classpathentry kind="lib" path="C:/JavaTest/poi-ooxml-3.16.jar"/>
> <classpathentry kind="lib"
> path="C:/JavaTest/poi-ooxml-schemas-3.16.jar"/>
> <classpathentry kind="lib" path="C:/JavaTest/poi-scratchpad-3.16.jar"/>
> <classpathentry kind="lib" path="C:/JavaTest/tika-core-1.7.jar"/>
> <classpathentry kind="lib" path="C:/JavaTest/tika-parsers-1.7.jar"/>
> <classpathentry kind="output" path="bin"/>
> </classpath>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
