java poi 读取Excel demo

package apiTest;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.*;

import org.apache.poi.hssf.extractor.ExcelExtractor;
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;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;

public class ReadExcel {

 @SuppressWarnings("unchecked")
 public static void main(String[] args) throws Exception {
     HSSFWorkbook wb = null;
     POIFSFileSystem fs = null;
     try {
       fs = new POIFSFileSystem(new FileInputStream("e://workbook.xls"));
       wb = new HSSFWorkbook(fs);
     } catch (IOException e) {
       e.printStackTrace();
     }

     HSSFSheet sheet = wb.getSheetAt(0);
     //sheetName
     System.out.println(sheet.getSheetName());
//     HSSFRow row1 = sheet.getRow(0);
//     HSSFCell cell = row1.getCell(3);
//     String msg1 = cell.getStringCellValue();
//     System.out.println(msg1);
//     HSSFRow row2 = sheet.getRow(1);
//     HSSFCell cell2 = row2.getCell(2);
//     //System.out.println(cell2);
//     Double msg11 = cell2.getNumericCellValue();
//     System.out.println(msg11);
     List arrayListAll = new ArrayList();
     for (Iterator<Row> iter = (Iterator<Row>) sheet.rowIterator(); iter.hasNext();) {
         Row row = iter.next();
         Map<Integer,Object> hashmap = new HashMap();
         int i = 0;
         for (Iterator<Cell> iter2 = (Iterator<Cell>) row.cellIterator(); iter2.hasNext();) {
          Cell cell = iter2.next();
          String content = cell.getStringCellValue();// 除非是sring类型，否则这样迭代读取会有错误
          hashmap.put(i, content);
          i++;
         }
         arrayListAll.add(hashmap);
     }
     Iterator it1 = arrayListAll.iterator();
     while(it1.hasNext()){
      //System.out.println(it1.next());
      Map map = (HashMap)it1.next();
      System.out.println(map.get(0));
      System.out.println(map.get(1));
      System.out.println(map.get(2));
      System.out.println(map.get(3));
      System.out.println(map.get(5));
     }
 }
}

//http://hi.baidu.com/eagledemo/blog/item/9161d92a8d583221d42af1c2.html