Java用poi读取excel文件

POI 是Apache的一个开源的工具包，可以在Apache的官网下载到jar包。

如下为简单示例：

package POI;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
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.poifs.filesystem.POIFSFileSystem;
 
public class ReadExcel {
 public static void main(String[] args) {
  try {
   InputStream input = new FileInputStream("D:\\test.xls");
   POIFSFileSystem fs = new POIFSFileSystem(input);
   HSSFWorkbook wb = new HSSFWorkbook(fs);
   HSSFSheet sheet = wb.getSheetAt(0);

   // Iterate over each row in the sheet
   Iterator rows = sheet.rowIterator();

   while (rows.hasNext()) {
    HSSFRow row = (HSSFRow) rows.next();
    System.out.println("Row #" + row.getRowNum());
    // Iterate over each cell in the row and print out the cell"s
    // content
    Iterator cells = row.cellIterator();
    while (cells.hasNext()) {
     HSSFCell cell = (HSSFCell) cells.next();
     System.out.println("Cell #" + cell.getCellNum());
     switch (cell.getCellType()) {
     case HSSFCell.CELL_TYPE_NUMERIC:
      System.out.println(cell.getNumericCellValue());
      break;
     case HSSFCell.CELL_TYPE_STRING:
      System.out.println(cell.getStringCellValue());
      break;
     case HSSFCell.CELL_TYPE_BOOLEAN:
      System.out.println(cell.getBooleanCellValue());
      break;
     case HSSFCell.CELL_TYPE_FORMULA:
      System.out.println(cell.getCellFormula());
      break;
     default:
      System.out.println("unsuported sell type");
      break;
     }
    }
   }
  } catch (IOException ex) {
   ex.printStackTrace();
  }
 }

}

评论

1 楼 oyzzhou 2012-02-08  

如何在官网下载啊？