本文介绍如何使用Spire.XLS for Java在Excel文档中冻结第一行、冻结第一列、同时冻结多行多列,以及如何解除冻结。
冻结第一行
//创建Workbook对象
Workbook workbook = new Workbook();
//加载一个示例文档
workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\sample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.getWorksheets().get(0);
//冻结第一行
sheet.freezePanes(2,1);
//保存文档
workbook.saveToFile("FreezeFirstRow.xlsx", ExcelVersion.Version2016);
冻结首列
//创建Workbook对象
Workbook workbook = new Workbook();
//加载一个示例文档
workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\sample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.getWorksheets().get(0);
//冻结首列
sheet.freezePanes(1,2);
//保存文档
workbook.saveToFile("FreezeFirstColumn.xlsx", ExcelVersion.Version2016);
同时冻结多行多列
//创建Workbook对象
Workbook workbook = new Workbook();
//加载一个示例文档
workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\sample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.getWorksheets().get(0);
//冻结前两行两列
sheet.freezePanes(3,3);
//保存文档
workbook.saveToFile("FreezeFewRowsAndColumns.xlsx", ExcelVersion.Version2016);
解除冻结
//创建Workbook对象
Workbook workbook = new Workbook();
//加载一个示例文档
workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\Freeze.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.getWorksheets().get(0);
//取消冻结窗口
sheet.removePanes();
//保存文档
workbook.saveToFile("UnfreezePanes.xlsx", ExcelVersion.Version2016);