poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From n...@apache.org
Subject svn commit: r1745348 - /poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java
Date Tue, 24 May 2016 12:16:13 GMT
Author: nick
Date: Tue May 24 12:16:13 2016
New Revision: 1745348

URL: http://svn.apache.org/viewvc?rev=1745348&view=rev
Log:
Copy out code from the site and fix

Added:
    poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java

Added: poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java?rev=1745348&view=auto
==============================================================================
--- poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java (added)
+++ poi/trunk/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java Tue May 24 12:16:13
2016
@@ -0,0 +1,129 @@
+/* ====================================================================
+   Licensed to the Apache Software Foundation (ASF) under one or more
+   contributor license agreements.  See the NOTICE file distributed with
+   this work for additional information regarding copyright ownership.
+   The ASF licenses this file to You under the Apache License, Version 2.0
+   (the "License"); you may not use this file except in compliance with
+   the License.  You may obtain a copy of the License at
+
+       http://www.apache.org/licenses/LICENSE-2.0
+
+   Unless required by applicable law or agreed to in writing, software
+   distributed under the License is distributed on an "AS IS" BASIS,
+   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+   See the License for the specific language governing permissions and
+   limitations under the License.
+==================================================================== */
+
+package org.apache.poi.ss.examples;
+
+import java.io.File;
+import java.io.InputStream;
+
+import org.apache.poi.hslf.usermodel.HSLFSlideShow;
+import org.apache.poi.hssf.usermodel.HSSFObjectData;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
+import org.apache.poi.hwpf.HWPFDocument;
+import org.apache.poi.openxml4j.opc.OPCPackage;
+import org.apache.poi.openxml4j.opc.PackagePart;
+import org.apache.poi.poifs.filesystem.DirectoryNode;
+import org.apache.poi.poifs.filesystem.Entry;
+import org.apache.poi.sl.usermodel.SlideShow;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.ss.usermodel.WorkbookFactory;
+import org.apache.poi.xslf.usermodel.XSLFSlideShow;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
+import org.apache.poi.xwpf.usermodel.XWPFDocument;
+
+/**
+ * Loads embedded resources from Workbooks. Code taken from the website:
+ *  https://poi.apache.org/spreadsheet/quick-guide.html#Embedded
+ */
+public class LoadEmbedded {
+   public static void main(String[] args) throws Exception {
+       Workbook wb = WorkbookFactory.create(new File(args[0]));
+       loadEmbedded(wb);
+   }
+   
+   public static void loadEmbedded(Workbook wb) throws Exception {
+       if (wb instanceof HSSFWorkbook) {
+           loadEmbedded((HSSFWorkbook)wb);
+       }
+       else if (wb instanceof XSSFWorkbook) {
+           loadEmbedded((XSSFWorkbook)wb);
+       }
+       else {
+           throw new IllegalArgumentException(wb.getClass().getName());
+       }
+   }
+   
+   public static void loadEmbedded(HSSFWorkbook workbook) throws Exception {
+       for (HSSFObjectData obj : workbook.getAllEmbeddedObjects()) {
+           //the OLE2 Class Name of the object
+           String oleName = obj.getOLE2ClassName();
+           if (oleName.equals("Worksheet")) {
+               DirectoryNode dn = (DirectoryNode) obj.getDirectory();
+               HSSFWorkbook embeddedWorkbook = new HSSFWorkbook(dn, false);
+               //System.out.println(entry.getName() + ": " + embeddedWorkbook.getNumberOfSheets());
+           } else if (oleName.equals("Document")) {
+               DirectoryNode dn = (DirectoryNode) obj.getDirectory();
+               HWPFDocument embeddedWordDocument = new HWPFDocument(dn);
+               //System.out.println(entry.getName() + ": " + embeddedWordDocument.getRange().text());
+           }  else if (oleName.equals("Presentation")) {
+               DirectoryNode dn = (DirectoryNode) obj.getDirectory();
+               SlideShow<?,?> embeddedPowerPointDocument = new HSLFSlideShow(dn);
+               //System.out.println(entry.getName() + ": " + embeddedPowerPointDocument.getSlides().length);
+           } else {
+               if(obj.hasDirectoryEntry()){
+                   // The DirectoryEntry is a DocumentNode. Examine its entries to find out
what it is
+                   DirectoryNode dn = (DirectoryNode) obj.getDirectory();
+                   for (Entry entry : dn) {
+                       //System.out.println(oleName + "." + entry.getName());
+                   }
+               } else {
+                   // There is no DirectoryEntry
+                   // Recover the object's data from the HSSFObjectData instance.
+                   byte[] objectData = obj.getObjectData();
+               }
+           }
+       }
+   }
+   
+   public static void loadEmbedded(XSSFWorkbook workbook) throws Exception {
+       for (PackagePart pPart : workbook.getAllEmbedds()) {
+           String contentType = pPart.getContentType();
+           // Excel Workbook - either binary or OpenXML
+           if (contentType.equals("application/vnd.ms-excel")) {
+               HSSFWorkbook embeddedWorkbook = new HSSFWorkbook(pPart.getInputStream());
+           }
+           // Excel Workbook - OpenXML file format
+           else if (contentType.equals("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"))
{
+               OPCPackage docPackage = OPCPackage.open(pPart.getInputStream());
+               XSSFWorkbook embeddedWorkbook = new XSSFWorkbook(docPackage);
+           }
+           // Word Document - binary (OLE2CDF) file format
+           else if (contentType.equals("application/msword")) {
+               HWPFDocument document = new HWPFDocument(pPart.getInputStream());
+           }
+           // Word Document - OpenXML file format
+           else if (contentType.equals("application/vnd.openxmlformats-officedocument.wordprocessingml.document"))
{
+               OPCPackage docPackage = OPCPackage.open(pPart.getInputStream());
+               XWPFDocument document = new XWPFDocument(docPackage);
+           }
+           // PowerPoint Document - binary file format
+           else if (contentType.equals("application/vnd.ms-powerpoint")) {
+               HSLFSlideShow slideShow = new HSLFSlideShow(pPart.getInputStream());
+           }
+           // PowerPoint Document - OpenXML file format
+           else if (contentType.equals("application/vnd.openxmlformats-officedocument.presentationml.presentation"))
{
+               OPCPackage docPackage = OPCPackage.open(pPart.getInputStream());
+               XSLFSlideShow slideShow = new XSLFSlideShow(docPackage);
+           }
+           // Any other type of embedded object.
+           else {
+               System.out.println("Unknown Embedded Document: " + contentType);
+               InputStream inputStream = pPart.getInputStream();
+           }
+       }
+   }
+}



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message