@fiveroom/excel-tools v0.0.2

export-excel

excel 处理基于exceljs

本工具只是提供了一种自动处理普通树表头的方法

下载

npm install --save @fiveroom/excel-tools

导入

import { ExportEx } from "@fiveroom/excel-tools";

使用

let head: xlsxHeadArr = createheader();
let e = new ExportEx();
let sheet = e.addSheet("sheet 1", head, bodyData());
sheet.getColumn(1).hidden = true;
sheet.getRow(4).hidden = true;
e.downLoad();

• 隐藏行

worksheet.getRow(4).hidden = true;

• 隐藏列

worksheet.getColumn(4).hidden = true;

添加顶部行

let head: xlsxHeadArr = createheader();
let e = new ExportEx();
let sheet = e.addSheet("sheet 1");
sheet.addRow(["顶部行"]);
let headInfo = e.addheads(sheet, head); // 添加头
e.addBodyData(bodyData(), sheet, headInfo.bottomHeads);

// 对第一行添加合并
sheet.mergeCells(1, 1, 1, headInfo.maxCol);

// 对第一行添加样式
sheet.getCell(1, 1).style = {
    alignment: ExportEx.defaultHeadStyle.alignment,
};
sheet.getCell(1, headInfo.maxCol).style.border =
    ExportEx.defaultHeadStyle.border;
sheet.getRow(1).height = 30;

e.downLoad();