使用excel.js对各种行进行分组 [英] Grouping various rows using exceljs for angular

问题描述

我一直在使用exceljs创建excel文件并下载它们.我目前遇到了将它们分组的问题，例如:解决方案

在名为"Outlines"的excel行组中.在github上的ExcelJS文档中，我找到了 https://github.com/exceljs/exceljs#outline级别

组通过将值设置为属性"outlineLevel"来进行分组.用于行或列.

I have been using exceljs to create excel files and downloading them. I have currently run into the problem of grouping them something like this: Click here for grouping example

Is there any way of doing this using exceljs? I have tried doing something like

worksheet.addRows([['Hello'],['Hello']]);

but that just puts them one above another and does not group them.

解决方案

In excel groups of rows named "Outlines". In documentation of ExcelJS on github i found this https://github.com/exceljs/exceljs#outline-levels

Groups make by set value to the attribute "outlineLevel" for rows or cols.

这篇关于使用excel.js对各种行进行分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！