1 使用详解
FreezePanes()
说明:冻结行和列
格式:public void FreezePanes(int row, int column, int freezedRows, int freezedColumns);
注:row参数值要和freezedRows参数值一致,column参数值要和freezedColumns参数值一致。
2 冻结首行
实现代码:
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
//冻结首行
sheet.FreezePanes(1, 0, 1, 0);
3 冻结首列
实现代码:
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
//冻结首列
sheet.FreezePanes(0, 1, 0, 1);
4 冻结首行首列
实现代码:
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
//冻结首行首列
sheet.FreezePanes(1, 1, 1, 1);