导入Excel 文件(https://www.cnblogs.com/smart-hwt/p/8243420.html)
1。js事件
function loadExcel(){
index = openDialogNoBtn(GetBasePath() + "/ipAdmin/loadnewview.do","导入Excel", "380px", "200px", null,null);
}、
2. 控制器ipAdmin
@RequestMapping("/loadnewview")
public ModelAndView loadnewview() {
ModelAndView mv = new ModelAndView();
mv.setViewName("Views/ip/loadExcel");
return mv;
}
3。前台页面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>导入Excel</title>
<%@ include file="/Views/Shared/_layoutForm.jsp"%>
<!-- 日期选择插件 -->
<script src="<%=basePath%>/Content/js/plugins/layer/laydate/laydate.js"></script>
<!-- 自动补全插件 -->
<script src="<%=basePath%>/Content/js/plugins/suggest/bootstrap-suggest.min.js"></script>
<!-- 复选框 -->
<link href="<%=basePath%>/Content/css/plugins/iCheck/custom.css" rel="stylesheet">
<script src="<%=basePath%>/Content/js/plugins/iCheck/icheck.min.js"></script>
<!-- 文件上传插件 -->
<link href="<%=basePath%>/Content/js/user_plugins/uploadify/uploadify.css" rel="stylesheet">
<script src="<%=basePath%>/Content/js/user_plugins/uploadify/jquery.uploadify.js"></script>
<!-- 自定义树状结构 -->
<link href="<%=basePath%>/Content/js/user_plugins/tree/tree.css" rel="stylesheet">
<script src="<%=basePath%>/Content/js/user_plugins/tree/tree.js"></script>
<!-- 单选、多选下拉列表 -->
<script src="<%=basePath%>/Content/js/plugins/chosen/chosen.jquery.js"></script>
<script type="text/javascript">
var User = function() {
this.init = function() {
//选择文件
$("#uploadEventBtn").unbind("click").bind("click", function() {
$("#uploadEventFile").click();
});
$("#uploadEventFile").bind("change", function() {
$("#uploadEventPath").attr("value", $("#uploadEventFile").val());
});
};
//点击上传钮
this.uploadBtn = function() {
var uploadEventFile = $("#uploadEventFile").val();
if (uploadEventFile == '') {
alert("请择excel,再上传");
} else if (uploadEventFile.lastIndexOf(".