使用以上導(dǎo)包如果報錯?NoClassDefFoundError，可能需要引入cglib包
?1、excel的導(dǎo)入
前端代碼：
:
由于前端type="file"的樣式固定，可以隱藏input，通過其他按鈕點擊觸發(fā)上傳，用戶上傳文件后input的值發(fā)生變化觸發(fā)change事件調(diào)用ajax
$('#fileId').change(function(){
//獲取用戶上傳文件
var files = $('#fileId')[0].files
var i_type = 0;
//定義傳參格式
var data = new FormData();
data.append('avatar', files[0]);
data.append('i_type',i_type);
$.ajax({
url: cp + 'mgt/depotwares/import.do',
type: 'POST',
data: data,
cache: false,
processData: false,
contentType: false,
success:function (data) {
var result = JSON.parse(data);
$("#fileId").val('');
if(result.s_code == "000000"){
var sucess = result.o_data[0]
var fail = result.o_data[1]
layer.confirm(("導(dǎo)入成功! 成功:"+sucess+",失敗:"+fail),{
btn: ['關(guān)閉','下載失敗信息'] //按鈕
}, function(){//是
layer.closeAll();
},function(){//
let downloadurl="http://localhost:8081/fhxhcps//mgt/depotwares/downloadfail.do";
let label = $("<a>");
label.prop("href",downloadurl);
$("body").append(label)
label[0].click();
label.remove();
});
}else{
layer.msg(result.s_msg)
}
}
});
});?后端代碼：
controller層接收
public void WaresBatchUpdate(HttpServletRequest request,
HttpServletResponse response,
@RequestParam(required = false, value = "avatar") MultipartFile filename,
HttpSession session, Model model,String i_type) throws IOException?實現(xiàn)類：文章來源：http://www.zghlxwxcb.cn/news/detail-616350.html
ResultMap resMap = new ResultMap();
//更新條數(shù)結(jié)果返回
List list = new ArrayList();
//記錄所有excel數(shù)據(jù)
List lists = new ArrayList();
//用于寫入保存失敗數(shù)據(jù)
List<ExcelVO> failList = new ArrayList();
List<PvdSettleVO> pvdfailList = new ArrayList<>();
List<IWaresVO> iWaresList = new ArrayList<>();
//記錄成功條數(shù)
int sucess = 0;
//記錄失敗條數(shù)
int fail = 0;
//判斷當前修改稅務(wù)編碼還是供應(yīng)商
Workbook workbook = null;
Properties properties = PropertiesUtil.load("pdf_config/exportPdf.properties");
String wordGenerDir = properties.getProperty("excel.taxno.savepath");
String name = Str(userMap.get("s_name"),"");
String sUser = Str(userMap.get("s_user"),"");
Date now = new Date();
SimpleDateFormat outFormat = new SimpleDateFormat("yyyyMMddHHmmss");
String time = outFormat.format(now);
String newFile = name+sUser+"DT"+time +file.getOriginalFilename();
String path2 = wordGenerDir+newFile;
ResultMap resMap = new ResultMap();
File foler = null;
// 讀取excel文件
FileInputStream in = null;
// 獲取工作簿
Workbook workbook = null;
//獲取路徑
foler = new File(path2);
String path = foler.getAbsolutePath();
String filetype = path.substring(path.lastIndexOf("."));
try {
file.transferTo(foler);
File dest = new File(path);
in = new FileInputStream(path);
if (!foler.getParentFile().exists()) {
//創(chuàng)建
foler.getParentFile().mkdirs();
}
if (filetype.equals(".xls")) {
workbook = new HSSFWorkbook(in);
} else if (filetype.equals(".xlsx")) {
workbook = new XSSFWorkbook(in);
} else {
resMap.setS_code(Constants.RES_MSG_ERROR);
resMap.setS_msg("文件類型必須是xls或xlsx:" + file.getOriginalFilename());
dest.delete();
return resMap;
}
}catch (Exception e){
System.out.println("文件異常");
}finally {
try {
if (in != null) {
in.close();
}
if (workbook != null) {
workbook.close();
}
} catch (IOException e) {
resMap.setS_msg("關(guān)閉流失敗");
}
}
try {
//獲取sheet1
Sheet sheet = workbook.getSheetAt(0);
//獲取表中內(nèi)容
int rowCount = sheet.getPhysicalNumberOfRows();
for (int rowNum = 1; rowNum < rowCount; rowNum++) {
String value1 = "";
String value2 = "";
String value3 = "";
Row rowData = sheet.getRow(rowNum);
Map map = new HashMap();
if (rowData != null) {
Cell cell1 = rowData.getCell(0);
Cell cell2 = rowData.getCell(1);
Cell cell3 = rowData.getCell(2);
value1 = ExcelUtils.getCellValue(cell1);
value2 = ExcelUtils.getCellValue(cell2);
value3 = ExcelUtils.getCellValue(cell3);
map.put("col1", value1);
map.put("col2", value2);
map.put("col3", value3);
lists.add(map);
}
}
//excel寫入未導(dǎo)入成功信息
//repath即為存放文件路徑(絕對路徑+名稱)
ExcelWriterBuilder write = EasyExcel.write(repath);
ExcelWriterSheetBuilder sheet1 = write.sheet();
sheet1.doWrite(failList);2.Excel的模板下載
這里用的是在本地下載文件，指定一個文件路徑創(chuàng)建excel模板，通過流的方式直接下載文章來源地址http://www.zghlxwxcb.cn/news/detail-616350.html
前端代碼：直接通過訪問接口方式建立下載鏈接
$("#downloadWare").click(function () {
$.ajax({
url: cp + 'mgt/depotwares/downloadWareTemplete.do',
method: 'get',
type:"application/vnd.ms-excel",
responseType:"blob",
success: function(data){
let downloadurl="http://localhost:8081/depotwares/downloadWareTemplete.do";
let label = $("<a>");
label.prop("href",downloadurl);
$("body").append(label)
label[0].click();
label.remove();
layer.msg("下載成功")
}
})
})后端代碼：
try {
// path是指下載的文件的路徑。
File file = new File(ExcelUtils.getFolerPath());
// 取得文件名。
String filename = file.getName();
// 以流的形式下載文件。
InputStream fis = new BufferedInputStream(new FileInputStream(ExcelUtils.getFolerPath()));
byte[] buffer = new byte[fis.available()];
fis.read(buffer);
fis.close();
// 清空response
response.reset();
// 設(shè)置response的Header
if(request.getHeader("user-agent").toLowerCase().indexOf("firefox")>-1){
response.setHeader("Content-Disposition","attachment;filename=" +new String(filename.getBytes("utf-8"),"ISO-8859-1"));
}else {
response.addHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(filename, "utf-8"));
}
response.addHeader("Content-Length", "" + file.length());
OutputStream toClient = new BufferedOutputStream(response.getOutputStream());
response.setContentType("application/octet-stream");
toClient.write(buffer);
toClient.flush();
toClient.close();
} catch (Exception e) {
response.reset();
response.setContentType("application/json");
response.setCharacterEncoding("utf-8");
resMap.setS_code(Constants.RES_CODE_ERROR);
resMap.setS_msg(Constants.RES_MSG_ERROR);
}到了這里，關(guān)于使用EasyExcel導(dǎo)入、根據(jù)模板下載(附前后端代碼)的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
