java读取excel数据导入数据库

初始化readExcel对象 26为excel列数

//文件名称
String file_id = ra.getParameter("file_id");
//文件路径
String filePath = ra.getFileWritePath() + "files/" + file_id;
//文件对象
File file = new File(filePath);
//读取excel
ReadExcel readExcel = new ReadExcel(26);
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
  try {
//读取excel为list集合
      list = readExcel.getExcelInfo(file, filePath, 0);
      file.delete();
  } catch (Exception e) {
      e.printStackTrace();
      msg = "数据解析错误，请检查模板";
      System.err.println("数据解析错误，请检查模板");
  }
  			if (list.size() > 0) {

                try {
                    //遍历list校验数据
                    for (int i = 0; i < list.size(); i++) {
                        boolean kill = true;
                        Map<String, Object> map = list.get(i);
                        //获取第一个单元格数据 时间类型如果获取的为空会报空指针
                       	map.get("cell0").toString().trim()
                    }catch (Exception e) {
                        log().error(e.getMessage());
                        msg = e.getMessage();
                    }
                }
            }else {
                success = false;
                msg = "请检查文件";
            }

工具类

package com.originsys.dalianjinpu.util;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
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;
/**
 * 
 * @author xinp
 * 
 */
public class ReadExcel {
	// 总行数
	private int totalRows = 0;
	// 总条数
	private int totalCells = 0;
	private int  x = 0;
	// 错误信息接收器
	private String errorMsg;
	// 构造方法
	public ReadExcel() {
	}
	// 获取总行数
	public int getTotalRows() {
		return totalRows;
	}
	// 获取总列数
	public int getTotalCells() {
		return totalCells;
	}
	// 获取错误信息
	public String getErrorInfo() {
		return errorMsg;
	}
	// 构造方法
	public ReadExcel(int a) {
		this.x=a;
	}
	/**
	 * 读EXCEL文件，获取信息集合
	 * 
	 * @param fielName
	 * @return
	 */
	public List<Map<String, Object>> getExcelInfo(File File,String path,int sheetnub) {
		String fileName = File.getName();// 获取文件名
		//		List<Map<String, Object>> userList = new LinkedList<Map<String, Object>>();
		try {
			if (!validateExcel(fileName)) {// 验证文件名是否合格
				return null;
			}
			boolean isExcel2003 = true;// 根据文件名判断文件是2003版本还是2007版本
			if (isExcel2007(fileName)) {
				isExcel2003 = false;
			}
			FileInputStream in = new FileInputStream(path); 
			System.out.println("流："+in);
			return createExcel(in, isExcel2003,sheetnub);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}
	/**
	 * 根据excel里面的内容读取客户信息
	 * 
	 * @param is      输入流
	 * @param isExcel2003   excel是2003还是2007版本
	 * @return
	 * @throws IOException
	 */
	public List<Map<String, Object>> createExcel(FileInputStream is, boolean isExcel2003,int sheetnub) {
		try {
			Workbook wb = null;
			if (isExcel2003) {// 当excel是2003时,创建excel2003
				wb = new HSSFWorkbook(is);
			} else {// 当excel是2007时,创建excel2007
				wb = new XSSFWorkbook(is);
			}
			return readExcelValue(wb,sheetnub);// 读取Excel里面客户的信息
		} catch (IOException e) {
			e.printStackTrace();
		}
		return null;
	}
	/**
	 * 读取Excel里面客户的信息
	 * 
	 * @param wb
	 * @return
	 */
	private List<Map<String, Object>> readExcelValue(Workbook wb,int sheetnub) {
		// 得到第一个shell
		Sheet sheet = wb.getSheetAt(sheetnub);
		// 得到Excel的行数
		this.totalRows = sheet.getPhysicalNumberOfRows();
		// 得到Excel的列数(前提是有行数)
		if (totalRows > 1 && sheet.getRow(0) != null) {
			this.totalCells = sheet.getRow(0).getPhysicalNumberOfCells();
		}
		List<Map<String, Object>> userList = new ArrayList<Map<String, Object>>();
		// 循环Excel行数 从内容行开始遍历
		for (int r = 2; r < totalRows; r++) {
			Row row = sheet.getRow(r);
			if (row == null) {
				continue;
			}
			// 循环Excel的列
			Map<String, Object> map = new HashMap<String, Object>();
			for (int c = 0; c < x; c++) {
				Cell cell = row.getCell(c);
				if (null != cell) { 
					if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
						//						String name = new DecimalFormat("#").format(cell.getNumericCellValue());
						String name = String.valueOf(cell.getNumericCellValue());
						name = name == null ? name : name.trim().replaceAll("\r|\t|\n","");
						//						if (name.length() == 11 || name.length() == 18){
						map.put("cell"+c, name);
						//						}else {
						//							map.put("cell"+c, name.substring(0, name.length() - 2 > 0 ? name.length() - 2 : 1).trim());
						//						}
					} else {
						map.put("cell"+c, cell.getStringCellValue() == null? null :cell.getStringCellValue().trim().replaceAll("\r|\t|\n",""));
					}
				}
			}
			// 添加到list
			userList.add(map);
		}
		return userList;
	}
	/**
	 * 验证EXCEL文件
	 * 
	 * @param filePath
	 * @return
	 */
	public boolean validateExcel(String filePath) {
		if (filePath == null || !(isExcel2003(filePath) || isExcel2007(filePath))) {
			errorMsg = "文件名不是excel格式";
			return false;
		}
		return true;
	}
	// @描述：是否是2003的excel，返回true是2003
	public static boolean isExcel2003(String filePath) {
		return filePath.matches("^.+\\.(?i)(xls)$");
	}

	// @描述：是否是2007的excel，返回true是2007
	public static boolean isExcel2007(String filePath) {
		return filePath.matches("^.+\\.(?i)(xlsx)$");
	}

}