1.冻结首行和首列
代码:
import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
public class FreezeTopRows {
public static void main(String[] args) {
//创建Workbook对象
Workbook workbook = new Workbook();
//加载一个示例文档
workbook.loadFromFile("C:\\Users\\Test1\\Desktop\\Sample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.getWorksheets().get(0);
//冻结第一行
sheet.freezePanes(2,1);
//保存文档
workbook.saveToFile("output/FreezeFirstRow.xlsx", ExcelVersion.Version2016);
}
}
图例:
Part 2 冻结首列
import com.spire.xls.ExcelVersion;
import com.spire.xls.Workbook;
import com.spire.xls.Worksheet;
public class FreezeFirstColumn {
public static void main(String[] args) {
//创建Workbook对象
Workbook workbook = new Workbook();
//加载一个示例文档
workbook.loadFromFile("C:\\Users\\Test1\\Desktop\\Sample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.getWorksheets().get(0);
//冻结首列
sheet.freezePanes(1,2);
//保存文档
workbook.saveToFile("output/FreezeFirstColumn.xlsx", ExcelVersion.Version2016);
}
图例: