java excel 读取工具_java读取Excel工具类

分享一个想将Excel导入数据库的工具类，各位猿友可以直接用

import java.beans.IntrospectionException;

import java.beans.PropertyDescriptor;

import java.io.InputStream;

import java.lang.reflect.InvocationTargetException;

import java.lang.reflect.Method;

import java.math.BigDecimal;

import java.text.DecimalFormat;

import java.text.NumberFormat;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

import java.util.Date;

import java.util.List;

import java.util.Map;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

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.ss.util.CellRangeAddress;

import org.apache.poi.xssf.usermodel.XSSFCell;

import org.apache.poi.xssf.usermodel.XSSFCellStyle;

import org.apache.poi.xssf.usermodel.XSSFFont;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import com.luo.domain.ExcelBean;

public class ExcelUtil {

private final static String excel2003L =".xls"; //2003- 版本的excel

private final static String excel2007U =".xlsx"; //2007+ 版本的excel

/**

* Excel导入

*/

public static List> getBankListByExcel(InputStream in, String fileName) throws Exception{

List> list = null;

//创建Excel工作薄

Workbook work = getWorkbook(in,fileName);

if(null == work){

throw new Exception("创建Excel工作薄为空！");

}

Sheet sheet = null;

Row row = null;

Cell cell = null;

list = new ArrayList>();

//遍历Excel中所有的sheet

for (int i = 0; i < work.getNumberOfSheets(); i++) {

sheet = work.getSheetAt(i);

if(sheet==null){continue;}

//遍历当前sheet中的所有行

//包涵头部，所以要小于等于最后一列数,这里也可以在初始值加上头部行数，以便跳过头部

for (int j = sheet.getFirstRowNum(); j <= sheet.getLastRowNum(); j++) {

//读取一行

row = sheet.getRow(j);

//去掉空行和表头

if(row==null||row.getFirstCellNum()==j){continue;}

//遍历所有的列

List

点赞

1

收藏

分享

文章举报

呵驼货

发布了1 篇原创文章 · 获赞 1 · 访问量 174

私信

关注