本文将介绍如何使用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);
}
}