poi读取excel 转换实体_POI读取excel工具类 返回实体bean集合(xls,xlsx通用)

package com.boot.utils;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import java.io.InputStream;

import java.util.ArrayList;

import java.util.List;

import org.apache.poi.openxml4j.exceptions.InvalidFormatException;

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.ss.usermodel.WorkbookFactory;

import com.boot.entity.User;

public class ExcelReader {

/**

* 根据excal路径生成实体集合

* @author Changhai

* @data 2017-7-5

* @param filePath

* @return

*/

public static List> getList(String filePath){

InputStream is;

try {