如何使用java从Excel工作表中提取内容。（How to extract content from an excel sheet using java.）

问题描述 (Problem Description)

如何使用java从Excel工作表中提取内容。

解决方案 (Solution)

以下是使用java从Excel工作表中提取内容的程序。

import java.io.File;
import java.io.FileInputStream;
import org.apache.tika.metadata.Metadata;
import org.apache.tika.parser.ParseContext;
import org.apache.tika.parser.microsoft.ooxml.OOXMLParser;
import org.apache.tika.sax.BodyContentHandler;
public class ExtractContentFromExcel {
   public static void main(String args[]) throws Exception {
      //detecting the file type
      BodyContentHandler handler = new BodyContentHandler();
      Metadata metadata = new Metadata();
      FileInputStream inputstream = new FileInputStream(new File(
         "C:/tika/excelExample.xlsx"));
      ParseContext pcontext = new ParseContext();
      //OOXml parser
      OOXMLParser  msofficeparser = new OOXMLParser ();
      msofficeparser.parse(inputstream, handler, metadata,pcontext);
      System.out.println("Contents of the document:" + handler.toString());
      System.out.println("Metadata of the document:");
      String[] metadataNames = metadata.names();
      for(String name : metadataNames) {
         System.out.println(name + ": " + metadata.get(name));
      }
   }
}

输入 (Input)

输出 (Output)

Contents of the document:Sheet1 
   ID   NAME     BRANCH     PERCENTAGE       EMAIL 
   1     Ram       IT          85         ram123@gmail.com 
   2    Rahim      EEE         95         rahim123@gmail.com 
   3    Robert     ECE         90         robert123@gmail.com  
Metadata of the document: 
date: 2017-05-19T09:35:57Z 
extended-properties:AppVersion: 16.0300 
meta:creation-date: 2015-06-05T18:17:20Z 
extended-properties:Application: Microsoft Excel 
extended-properties:Company:  
Creation-Date: 2015-06-05T18:17:20Z 
dcterms:created: 2015-06-05T18:17:20Z 
Last-Modified: 2017-05-19T09:35:57Z 
dcterms:modified: 2017-05-19T09:35:57Z 
Last-Save-Date: 2017-05-19T09:35:57Z 
Application-Version: 16.0300 
protected: false 
meta:save-date: 2017-05-19T09:35:57Z 
Application-Name: Microsoft Excel 
modified: 2017-05-19T09:35:57Z 
publisher:  
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 
dc:publisher: