1. /**     
  2.  * 文件名：ExcelReadTest.java     
  3.  * 版本信息：     
  4.  * 日期：2013-5-2     
  5.  * Copyright 足下 Corporation 2013      
  6.  * 版权所有     
  7.  *     
  8.  */ 
  9. package com.august.xgame.server.test; 
  10.  
  11. import java.io.File; 
  12. import java.io.FileInputStream; 
  13. import java.io.IOException; 
  14. import java.text.DecimalFormat; 
  15. import java.text.SimpleDateFormat; 
  16. import java.util.LinkedList; 
  17. import java.util.List; 
  18.  
  19. import org.apache.poi.hssf.usermodel.HSSFDateUtil; 
  20. import org.apache.poi.xssf.usermodel.XSSFCell; 
  21. import org.apache.poi.xssf.usermodel.XSSFRow; 
  22. import org.apache.poi.xssf.usermodel.XSSFSheet; 
  23. import org.apache.poi.xssf.usermodel.XSSFWorkbook; 
  24.  
  25. /** 
  26.  * 创建时间：2013-5-2 下午2:09:06 
  27.  */ 
  28. public class ExcelReadTest 
  29. { 
  30.     public static void main(String[] args) throws Exception 
  31.     { 
  32.         readTest(new File("d:/career.xlsx")); 
  33.     } 
  34.  
  35.     // 读取Office 2007excel 
  36.     public static List<List<Object>> readTest(File file) throws Exception 
  37.     { 
  38.         List<List<Object>> list = new LinkedList<List<Object>>(); 
  39.         // 构造XSSFWorkbook对象，strPath传入文件路径 
  40.         XSSFWorkbook xwb = new XSSFWorkbook(new FileInputStream(file)); 
  41.         // 读取第一张表格的内容 
  42.         XSSFSheet sheet = xwb.getSheetAt(0); 
  43.         Object value = null; 
  44.         XSSFRow row = null; 
  45.         XSSFCell cell = null; 
  46.         System.out.println("读取2007excel内容如下："); 
  47.         for (int i = sheet.getFirstRowNum(); i < sheet.getPhysicalNumberOfRows(); i++) 
  48.         { 
  49.             row = sheet.getRow(i); 
  50.             if (row == null) 
  51.             { 
  52.                 continue; 
  53.             } 
  54.             List<Object> linked = new LinkedList<Object>(); 
  55.             for (int j = row.getFirstCellNum(); j < row.getLastCellNum(); j++) 
  56.             { 
  57.                 cell = row.getCell(j); 
  58.                 if (cell == null) 
  59.                 { 
  60.                     continue; 
  61.                 } 
  62.                 DecimalFormat df = new DecimalFormat("0");// 格式化 number string 
  63.                 // 字符 
  64.                 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//  格式化日期字符串  
  65.                 DecimalFormat nf = new DecimalFormat("0.00");// 格式化数字 
  66.                 switch (cell.getCellType()) 
  67.                 { 
  68.                 case XSSFCell.CELL_TYPE_STRING: 
  69.                     // System.out.println(i+"行"+j+"列 is String type"); 
  70.                     value = cell.getStringCellValue(); 
  71.                     System.out.println(" " + value + " "); 
  72.                     break; 
  73.                 case XSSFCell.CELL_TYPE_NUMERIC: 
  74.                     if ("@".equals(cell.getCellStyle().getDataFormatString())) 
  75.                     { 
  76.                         value = df.format(cell.getNumericCellValue()); 
  77.                     } else if ("General".equals(cell.getCellStyle().getDataFormatString())) 
  78.                     { 
  79.                         value = nf.format(cell.getNumericCellValue()); 
  80.                     } else 
  81.                     { 
  82.                         value = sdf.format(HSSFDateUtil.getJavaDate(cell.getNumericCellValue())); 
  83.                     } 
  84.                     System.out.println(" " + value + " "); 
  85.                     break; 
  86.                 case XSSFCell.CELL_TYPE_BOOLEAN: 
  87.                     value = cell.getBooleanCellValue(); 
  88.                     System.out.println(" " +value + " "); 
  89.                     break; 
  90.                 case XSSFCell.CELL_TYPE_BLANK: 
  91.                     value = ""; 
  92.                     System.out.println(value); 
  93.                     break; 
  94.                 default: 
  95.                     value = cell.toString(); 
  96.                     System.out.println(" " + value + " "); 
  97.                     break; 
  98.                 } 
  99.                 if (value == null || "".equals(value)) 
  100.                 { 
  101.                     continue; 
  102.                 } 
  103.                 linked.add(value); 
  104.             } 
  105.             System.out.println(""); 
  106.             list.add(linked); 
  107.         } 
  108.         return list; 
  109.     } 
  110. }