poi完成excel文件上传和下载

一、 上传excel文件

1  spring-mvc.xml

    <bean id="multipartResolver"
		class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
		<property name="defaultEncoding" value="utf-8" />
		<property name="maxUploadSize" value="10485760000" />
		<property name="maxInMemorySize" value="40960" />
	</bean>

 

2  jsp页面 - 导入excel代码块

<div  style="margin: 20px auto">
   <form class="form form-horizontal" id="form-article-add" enctype="multipart/form-data">
      <span class="tit" style="width: 80px;">选择导入文件：</span>
      <input type="file" multiple name="file" class="input-file" id="file">
   </form>
</div>

<div class="clearfix form-btn" style="margin-left: 80px;  margin-top: 20px;">
   <a id="importBtn" class="btns btns-normal" href="javascript:void(0)">导入excel</a>
   <a id="exportBtn" class="btns btns-normal" href="javascript:void(0)">导出excel</a>
</div>

    //导入
    $("#importBtn").click(function(){
        importLists();
    });

    /*导入数据*/
    function importLists(){
        //var clientid = $("#clientid").val();
        var FormDatas=new FormData($("#form-article-add")[0]);
        var fileName=$("#file").val();
        if(fileName == '') {
            alert('请选择文件！');
            return false;
        }
        //验证文件格式
        var fileType = (fileName.substring(fileName.lastIndexOf(".") + 1, fileName.length)).toLowerCase();
        if (fileType != 'xls' && fileType != 'xlsx') {
            alert('文件格式不正确！');
            return false;
        }
        $.ajax({
            type:'post',
            url:'${rootUrl}importList.dox',
            async : false,
            cache : false,
            contentType : false,
            processData : false,
            data:FormDatas,
            success: function(data){
                data = JSON.parse(data);
                if(data == "1"){
                    alert("名单上传成功！");
                }
                if(data == "0"){
                    alert("名单上传失败！");
                }