利用poi工具把上篇输出后的.xls的内容读出来，打印到控制台。


  
  1. package com.lzz.hssf; 
  2.  
  3. import java.io.FileInputStream; 
  4. import java.io.InputStream; 
  5. import java.util.Iterator; 
  6.  
  7.  
  8. import org.apache.poi.hssf.extractor.ExcelExtractor; 
  9. import org.apache.poi.hssf.usermodel.HSSFCell; 
  10. import org.apache.poi.hssf.usermodel.HSSFDateUtil; 
  11. import org.apache.poi.hssf.usermodel.HSSFRow; 
  12. import org.apache.poi.hssf.usermodel.HSSFSheet; 
  13. import org.apache.poi.hssf.usermodel.HSSFWorkbook; 
  14.  
  15. /** 
  16.  * 读取上篇中的xls文件的内容，并打印出来 
  17.  * @author Administrator 
  18.  * 
  19.  */ 
  20. public class PoiReadTable { 
  21.  
  22.     /**读取一个excel文件的内容 
  23.      * @param args 
  24.      * @throws Exception  
  25.      */ 
  26.     public static void main(String[] args) throws Exception { 
  27.         //extractor(); 
  28.         readTable(); 
  29.     } 
  30.      
  31.      
  32.     //通过对单元格遍历的形式来获取信息 ，这里要判断单元格的类型才可以取出值
  33.     public static void readTable() throws Exception{ 
  34.         InputStream ips=new FileInputStream("d://test2-1.xls"); 
  35.         HSSFWorkbook wb=new HSSFWorkbook(ips); 
  36.         HSSFSheet sheet=wb.getSheetAt(0); 
  37.         for(Iterator ite=sheet.rowIterator();ite.hasNext();){ 
  38.             HSSFRow row=(HSSFRow)ite.next(); 
  39.             System.out.println(); 
  40.             for(Iterator itet=row.cellIterator();itet.hasNext();){ 
  41.                 HSSFCell cell=(HSSFCell)itet.next(); 
  42.                 switch(cell.getCellType()){   
  43.                 case HSSFCell.CELL_TYPE_BOOLEAN:   
  44.                     //得到Boolean对象的方法   
  45.                     System.out.print(cell.getBooleanCellValue()+" ");   
  46.                     break;   
  47.                 case HSSFCell.CELL_TYPE_NUMERIC:   
  48.                     //先看是否是日期格式   
  49.                     if(HSSFDateUtil.isCellDateFormatted(cell)){   
  50.                         //读取日期格式   
  51.                         System.out.print(cell.getDateCellValue()+" ");   
  52.                     }else{   
  53.                         //读取数字   
  54.                         System.out.print(cell.getNumericCellValue()+" ");   
  55.                     }   
  56.                     break;   
  57.                 case HSSFCell.CELL_TYPE_FORMULA:   
  58.                     //读取公式   
  59.                     System.out.print(cell.getCellFormula()+" ");   
  60.                     break;   
  61.                 case HSSFCell.CELL_TYPE_STRING:   
  62.                     //读取String   
  63.                     System.out.print(cell.getRichStringCellValue().toString()+" ");   
  64.                     break;                     
  65.             }   
  66.             } 
  67.         } 
  68.          
  69.     } 
  70.      
  71.     //直接抽取excel中的数据 
  72.     public static void extractor() throws Exception{ 
  73.         InputStream ips=new FileInputStream("d://test2-1.xls"); 
  74.         HSSFWorkbook wb=new HSSFWorkbook(ips); 
  75.         ExcelExtractor ex=new ExcelExtractor(wb); 
  76.         ex.setFormulasNotResults(true); 
  77.         ex.setIncludeSheetNames(false); 
  78.         String text=ex.getText(); 
  79.         System.out.println(text);  
  80.     } 
  81. }