bootstrap-fileinput模态框导入Excel完整示例

本文对原文章中的jsp导入页面进行了优化，添加了模态框，从模态框进行导入；对excel文件进行区别取数据。

转自：http://www.cnblogs.com/zhaohz/p/7259128.html

1.下载bootstrap-fileinput-4.3.2

2.引入：

1

2

3

<linkrel="stylesheet" href="${basePath}/resources/plugs/bootstrap-fileinput/css/fileinput.min.css"/>

<scriptsrc="${basePath}/resources/plugs/bootstrap-fileinput/js/fileinput.min.js"></script>

<scriptsrc="${basePath}/resources/plugs/bootstrap-fileinput/js/locales/zh.js"></script>

3.界面

模态框和按钮

<button class="btn btn-primary btn-lg" data-toggle="modal" data-target="#myModal">批量导入</button><!-- 模态框（Modal） --><div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"><div class="modal-dialog"><div class="modal-content"><div class="modal-header"><button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button><h4 class="modal-title" id="myModalLabel">批量导入白名单</h4></div><div class="modal-body"><!-- 在这里添加一些文本 --><form id="importFile" name="importFile" class="form-horizontal" method="post" enctype="multipart/form-data"><div><label class="control-label">请选择要导入的excel文件：</label><input id="excelFile" name="excelFile" class="file-loading" type="file" multiple accept=".xls,.xlsx"></div></form></div><div class="modal-footer"></div></div><!-- /.modal-content --></div><!-- /.modal --></div>

4.js

//批量导入excelinitUpload("excelFile","excelC.zcUserC.excelInput.do");function initUpload(ctrlName,uploadUrl){var control = $("#"+ctrlName);control.fileinput({language:"zh",//设置语言uploadUrl:uploadUrl,//上传的地址uploadAsync:true,//默认异步上传showCaption:true,//是否显示标题showUpload:true,//是否显示上传按钮browseClass:"btn btn-primary",//按钮样式allowedFileExtensions: ["xls", "xlsx"], //接收的文件后缀maxFileCount: 1,//最大上传文件数限制previewFileIcon:'<i class="glyphicon glyphcion-file"></i>',showPreview: true, //是否显示预览// allowPreviewTypes:null,//是否显示预览previewFileIconSettings:{'docx':'<i class="glyphicon glyphcion-file"></i>','xlsx':'<i class="glyphicon glyphcion-file"></i>','pptx':'<i class="glyphicon glyphcion-file"></i>','jpg':'<i class="glyphicon glyphcion-picture"></i>','pdf':'<i class="glyphicon glyphcion-file"></i>','zip':'<i class="glyphicon glyphcion-file"></i>',},uploadExtraData:function(){var extraValue = "test";return {"excelType": extraValue};}});}$("#excelFile").on("fileuploaded",function(exevt,data,previewId,index){console.log("data:"+data.response.success);// alert(data);if(data.response.success == true){alert("导入成功！");$("#excelFile").fileinput("clear");$("#excelFile").fileinput("reset");$("#excelFile").fileinput("refresh");$("#excelFile").fileinput("enable");$(".close").click();$("#reload").click();}else{alert("导入失败:"+data.response.message);$("#excelFile").fileinput("clear");$("#excelFile").fileinput("reset");$("#excelFile").fileinput("refresh");$("#excelFile").fileinput("enable");}});

5.后台controller

