SSM POI根据预定好的模版导出execle

建立模版文件，xls格式。打包为template.zip，放入项目根目录的zip包下

Controller

import java.util.HashMap;
import java.util.List;
import java.util.Map;


import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;


import com.jk.danganweihu.entity.Dqxx;
import com.jk.danganweihu.entity.JbXX;
import com.jk.danganweihu.service.RensdataService;
import com.jk.util.POIExportExcel;
import com.jk.util.PagerEntity;

@RequestMapping("out2Execle")
		@ResponseBody
		public boolean out2Execle(HttpServletRequest request,String id){
//			FilesImg fileImg=filesImgService.findBinaryByFid("5b049e95bece499086439ad38ba49118");
			
			JbXX jbxx = rensdataService.queryJbData(id);
			Map<String,Object> map=new HashMap<String,Object>();
			map.put("zwbh", jbxx.getcBh());//职位编号
			map.put("name", jbxx.getcName());//姓名
			map.put("sex", jbxx.getcXb());//性别
			map.put("gzdw", jbxx.getcGzdw());//工作单位
			map.put("oldName", jbxx.getcCym());//曾用名
			map.put("mz", jbxx.getcMz());//民族
			map.put("bmlb", jbxx.getcBmlb());//部门类别
			map.put("gblb", jbxx.getcGblb());//干部类别
//			map.put("age", "26");
			
			
			//注意模版一定要是xls格式
			Map<String, String> impOrSaveExcel = POIExportExcel.ImpOrSaveExcel("basicPersonalInfo.xls", "基本人员信息.xls", map, request);
			if (impOrSaveExcel!=null) {
				return true;
			}else {
				return false;
			}
		}

Util

package com.jk.util;

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Blob;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Properties;

import javax.servlet.http.HttpServletRequ