There was a problem. I create worksheet in library EXCELJS

function save_export(){


    var workbook = new ExcelJS.Workbook();
    var worksheet = workbook.addWorksheet('sheet', {
      pageSetup:{paperSize: 9, orientation:'portrait',fitToPage: true,fitToHeight :  99 , fitToWidth :  1, horizontalCentered: true}
    }); 

    var tfoot = [];

        $(element).each(function(index_tfoot, element_tfoot) {
          $($(element_tfoot).find("#tfoot tr")).each(function(index_tr, element_tr) {

                $(this.cells).each(function(index_td, element_td) {
                    tfoot.push($(element_td).text());   
                });

                var row_foot = worksheet.addRow(tfoot);
                row_foot.eachCell(function(cell,rowNumber) {

                    cell.font = { name: 'Verdana', size: 11};
                    cell.alignment = {horizontal: 'center' };
                    cell.border = {
                      top: { style: "thin" },
                      left: { style: "thin" },
                      bottom: { style: "thin" },
                      right: { style: "thin" }
                    };


                    <!-- if(cell._value.model.value === 'ИТОГО'){ -->
                        <!-- var c = 'A'; -->
                        <!-- var r = cell._row._number; -->
                        <!-- var sum = c+r; -->
                        <!-- worksheet.mergeCells(sum + ': B31'); -->
                    <!-- } // ПОЛУЧИЛ ИТОГО -->

                });

                tfoot = [];

                });
        });

    });




        workbook.xlsx.writeBuffer().then(function (data) {
            var blob = new Blob([data], {
                type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
            });

            saveAs(blob, "Исходная выборка.xlsx");
        });

};

when I merge cells, my merged rows over cells as in the screenshot "before". You see what number 238 disappear.

I need the cells to move.

[1]: .png - before [2]: .png - after

How we see in screenshots, cells merge and value ​​disappear ((

need to shift(

There was a problem. I create worksheet in library EXCELJS

function save_export(){


    var workbook = new ExcelJS.Workbook();
    var worksheet = workbook.addWorksheet('sheet', {
      pageSetup:{paperSize: 9, orientation:'portrait',fitToPage: true,fitToHeight :  99 , fitToWidth :  1, horizontalCentered: true}
    }); 

    var tfoot = [];

        $(element).each(function(index_tfoot, element_tfoot) {
          $($(element_tfoot).find("#tfoot tr")).each(function(index_tr, element_tr) {

                $(this.cells).each(function(index_td, element_td) {
                    tfoot.push($(element_td).text());   
                });

                var row_foot = worksheet.addRow(tfoot);
                row_foot.eachCell(function(cell,rowNumber) {

                    cell.font = { name: 'Verdana', size: 11};
                    cell.alignment = {horizontal: 'center' };
                    cell.border = {
                      top: { style: "thin" },
                      left: { style: "thin" },
                      bottom: { style: "thin" },
                      right: { style: "thin" }
                    };


                    <!-- if(cell._value.model.value === 'ИТОГО'){ -->
                        <!-- var c = 'A'; -->
                        <!-- var r = cell._row._number; -->
                        <!-- var sum = c+r; -->
                        <!-- worksheet.mergeCells(sum + ': B31'); -->
                    <!-- } // ПОЛУЧИЛ ИТОГО -->

                });

                tfoot = [];

                });
        });

    });




        workbook.xlsx.writeBuffer().then(function (data) {
            var blob = new Blob([data], {
                type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
            });

            saveAs(blob, "Исходная выборка.xlsx");
        });

};

when I merge cells, my merged rows over cells as in the screenshot "before". You see what number 238 disappear.

I need the cells to move.

[1]: https://i.sstatic/kyquZ.png - before [2]: https://i.sstatic/0DeRc.png - after

How we see in screenshots, cells merge and value ​​disappear ((

need to shift(

• javascript
• jquery
• exceljs

Share Improve this question Follow edited May 10, 2020 at 14:37 Паша Харченко asked May 10, 2020 at 14:26 Паша ХарченкоПаша Харченко 10111 gold badge22 silver badges88 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 2

I have faced the same problem.The data needs to be added after merging the cells. Please refer the documentation https://github./exceljs/exceljs#merged-cells