vue将数据导出excel,多sheet页

最新推荐文章于 2024-02-04 18:03:18 发布

H丶Jack

最新推荐文章于 2024-02-04 18:03:18 发布

阅读量703

点赞数

分类专栏：项目文章标签： vue.js

本文链接：https://blog.youkuaiyun.com/J_S_King/article/details/113973617

版权

项目专栏收录该内容

16 篇文章

订阅专栏

本文介绍如何在Vue.js项目中实现数据导出为Excel文件，并且支持多个sheet页的功能。通过使用特定的库，你可以方便地将复杂的数据结构转换成易于管理的Excel表格，提高用户体验。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

	setSheetStyle(sheet,cloums){
        var s = sheet['!ref'];
        sheet.s = {
          font: {
            name: '宋体',
            sz: 18,
            color: { rgb: "#FFFF0000" },
            bold: false,
            italic: false,
            underline: false
          },
          alignment: {
            horizontal: "left",
            vertical: "left"
          }
        };
        var rows = s.substr(s.length - 1, 1);
        for (var j = 0; j < cloums.length; j++) {
          for (var i = 1; i <= rows; i++) {
            if (i == 1) {
              sheet[cloums[j] + i].s = { //样式  
                font: {
                  bold: false,
                  italic: false,
                  underline: false
                },
                alignment: {
                  horizontal: "left",
                  vertical: "left",
                  wrap_text: false
                }
              };
            }
            else {
              sheet[cloums[j] + i].s = { //样式  
                alignment: {
                  horizontal: "left",
                  vertical: "left",
                  wrap_text: false
                }
              };
            }
          }
        }
        sheet["!cols"] = [{ wpx: 150 }, { wpx: 90 }, { wpx: 150 }, { wpx: 150 }, { wpx: 180 }]; //单元格列宽 
      },

download() {
	var that = this;
	//模板类型sheet页
    var type_arry = [['类型ID', '类型']];
    //that.typeList 数据集合
    that.typeList.map(a=>{
      var typeArry = []
      typeArry.push(a.id)
      typeArry.push(a.name)
      return typeArry
    }).forEach(a=>{
      type_arry.push(a)
    })
	var sheet = XLSX.utils.aoa_to_sheet(type_arry);//类型sheet
	XLSX.utils.book_append_sheet(workbook, sheet, "类型");
	var cloums = ['A', 'B']
	that.setSheetStyle(sheet,cloums)
	//多sheet按照以上在写一组
	try {
      var wbOut = XLSX.write(workbook, { bookType: "xlsx", bookSST: true, type: "array" });
      FileSaver.saveAs(
        new Blob([wbOut], { type: "application/octet-stream" }),
        "类型模板.xlsx"
      );
    } catch (e) {
      if (typeof console !== "undefined") console.log(e, wbOut);
    }
}