package asposefeatures.workingwithworksheets.detectmergedcells.java;
import java.util.ArrayList;
import com.aspose.cells.CellArea;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
public class AsposeDetectMergeCells
{
public static void main(String[] args) throws Exception
{
String dataPath = "src/asposefeatures/workingwithworksheets/detectmergedcells/data/";
// Instantiate a new Workbook
Workbook workbook = new Workbook(dataPath + "MergeInput.xls");
// Get a worksheet in the workbook
Worksheet worksheet = workbook.getWorksheets().get(0);
// Clear its contents
worksheet.getCells().clearContents(0, 0, worksheet.getCells().getMaxDataRow(),
worksheet.getCells().getMaxDataColumn());
// Create an arraylist object
// Get the merged cells list to put it into the arraylist object
ArrayList<CellArea> al = worksheet.getCells().getMergedCells();
// Define cellarea
CellArea ca;
// Define some variables
int frow, fcol, erow, ecol;
// Print Message
System.out.println("Merged Areas: \n" + al.toString());
// Loop through the arraylist and get each cellarea to unmerge it
for (int i = al.size() - 1; i > -1; i--)
{
ca = new CellArea();
ca = (CellArea) al.get(i);
frow = ca.StartRow;
fcol = ca.StartColumn;
erow = ca.EndRow;
ecol = ca.EndColumn;
System.out.println((i + 1) + ". [" + fcol + "," + frow + "] " + "[" + ecol + "," + erow
+ "]");
worksheet.getCells().unMerge(frow, fcol, erow, ecol);
}
// Save the excel file
workbook.save(dataPath + "AsposeMergeOutput.xls");
// Print Message
System.out.println("Detect Merge Cells successful.");
}
}