Merge cell wrong

Aspose.Cells Product Family
1
Workbook wb = new Workbook("C:/tttt22 (5).xlsx");
Cells cells = wb.getWorksheets().get(0).getCells();
cells.merge(1, 0, 192, 1);
wb.save("C:/tttt22 (5)_2.xlsx");

MS Excel open tttt22 (5)_2.xlsx will show a warning
2

Hi,

Thanks for your posting and using Aspose.Cells.

We have looked into your issue and found that the cells you are merging are inside the Table (List Object). You cannot merge Table cells via Microsoft Excel, therefore you cannot do it with Aspose.Cells too.

I have attached the sample excel file and the screenshot showing this issue for your reference. As you can see inside the screenshot, “Merge & Center” command is disabled because selected cells are inside the Table.

As a workaround, you should first convert your Table into Range and then merge your cells. Please see the following sample code and its output excel file for your reference.

Java
Workbook wb = new Workbook(dirPath + “tttt22+(5).xlsx”);

Worksheet ws = wb.getWorksheets().get(0);
ws.getListObjects().get(0).convertToRange();

Cells cells = ws.getCells();
cells.merge(1, 0, 192, 1);
wb.save(dirPath + “output.xlsx”);