建立模版文件,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;
}
}
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