json写入到excel表

最新推荐文章于 2024-05-08 10:42:40 发布

weixin_30517001

最新推荐文章于 2024-05-08 10:42:40 发布

阅读量1k

点赞数

文章标签： json

原文链接：http://www.cnblogs.com/leiting/p/8940398.html

版权

1. 拼接返回的json数据

// 拼接需要下载报表的HTML，并返回html;
reportHtml(reporttData) {
    let html = `<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel"
      xmlns="http://www.w3.org/TR/REC-html40">
<head><!--[if gte mso 9]>
  <meta http-equiv="Content-Type"" content="text/html;charset=utf-8" />
  <style> .xl24 {
    mso-style-parent: style0;
    mso-number-format: "" \\@ "";
    text-align: right;
    vnd . ms-excel .
    numberformat: @
  } </style>
  <xml>
    <x:ExcelWorkbook>
      <x:ExcelWorksheets>
        <x:ExcelWorksheet>
          <x:Name>报表</x:Name>
          <x:WorksheetOptions>
            <x:DisplayGridlines/>
          </x:WorksheetOptions>
        </x:ExcelWorksheet>
      </x:ExcelWorksheets>
    </x:ExcelWorkbook>
  </xml><![endif]--></head>
<body>`
    html += `<table><thead>
        <tr>
          <th>姓名</th>
          <th>性别</th>
          <th>备注</th>
        </tr>
    </thead><tbody>`;
    reporttData.forEach(item => {
      html += `<tr>
           <td>${item.name ? item.name : ''}</td>
        <td>${item.sex === '1' ? '男' : '女'}</td>
        <td>${item.IsVip === '1' ? '会员' : '非会员'}</td>
        <td>${item.msg? item.msg : ''}</td></tr>`;
    })
    html += `</tbody></table></body></html>`;
    return html;
  }

2. 点击下载时下载报表

let html = this.reportHtml(response.data)
        var blob = new Blob([html], {type: "application/vnd.ms-excel;charset=utf-8"});  
        var objectUrl = URL.createObjectURL(blob);  
        console.log(objectUrl)
        var a = document.createElement('a');
        document.body.appendChild(a);
        a.setAttribute('style', 'display:none');
        a.setAttribute('href', objectUrl);
        a.setAttribute('download', 'fileName');
        a.click();
        URL.revokeObjectURL(objectUrl);

转载于:https://www.cnblogs.com/leiting/p/8940398.html

weixin_30517001

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
json写入到excel表

1. 拼接返回的json数据// 拼接需要下载报表的HTML，并返回html;reportHtml(reporttData) { let html = `<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" ...
复制链接

扫一扫