sheetjs xlsx，如何编写合并的单元格? [英] sheetjs xlsx, How to write merged cells?

问题描述

我需要使用 sheetjs 创建一个带有合并单元格的 xlsx.

数据:

<预><代码>[{"id": "尼克",项目": [{名称":球"},{姓名":电话"}]},{"id": "杰克",项目": [{名称":笔"},{名称":娃娃"}]}]

我的代码:

var ws = XLSX.utils.json_to_sheet(data);var wb = XLSX.utils.book_new();XLSX.utils.book_append_sheet(wb, ws, "");var wbout = XLSX.write(wb, {bookType:'xlsx', type:'array'});saveAs(new Blob([wbout],{type:"application/octet-stream"}), filename + ".xlsx");

我想得到的结果:

我如何得到这个结果?

...谢谢

解决方案

const merge = [{ s: { r: 1, c: 0 }, e: { r: 2, c: 0 } },{ s: { r: 3, c: 0 }, e: { r: 4, c: 0 }},];ws["!merges"] = 合并；

使用此代码合并 A2:​​A3 ({ s: { r: 1, c: 0 }, e: { r: 2, c: 0 } })和 A4:A5 ({ s: { r: 3, c: 0 }, e: { r: 4, c: 0 } })

这里 s = 开始，r = 行，c=col，e= 结束

I need to create a xlsx with merged cells using sheetjs.

data:

[
  {
    "id": "nick",
    "items": [
      {
        "name": "ball"
      },
      {
        "name": "phone"
      }
    ]
  },
  {
    "id": "jack",
    "items": [
      {
        "name": "pen"
      },
      {
        "name": "doll"
      }
    ]
  }
]

My code:

var ws = XLSX.utils.json_to_sheet(data);
var wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "");
var wbout = XLSX.write(wb, {bookType:'xlsx', type:'array'});
saveAs(new Blob([wbout],{type:"application/octet-stream"}), filename + ".xlsx");

The result I want to get:

How do I get this result?

... Thank you

解决方案

const merge = [
  { s: { r: 1, c: 0 }, e: { r: 2, c: 0 } },{ s: { r: 3, c: 0 }, e: { r: 4, c: 0 } },
];
ws["!merges"] = merge;

Use this code for merge A2:A3 ({ s: { r: 1, c: 0 }, e: { r: 2, c: 0 } }) and A4:A5 ({ s: { r: 3, c: 0 }, e: { r: 4, c: 0 } })

Here s = start, r = row, c=col, e= end

这篇关于sheetjs xlsx，如何编写合并的单元格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！