• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

微信小程序导出excel - ALWAYS☆REMIND

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

微信小程序导出excel

前端代码

createReport(){
				this.checkedList=[];
				for(let i=0;i<this.searchList.length;i++){
					for(var j = 0; j < this.searchList[i].keyword.length; j++) {
						var item = this.searchList[i].keyword[j];
						this.$set(item,\'deptName\',this.searchList[i].name); //向数组中加入元素
						this.$set(item,\'type\',this.searchList[i].type);
						if(item.checked){
							this.checkedList.push(item);
						}
					}
				}
				var that=this;
				uni.showLoading({
					title: "报表正在生成...",
					mask: true
				});
				uni.request({
					url: baseconfig.server+\'/affairs/createReport\',
					method: \'POST\',
					dataType: \'json\',
					contentType : "application/json",
					header:{
						\'content-type\':\'application/x-www-form-urlencoded\'
					},
					data: {
						checkedList:JSON.stringify(this.checkedList)
					},
					responseType: \'arraybuffer\', //此处是请求文件流,必须带入的属性
					success(res) {
						if (res.statusCode === 200) {
							console.log("200");
							const fs = wx.getFileSystemManager(); //获取全局唯一的文件管理器
							fs.writeFile({
								filePath: wx.env.USER_DATA_PATH + "/统计报表.xls", // wx.env.USER_DATA_PATH 指定临时文件存入的路径,后面字符串自定义
								data: res.data,
								encoding: "binary", //二进制流文件必须是 binary
								success(res) {
									console.log("success(res)",res);
									wx.openDocument({ // 打开文档
										filePath: wx.env.USER_DATA_PATH + "/统计报表.xls", //拿上面存入的文件路径
										showMenu: true, // 显示右上角菜单
										success: function(res) {
											console.log("successfun",res);
											setTimeout(() => {
												uni.hideLoading();//隐藏加载样式
											}, 500);
										},fail:function(res){
											console.log("failfun",res);
										}
									})
								},
								fail(res){
									console.log("fail",res);
								}
							})
						}else{
							console.log("不是200");
						}
						console.log("success",res);
					},
					fail(err) {
						console.log(\'导出失败:\', err);
					}
				})
			},  
后端代码
@RequestMapping(value = "/createReport")
    @ResponseBody
    public Object createReport(HttpServletRequest req, HttpServletResponse resp,@RequestParam(name="checkedList",required = false) String checkedList)throws IOException {
        JSONArray jsonArray= JSONArray.fromObject(checkedList);
        List<Map> list = JSONObject.parseArray(jsonArray.toString(), Map.class);
        String type="";
        for (Map map : list) {
            type=map.get("type").toString();
            String[] strArray = map.get("headlines").toString().split(":");
            if(strArray.length>1){
                String attributeName=strArray[0];
                String attributeValue=strArray[1];
                map.put("attributeName",attributeName);
                map.put("attributeValue",attributeValue);
            }else{
                String attributeName=strArray[0];
                //String attributeValue=strArray[1];
                map.put("attributeName",attributeName);
                map.put("attributeValue",null);
            }
        }
        List<ReportExportModel> modelist=affairsService.buildReportModelByList(list);
        ExportParams exportParams=new ExportParams(type+"统计表","统计数据");
        exportParams.setStyle(ReportStyle.class);
        Workbook workbook = ExcelExportUtil.exportExcel(exportParams, ReportExportModel.class, modelist);
        String filedisplay = type+"统计表.xls";
        ExportBuilder.buildheaderAndExport(req, resp, filedisplay,workbook);
        return success();
    }
public List<ReportExportModel> buildReportModelByList(List<Map> list){
        List<ReportExportModel> modellist=new ArrayList<>();
        for(Map map:list) {
            ReportExportModel model=new ReportExportModel();
            model.setDeptName(map.get("deptName")!=null?map.get("deptName").toString():null);
            model.setAttributeName(map.get("attributeName")!=null?map.get("attributeName").toString():null);
            model.setAttributeValue(map.get("attributeValue")!=null?map.get("attributeValue").toString():null);
            modellist.add(model);
        }
        return modellist;
    }
public static void buildheaderAndExport(HttpServletRequest req, HttpServletResponse resp,String filename,Workbook workbook) throws IOException {
		buildheader(req,resp,filename);
        OutputStream out = resp.getOutputStream();
        workbook.write(out);
        out.close();
	}
public static void buildheader(HttpServletRequest req, HttpServletResponse resp,String filename) throws UnsupportedEncodingException {
		resp.reset();
		req.setCharacterEncoding("UTF-8");
        resp.setCharacterEncoding("UTF-8");
        resp.setContentType("application/x-download");
        //filename = URLEncoder.encode(filename, "UTF-8");
        //filename=new String(filename.getBytes("utf-8"), "ISO8859-1");
        String headStr = "attachment; filename=\"" + new String(filename.getBytes("utf-8"), "ISO8859-1") + "\"";
        resp.addHeader("Content-Disposition", headStr);

	}

 

package com.kdgcsoft.zw.applets.entity;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.handler.inter.IExcelModel;

import java.io.Serializable;

/*
* @Description: 配置excel模板
*/
@SuppressWarnings("serial")
public class ReportExportModel implements Serializable,IExcelModel{
    @Excel(name="单位",needMerge=true,orderNum="0",width=20,mergeVertical=true)  //mergeVertical设置是否纵向合并列
    private String deptName;
	@Excel(name="名称",needMerge=true,orderNum="1",width=20)
	private String attributeName;
	@Excel(name="数值",needMerge=true,orderNum="2",width=20)
	private String attributeValue;
	private Long rownum;
    private String errorMsg;

    public String getDeptName() {
        return deptName;
    }

    public void setDeptName(String deptName) {
        this.deptName = deptName;
    }

    public String getAttributeName() {
        return attributeName;
    }

    public void setAttributeName(String attributeName) {
        this.attributeName = attributeName;
    }

    public String getAttributeValue() {
        return attributeValue;
    }

    public void setAttributeValue(String attributeValue) {
        this.attributeValue = attributeValue;
    }

    public Long getRownum() {
        return rownum;
    }

    public void setRownum(Long rownum) {
        this.rownum = rownum;
    }

    @Override
    public String getErrorMsg() {
        return errorMsg;
    }

    @Override
    public void setErrorMsg(String errorMsg) {
        this.errorMsg = errorMsg;
    }
}

  excel表格示例

 


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
微信小程序简单的数据表格及查询功能发布时间:2022-07-18
下一篇:
微信小程序预览 word、excel、ppt、pdf 等文件发布时间:2022-07-18
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap