冻结窗格的使用
Contents
[
Hide
]
Aspose.Cells - 冻结窗格的使用
C#
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];
worksheet.FreezePanes(2, 2, 2, 0);
workbook.Save("output-FreezeFile-Aspose.Cells.xls");
要了解更多详情,请访问FreezePanes方法。
NPOI - HSSF XSSF - 冻结窗格的使用
C#
HSSFWorkbook hssfworkbook = new HSSFWorkbook();
ISheet sheet1 = hssfworkbook.CreateSheet("new sheet");
ISheet sheet2 = hssfworkbook.CreateSheet("second sheet");
ISheet sheet3 = hssfworkbook.CreateSheet("third sheet");
// Freeze just one row
sheet1.CreateFreezePane(0, 2, 0, 2);
// Freeze just one column
sheet2.CreateFreezePane(2, 0, 2, 0);
// Freeze the columns and rows (forget about scrolling position of the lower right quadrant).
sheet3.CreateFreezePane(2, 2);
FileStream file = new FileStream(@"output-FreezeFile-NPOI.xls", FileMode.Create);
hssfworkbook.Write(file);
file.Close();
下载运行代码
从以下任何社交编码网站下载工作表冻结窗格的使用
有关更多详细信息,请访问使用工作表。