@RequestMapping("/excelC.zcUserC.excelInput.do")@ResponseBodypublic Result importExcel(@RequestParam(value="excelFile",required=false)MultipartFile file,HttpServletRequest request) throws IOException, InterruptedException{MultipartRequest multipartRequest = (MultipartRequest)request;MultipartFile excelFile = multipartRequest.getFile("excelFile");//Map<String,Object> map = new HashMap<String, Object>();if(excelFile != null){String fileName = excelFile.getOriginalFilename();String type = fileName.substring(fileName.lastIndexOf(".")+1);//根据excel类型取数据if("xlsx".equals(type) || "xlsx".equals(type)){List<List<String>> datas = ("xlsx".equals(type) ? ExcelUtil.readXlsx(excelFile.getInputStream()) : ExcelUtil.readXls(excelFile.getInputStream()));//读取的内容后处理if(datas !=null && datas.size()>0){//.....return new Result(true);}}else{return new Result(false,"请使用excel导入！");}}else{return new Result(false);}return new Result(false);}

6.相关类

result

public class Result {private boolean success;private String message;public Result(boolean success){this.success = success;}public Result(boolean success,String message){this.success = success;this.message = message;}public boolean isSuccess(){return success;}public void setSuccess(boolean success){this.success = success;}public String getMessage(){return message;}public void setMessage(String message){this.message = message;}}

excelutil

import java.io.FileInputStream;import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.List;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.hssf.util.HSSFColor;import org.apache.poi.ss.usermodel.Cell;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;public class ExcelUtil{private XSSFWorkbook wb = null;private XSSFSheet sheet = null;/** * @param wb * @param sheet */public ExcelUtil(XSSFWorkbook wb, XSSFSheet sheet){this.wb = wb;this.sheet = sheet;}/** * 合并单元格后给合并后的单元格加边框 *  * @param region * @param cs */public void setRegionStyle(CellRangeAddress region, XSSFCellStyle cs){int toprowNum = region.getFirstRow();for (int i = toprowNum; i <= region.getLastRow(); i++){XSSFRow row = sheet.getRow(i);for (int j = region.getFirstColumn(); j <= region.getLastColumn(); j++){XSSFCell cell = row.getCell(j);// XSSFCellUtil.getCell(row,// (short) j);cell.setCellStyle(cs);}}}/** * 设置表头的单元格样式 *  * @return */public XSSFCellStyle getHeadStyle(){// 创建单元格样式XSSFCellStyle cellStyle = wb.createCellStyle();// 设置单元格的背景颜色为淡蓝色cellStyle.setFillForegroundColor(HSSFColor.PALE_BLUE.index);cellStyle.setFillPattern(XSSFCellStyle.SOLID_FOREGROUND);// 设置单元格居中对齐cellStyle.setAlignment(XSSFCellStyle.ALIGN_CENTER);// 设置单元格垂直居中对齐cellStyle.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);// 创建单元格内容显示不下时自动换行cellStyle.setWrapText(true);// 设置单元格字体样式XSSFFont font = wb.createFont();// 设置字体加粗font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);font.setFontName("宋体");font.setFontHeight((short) 200);cellStyle.setFont(font);// 设置单元格边框为细线条cellStyle.setBorderLeft(XSSFCellStyle.BORDER_THIN);cellStyle.setBorderBottom(XSSFCellStyle.BORDER_THIN);cellStyle.setBorderRight(XSSFCellStyle.BORDER_THIN);cellStyle.setBorderTop(XSSFCellStyle.BORDER_THIN);return cellStyle;}/** * 设置表体的单元格样式 *  * @return */public XSSFCellStyle getBodyStyle(){// 创建单元格样式XSSFCellStyle cellStyle = wb.createCellStyle();// 设置单元格居中对齐cellStyle.setAlignment(XSSFCellStyle.ALIGN_CENTER);// 设置单元格垂直居中对齐cellStyle.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER);// 创建单元格内容显示不下时自动换行cellStyle.setWrapText(true);// 设置单元格字体样式XSSFFont font = wb.createFont();// 设置字体加粗font.setBoldweight(XSSFFont.BOLDWEIGHT_BOLD);font.setFontName("宋体");font.setFontHeight((short) 200);cellStyle.setFont(font);// 设置单元格边框为细线条cellStyle.setBorderLeft(XSSFCellStyle.BORDER_THIN);cellStyle.setBorderBottom(XSSFCellStyle.BORDER_THIN);cellStyle.setBorderRight(XSSFCellStyle.BORDER_THIN);cellStyle.setBorderTop(XSSFCellStyle.BORDER_THIN);return cellStyle;}//导入excelpublic static List<List<String>> readXlsx(String path) throws IOException {InputStream input = new FileInputStream(path);return readXlsx(input);}public static List<List<String>> readXls(String path) throws IOException {InputStream input = new FileInputStream(path);return readXls(input);}public static List<List<String>> readXlsx(InputStream input) throws IOException {List<List<String>> result = new ArrayList<List<String>>();XSSFWorkbook workbook = new XSSFWorkbook(input);for (XSSFSheet xssfSheet : workbook) {if (xssfSheet == null) {continue;}for (int rowNum = 1; rowNum <= xssfSheet.getLastRowNum(); rowNum++) {XSSFRow row = xssfSheet.getRow(rowNum);int minCellNum = row.getFirstCellNum();int maxCellNum = row.getLastCellNum();List<String> rowList = new ArrayList<String>();for (int i = minCellNum; i < maxCellNum; i++) {XSSFCell cell = row.getCell(i);if (cell == null) {continue;}rowList.add(cell.toString());}result.add(rowList);}}return result;}public static List<List<String>> readXls(InputStream input) throws IOException {List<List<String>> result = new ArrayList<List<String>>();HSSFWorkbook workbook = new HSSFWorkbook(input);for (int numSheet = 0; numSheet < workbook.getNumberOfSheets(); numSheet++) {HSSFSheet sheet = workbook.getSheetAt(numSheet);if (sheet == null) {continue;}for (int rowNum = 1; rowNum <= sheet.getLastRowNum(); rowNum++) {HSSFRow row = sheet.getRow(rowNum);int minCellNum = row.getFirstCellNum();int maxCellNum = row.getLastCellNum();List<String> rowList = new ArrayList<String>();for (int i = minCellNum; i < maxCellNum; i++) {HSSFCell cell = row.getCell(i);if (cell == null) {continue;}rowList.add(getStringVal(cell));}result.add(rowList);}}return result;}private static String getStringVal(HSSFCell cell) {switch (cell.getCellType()) {case Cell.CELL_TYPE_BOOLEAN:return cell.getBooleanCellValue() ? "TRUE" : "FALSE";case Cell.CELL_TYPE_FORMULA:return cell.getCellFormula();case Cell.CELL_TYPE_NUMERIC:cell.setCellType(Cell.CELL_TYPE_STRING);return cell.getStringCellValue();case Cell.CELL_TYPE_STRING:return cell.getStringCellValue();default:return null;}}}