完整代码,可直接复用!觉着可以记得留赞关注我!
需求:最近一直要提交很多sql工单数据给DB管理员执行,一个一个复制很麻烦,于是写下此方法!如有高见欢迎留言!
注意:记得引入poi包
如果你觉着不错,麻烦帮忙点个赞!分享下!谢谢!
package com.example.util; import org.apache.commons.lang3.StringUtils; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.*; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import java.io.*; import java.util.ArrayList; import java.util.List; /** * 功能:读取excel数据,生成批量sql * @author kangzhuang * @date 20190822 * */ public class ExcelReadUtil { private static Logger logger = LoggerFactory.getLogger(ExcelReadUtil.class); private static Workbook workbook; private static Sheet sheet; /** * 初始化表格,判断文件格式是xls还是xlsx * @param excelPath */ private static void initExcel(String excelPath){ if (StringUtils.isEmpty(excelPath)){ logger.info("文件路径不能为空"); workbook = null; return; } try { InputStream is = new FileInputStream(excelPath); if (excelPath.endsWith(".xls")){//.xls格式 workbook = new HSSFWorkbook(is); }else if(excelPath.endsWith(".xlsx")){//.xlsx格式 workbook = new XSSFWorkbook(is); }else{