JAVA 读取Excel 上传数据

导入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(".

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值