excelExport - How to delete a cell

[Kent]

In my excelExport JavaScript function for my Kendo Grid definition I am requesting the merge of two cells using:

                    sheet.mergedCells = [];
                    sheet.mergedCells.push("A2:A3");

On the created spreadsheet I do get a merged cell at A2 spanning two rows, but the cell that was at A3 (and all of the cells to the right of it) get shifted right instead of being absorbed by the merge.

So I now want to delete the cell at A3.  But I can't find any way to select/delete cells using this api.

Any thoughts on how to delete that cell?

[Neli]

Hi Kent,

You could try to modify the cell array in the next row. For example, you could remove a cell in the row as demonstrated below:

excelExport: function(e) {
            let sheet = e.workbook.sheets[0];
            sheet.mergedCells = [];
            sheet.mergedCells.push("A2:A3");
            sheet.rows[2].cells.shift()
},

Here is a Dojo example where this is demonstrated - https://dojo.telerik.com/GbsPMjsl.

I hope this helps.

Regards,
Neli
Progress Telerik

[Kent]

Thanks for that suggestion.  At some point I realized I could just shift the cells over - but I did that manually via a loop.  The loop approach works great, but utilizing the cells.shift() method is obviously the better way to go.