Copy out code from the site and fix

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1745348 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 129 insertions, 0 deletions

diff --git a/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java b/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java
new file mode 100644
index 0000000000..66ca8ba7b2
--- /dev/null
+++ b/src/examples/src/org/apache/poi/ss/examples/LoadEmbedded.java
@@ -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();
+           }
+       }
+   }
+}