本文将介绍如何使用Spire.XLS for Java在Excel文档中合并和取消合并单元格。

合并单元格

import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class MergeCells {
    public static void main(String[] args){
        //创建Workbook实例
        Workbook workbook = new Workbook();
        //加载Excel文档
        workbook.loadFromFile("Test1.xlsx");

        //获取第一个工作表
        Worksheet sheet = workbook.getWorksheets().get(0);
        //合并单元格范围A1到C1
        sheet.getRange().get("A1:C1").merge();
        
        //保存结果文档
        workbook.saveToFile("MergeCells.xlsx", FileFormat.Version2013);
    }
}

取消合并单元格

import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;

public class UnmergeCells {
    public static void main(String[] args){
        //创建Workbook实例
        Workbook workbook = new Workbook();
        //加载Excel文档
        workbook.loadFromFile("MergeCells.xlsx");

        //获取第一个工作表
        Worksheet sheet = workbook.getWorksheets().get(0);
        //取消合并单元格范围A1到C1
        sheet.getRange().get("A1:C1").unMerge();

        //保存结果文档
        workbook.saveToFile("UnMergeCells.xlsx", FileFormat.Version2013);
    }
}