记录一个POI解析Excel表格的工具类实现表格的导入

读出数据！

先记录一下，等有空了再好好整理

package com.***.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.text.DecimalFormat;
import java.text.NumberFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.shiro.SecurityUtils;



public class POIUtils {

    public static  Workbook getWorkbook(InputStream inStr,String fileName) throws Exception{  
        Workbook wb = null;  
        String fileType = fileName.substring(fileName.lastIndexOf("."));  
                
        if(fileName.endsWith("xls")){
        	wb = new HSSFWorkbook(inStr);  //2003-  
        }else if(fileName.endsWith("xlsx")){
        	 wb = new XSSFWorkbook(inStr);  //2007+  
        }
               
        else{  
            throw new Exception("解析的文件格式有误！");  
        }  
        return wb;  
    }  
   
    

    	 public static void ReadExcel(File file) {
    		 
    		 try {
    			 // 创建输入流，读取Excel
    				InputStream inStr = new FileInputStream(file.getAbsolutePath());
    				// jxl提供的Workbook类
    				Workbook wb = getWorkbook(inStr,"58简历.xls");
    				// Excel的页签数量
    				
    				int sheet_size = wb.getNumberOfSheets();
    				for (int index = 0; index < sheet_size; index++) { 
    					// 每个页签创建一个Sheet对象
    					Sheet sheet = wb.getSheetAt(index);
    					// sheet.getRows()返回该页的总行数
    					for (int i = 0; i < sheet.getPhysicalNumberOfRows(); i++) {
    						
    						// sheet.getColumns()返回该页的总列数
    						Row row = sheet.getRow(i);
//    						for(Cell cell:row){
//    							System.out.println(getCellValue(cell));
//    							
//    						}
    						
    						
    					}
    				}
    			} catch (Exception e) {
    				e.printStackTrace();
    			
    			} 
    	 }}