// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java // The path to the documents directory. String dataDir = Utils.getDataDir(DetectMergedCells.class); // Instantiate a new Workbook Workbook wkBook = new Workbook(dataDir + "MergeTrial.xls"); // Get a worksheet in the workbook Worksheet wkSheet = wkBook.getWorksheets().get("Merge Trial"); // Clear its contents wkSheet.getCells().clearContents(0, 0, wkSheet.getCells().getMaxDataRow(), wkSheet.getCells().getMaxDataColumn()); // Get all merged cell aeras CellArea[] areas = wkSheet.getCells().getMergedAreas(); // Define some variables int frow, fcol, erow, ecol; // Loop through the arraylist and get each cellarea to unmerge it for (int i = areas.length - 1; i > -1; i--) { frow = areas[i].StartRow; fcol = areas[i].StartColumn; erow = areas[i].EndRow; ecol = areas[i].EndColumn; wkSheet.getCells().unMerge(frow, fcol, erow, ecol); } // Save the excel file wkBook.save(dataDir + "output_MergeTrial.xls");