Java解析word2007和Excel2007

这周额外分配的任务是对office2007的文档进行解析，以前采用的是poi3.0版本，其只能对office2003版本的文档进行解析，还无法解析office2007.网上查了一下有人提供了最原始的解决方法，但是发现其实poi在3.5版本已经解决了这个问题。

下面是网上搜的一篇文章：

其实不需要完全匹配下面该文章提供的jar包，本人就是下载了poi-bin-3.6-20091214包，然后把poi-bin-3.6-20091214\poi-3.6和poi-bin-3.6-20091214\poi-3.6\ooxml-lib目录下的jar包导入到项目就ok了。

package com.test;   
  
/**  
 * 需要的jar包：  
 * poi-3.0.2-FINAL-20080204.jar  
 * poi-contrib-3.0.2-FINAL-20080204.jar  
 * poi-scratchpad-3.0.2-FINAL-20080204.jar  
 * poi-3.5-beta6-20090622.jar  
 * geronimo-stax-api_1.0_spec-1.0.jar  
 * ooxml-schemas-1.0.jar  
 * openxml4j-bin-beta.jar  
 * poi-ooxml-3.5-beta6-20090622.jar  
 * xmlbeans-2.3.0.jar  
 * dom4j-1.6.1.jar  
 */  
  
import java.io.FileInputStream;   
import java.io.IOException;   
import java.io.InputStream;   
  
import org.apache.poi.POIXMLDocument;   
import org.apache.poi.POIXMLTextExtractor;   
import org.apache.poi.hssf.usermodel.HSSFCell;   
import org.apache.poi.hssf.usermodel.HSSFRow;   
import org.apache.poi.hssf.usermodel.HSSFSheet;   
import org.apache.poi.hssf.usermodel.HSSFWorkbook;   
import org.apache.poi.hwpf.extractor.WordExtractor;   
import org.apache.poi.openxml4j.exceptions.OpenXML4JException;   
import org.apache.poi.openxml4j.opc.OPCPackage;   
import org.apache.poi.xssf.usermodel.XSSFCell;   
import org.apache.poi.xssf.usermodel.XSSFRow;   
import org.apache.poi.xssf.usermodel.XSSFSheet;   
import org.apache.poi.xssf.usermodel.XSSFWorkbook;   
import org.apache.poi.xwpf.extractor.XWPFWordExtractor;   
import org.apache.xmlbeans.XmlException;   
  
public class WordAndExcelExtractor {   
 public static void main(String[] args){   
  try{   
   String wordFile = "D:/松山血战.docx";   
   String wordText2007 = WordAndExcelExtractor.extractTextFromDOC2007(wordFile);   
   System.out.println("wordText2007======="+wordText2007);   
      
   InputStream is = new FileInputStream("D:/XXX研发中心技术岗位职位需求.xls");      
   String excelText = WordAndExcelExtractor.extractTextFromXLS(is);      
   System.out.println("text2003==========" + excelText);   
      
   String excelFile = "D:/Hello2007.xlsx";      
   String excelText2007 = WordAndExcelExtractor.extractTextFromXLS2007(excelFile);   
   System.out.println("excelText2007==========" + excelText2007);   
  
      
  }catch(Exception e ){   
   e.printStackTrace();   
  }   
 }   
    
 /**  
  * @Method: extractTextFromDOCX  
  * @Description: 从word 2003文档中提取纯文本  
  *  
  * @param   
  * @return String  
  * @throws  
  */  
    public static String extractTextFromDOC(InputStream is) throws IOException {   
        WordExtractor ex = new WordExtractor(is); //is是WORD文件的InputStream    
  
        return ex.getText();   
    }   
    
 /**  
  * @Method: extractTextFromDOCX  
  * @Description: 从word 2007文档中提取纯文本  
  *  
  * @param   
  * @return String  
  * @throws  
  */  
    public static String extractTextFromDOC2007(String fileName) throws IOException, OpenXML4JException, XmlException {   
     OPCPackage opcPackage = POIXMLDocument.openPackage(fileName);   
     POIXMLTextExtractor ex = new XWPFWordExtractor(opcPackage);      
  
        return ex.getText();   
    }   
    
 /**  
  * @Method: extractTextFromXLS  
  * @Description: 从excel 2003文档中提取纯文本  
  *  
  * @param   
  * @return String  
  * @throws  
  */  
    @SuppressWarnings("deprecation")   
 private static String extractTextFromXLS(InputStream is)   
        throws IOException {   
        StringBuffer content  = new StringBuffer();   
        HSSFWorkbook workbook = new HSSFWorkbook(is); //创建对Excel工作簿文件的引用    
  
        for (int numSheets = 0; numSheets < workbook.getNumberOfSheets(); numSheets++) {   
            if (null != workbook.getSheetAt(numSheets)) {   
                HSSFSheet aSheet = workbook.getSheetAt(numSheets); //获得一个sheet   
  
                for (int rowNumOfSheet = 0; rowNumOfSheet <= aSheet.getLastRowNum(); rowNumOfSheet++) {   
                    if (null != aSheet.getRow(rowNumOfSheet)) {   
                        HSSFRow aRow = aSheet.getRow(rowNumOfSheet); //获得一行   
  
                        for (short cellNumOfRow = 0; cellNumOfRow <= aRow.getLastCellNum(); cellNumOfRow++) {   
                            if (null != aRow.getCell(cellNumOfRow)) {   
                                HSSFCell aCell = aRow.getCell(cellNumOfRow); //获得列值   
                                                                   
                                if(aCell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC){   
                                 content.append(aCell.getNumericCellValue());   
                                }else if(aCell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN){   
                                 content.append(aCell.getBooleanCellValue());   
                                }else {   
                                 content.append(aCell.getStringCellValue());   
                                }   
                            }   
                        }   
                    }   
                }   
            }   
        }   
  
        return content.toString();   
    }   
       
    /**  
     * @Method: extractTextFromXLS2007  
     * @Description: 从excel 2007文档中提取纯文本  
     *  
     * @param   
     * @return String  
     * @throws  
     */  
    private static String extractTextFromXLS2007(String fileName) throws Exception{   
     StringBuffer content = new StringBuffer();   
        
     //构造 XSSFWorkbook 对象，strPath 传入文件路径       
  XSSFWorkbook xwb = new XSSFWorkbook(fileName);   
     
  //循环工作表Sheet   
  for(int numSheet = 0; numSheet < xwb.getNumberOfSheets(); numSheet++){   
   XSSFSheet xSheet = xwb.getSheetAt(numSheet);    
   if(xSheet == null){   
    continue;   
   }   
      
   //循环行Row   
   for(int rowNum = 0; rowNum <= xSheet.getLastRowNum(); rowNum++){   
    XSSFRow xRow = xSheet.getRow(rowNum);   
    if(xRow == null){   
     continue;   
    }   
       
    //循环列Cell   
    for(int cellNum = 0; cellNum <= xRow.getLastCellNum(); cellNum++){   
     XSSFCell xCell = xRow.getCell(cellNum);   
     if(xCell == null){   
      continue;   
     }   
        
     if(xCell.getCellType() == XSSFCell.CELL_TYPE_BOOLEAN){   
      content.append(xCell.getBooleanCellValue());   
     }else if(xCell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC){   
      content.append(xCell.getNumericCellValue());   
     }else{   
      content.append(xCell.getStringCellValue());   
     }   
    }   
   }   
  }   
     
  return content.toString();   
    }   
       
}