POI处理Word、Excel、PowerPoint

第一：下载POI，在http://jakarta.apache.org/poi/中，下载poi-bin-3.5-beta4-20081128.zip，解压后把jar包引入项目工程。

第二：处理Word（Word.java）

import org.apache.poi.hwpf.extractor.WordExtractor;
import java.io.File;
import java.io.InputStream;
 
public class Word {
    public static void main(String[] args) throws Exception {
       System.out.println(getContent("c:\\11.doc"));
    }
 
    public static String getContent(String s) throws Exception {
       return getContent(new java.io.FileInputStream(s));
    }
 
    public static String getContent(File f) throws Exception {
       return getContent(new java.io.FileInputStream(f));
    }
 
    public static String getContent(InputStream is) throws Exception {
       String bodyText = null;
       WordExtractor ex = new WordExtractor(is);
       bodyText = ex.getText();
       return bodyText;
    }
}

 
 

第三：处理Excel(Excel.java)

import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import java.io.File;
import java.io.InputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
 
public class Excel {
    public static void main(String[] args) throws Exception {
       System.out.println(getContent("c:\\22.xls"));
    }
 
    public static String getContent(String s) throws Exception {
       return getContent(new java.io.FileInputStream(s));
    }
 
    public static String getContent(File f) throws Exception {
       return getContent(new java.io.FileInputStream(f));
    }
 
    public static String getContent(InputStream is) throws Exception {
       StringBuffer content = new StringBuffer();
       HSSFWorkbook workbook = new HSSFWorkbook(is);
       for (int numSheets = 0; numSheets < workbook.getNumberOfSheets(); numSheets++) {
           HSSFSheet aSheet = workbook.getSheetAt(numSheets);// 获得一个sheet
           content.append("\n");
           if (null == aSheet) {
              continue;
           }
           for (int rowNum = 0; rowNum <= aSheet.getLastRowNum(); rowNum++) {
              content.append("\n");
              HSSFRow aRow = aSheet.getRow(rowNum);
              if (null == aRow) {
                  continue;
              }
              for (short cellNum = 0; cellNum <= aRow.getLastCellNum(); cellNum++) {
 
                  HSSFCell aCell = aRow.getCell(cellNum);
                  if (null == aCell) {
                     continue;
                  }
                  if (aCell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
                     content.append(aCell.getRichStringCellValue()
                            .getString());
                  } else if (aCell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
                     boolean b = HSSFDateUtil.isCellDateFormatted(aCell);
                     if (b) {
                         Date date = aCell.getDateCellValue();
                         SimpleDateFormat df = new SimpleDateFormat(
                                "yyyy-MM-dd");
                         content.append(df.format(date));
                     }
                  }
              }
           }
       }
       return content.toString();
    }
}

第四：处理PowerPoint（PowerPoint.java）

import java.io.File;
import java.io.InputStream;
import org.apache.poi.hslf.HSLFSlideShow;
import org.apache.poi.hslf.model.TextRun;
import org.apache.poi.hslf.model.Slide;
import org.apache.poi.hslf.usermodel.SlideShow;
 
public class PowerPoint {
    public static void main(String[] args) throws Exception {
       System.out.println(getContent("c:\\33.ppt"));
    }
 
    public static String getContent(String s) throws Exception {
       return getContent(new java.io.FileInputStream(s));
    }
 
    public static String getContent(File f) throws Exception {
       return getContent(new java.io.FileInputStream(f));
    }
 
    public static String getContent(InputStream is) throws Exception {
       StringBuffer content = new StringBuffer("");
       SlideShow ss = new SlideShow(new HSLFSlideShow(is));
       Slide[] slides = ss.getSlides();
       for (int i = 0; i < slides.length; i++) {
           TextRun[] t = slides[i].getTextRuns();
           for (int j = 0; j < t.length; j++) {
              content.append(t[j].getText());
           }
           content.append(slides[i].getTitle());
       }
       return content.toString();
    }
}