XLSX Module : create a subloop which merge cells instead of repeating them

[LudovicLaloux]

Environment

• Version of docxtemplater : 3.19.6
• Used docxtemplater-modules : "docxtemplater-xlsx-module"
• Runner : Browser

How to reproduce my problem :

My template is the following (rename template.xlsx) :
template.zip

With the following js file :

var fs = require('fs');
var Docxtemplater = require('docxtemplater');
var XlsxModule = require("./docxtemplater-xlsx-module");
var xlsxModule = new XlsxModule({});

//Load the docx file as a binary
var content = fs
    .readFileSync(__dirname + "/template.zip", "binary");

var zip = new PizZip(content);
var doc=new Docxtemplater()
doc.attachModule(xlsxModule)
doc.loadZip(zip)

//set the templateVariables
const data = {
	name: "John Doe",
	category: [
		{
            CategoryName: "Category 1",
            items: [
                {
                    name: "product 1",
                    quantity: 1,
                },
                {
                    name: "Product 2",
                    quantity: 3,
                },
            ],
        },
        {
            CategoryName: "Category 2",
            items: [
                {
                    name: "Product 3",
                    quantity: 7,
                },
                {
                    name: "Product 4",
                    quantity: 5,
                },
            ],
        },
        {
            CategoryName: "Category 3",
            items: [
                {
                    name: "Product 5",
                    quantity: 42,
                },
            ]
        }
    ]
};

//apply them (replace all occurences of {first_name} by Hipp, ...)
doc.render();

var buf = doc.getZip()
             .generate({type:"nodebuffer"});

fs.writeFileSync(__dirname+"/output.docx",buf);

I would expect it to return the following template :
generated.zip

When doing subloops, the row is repeted as many times as available entries. It would be nice to merge the repeted cells instead of repeting them.
We can use a "slice" filter to add subloops without repeating rows like this :

expressions.filters.slice = function(array, num) {
	return array.slice(num);
}

but this method would create unwanted lines if there is only one item on the subloop.

[edi9999]

Hello @ludolaloux13 , this was not possible previously.

I have just released a new version, v3.3.7 to fix this.

Here is a sample with the filter :

expressions.filters.slice = function (array, num) {
	return array.slice(num);
};

with following data :

data = {
    name: "John Doe",
    category: [
        {
            CategoryName: "Category 1",
            items: [
                {
                    name: "C1 / product 1",
                    quantity: 1,
                },
                {
                    name: "C1 / Product 2",
                    quantity: 3,
                },
                {
                    name: "C1 / Product 3",
                    quantity: 7,
                },
            ],
        },
        {
            CategoryName: "Category 2",
            items: [
                {
                    name: "C2 / Product 4",
                    quantity: 5,
                },
            ],
        },
        {
            CategoryName: "Category 3",
            items: [
                {
                    name: "C3 / Product 5",
                    quantity: 42,
                },
                {
                    name: "C3 / Product 6",
                    quantity: 42,
                },
                {
                    name: "C4 / Product 6",
                    quantity: 42,
                },
            ],
        },
    ],
};

Here is the template (you have to rename it to xlsx) :

subloop-inside-merge-cell.zip

It generates the following doc :

[LudovicLaloux]

Hello @edi9999,

I tried to implement this feature on a template with multiple columns having merged cells, and the file is corrupted + the generated rows are all messed up.

Here is your template updated with a new column which is identical to the first one (it displays the title with merged cells) :

subloop-inside-merge-cell.zip

Do you thnk there would be a solution to implement this feature with multiple columns merged ?

[edi9999]

Hello @ludolaloux13 , you're totally right, there's an interesting bug here.

[edi9999]

I'm looking into it

[edi9999]

Hello @ludolaloux13 ,

This has now been fixed in version 3.5.2 of the xlsx module.

I hope it will work for your more complex case as well.

[LudovicLaloux]

Hello Edgar,

It works perfectly, even better than I expected.

Thanks a lot for your quick answer and your quick fix 👍