title: Read embedded pdf file in excel using Java
body: <p>I am new to Java programming. My current project requires me to read embedded(ole) files in an excel sheet and get text contents in them. Examples for reading embedded word file worked fine, however I am unable to find help reading an embedded pdf file. Tried few things by looking at similar examples.... which didn't work out. </p>
  
  <p><a href="http://poi.apache.org/spreadsheet/quick-guide.html#Embedded" rel="nofollow">http://poi.apache.org/spreadsheet/quick-guide.html#Embedded</a></p>
  
  <p>I have code below, probably with help I can get in right direction. I have used Apache POI to read embedded files in excel and pdfbox to parse pdf data.</p>
  
  <pre><code>public class ReadExcel1 {
  
  public static void main(String[] args) {
  
      try {
  
          FileInputStream file = new FileInputStream(new File("C:\\test.xls"));
  
          POIFSFileSystem fs = new POIFSFileSystem(file);
          HSSFWorkbook workbook = new HSSFWorkbook(fs);
  
          for (HSSFObjectData obj : workbook.getAllEmbeddedObjects()) {
  
              String oleName = obj.getOLE2ClassName();
  
             if(oleName.equals("Acrobat Document")){
                  System.out.println("Acrobat reader document");
  
                  try{
                      DirectoryNode dn = (DirectoryNode) obj.getDirectory();
                      for (Iterator&lt;Entry&gt; entries = dn.getEntries(); entries.hasNext();) {
  
                          DocumentEntry nativeEntry = (DocumentEntry) dn.getEntry("CONTENTS");
                          byte[] data = new byte[nativeEntry.getSize()];
  
                          ByteArrayInputStream bao= new ByteArrayInputStream(data);
                          PDFParser pdfparser = new PDFParser(bao);
  
                          pdfparser.parse();
                          COSDocument cosDoc = pdfparser.getDocument();
                          PDFTextStripper pdfStripper = new PDFTextStripper();
                          PDDocument pdDoc = new PDDocument(cosDoc);
                          pdfStripper.setStartPage(1);
                          pdfStripper.setEndPage(2);
                          System.out.println("Text from the pdf "+pdfStripper.getText(pdDoc));
                      }
                  }catch(Exception e){
                      System.out.println("Error reading "+ e.getMessage());
                  }finally{
                      System.out.println("Finally ");
                  }
              }else{
                  System.out.println("nothing ");
              }
          }
  
          file.close();
      } catch (FileNotFoundException e) {
          e.printStackTrace();
      } catch (IOException e) {
          e.printStackTrace();
      }
  }
  </code></pre>
  
  <p>}</p>
  
  <p>Below is the output in eclipse</p>
  
  <pre><code>Acrobat reader document
  </code></pre>
  
  <p>Error reading Error: End-of-File, expected line
  Finally 
  nothing </p>