NPOI 1.2.3教程 -5 分拆凍結 SplitAndFreeze

using System;using System.Text;using System.IO;using NPOI.HSSF.UserModel;using NPOI.HPSF;using NPOI.POIFS.FileSystem;using NPOI.SS.UserModel;namespace SplitAndFreezePanes{ class Program { static void Main(string[] args) { InitializeWorkbook(); Sheet sheet1 = hssfworkbook.CreateSheet("new sheet"); Sheet sheet2 = hssfworkbook.CreateSheet("second sheet"); Sheet sheet3 = hssfworkbook.CreateSheet("third sheet"); Sheet sheet4 = hssfworkbook.CreateSheet("fourth sheet"); // Freeze just one row sheet1.CreateFreezePane(0, 1, 0, 1); // Freeze just one column sheet2.CreateFreezePane(1, 0, 1, 0); // Freeze the columns and rows (forget about scrolling position of the lower right quadrant). sheet3.CreateFreezePane(2, 2); // Create a split with the lower left side being the active quadrant sheet4.CreateSplitPane(2000, 2000, 0, 0, PanePosition.LOWER_LEFT); WriteToFile(); } static HSSFWorkbook hssfworkbook; static void WriteToFile() { //Write the stream data of workbook to the root directory FileStream file = new FileStream(@"test.xls", FileMode.Create); hssfworkbook.Write(file); file.Close(); } static void InitializeWorkbook() { hssfworkbook = new HSSFWorkbook(); //Create a entry of DocumentSummaryInformation DocumentSummaryInformation dsi = PropertySetFactory.CreateDocumentSummaryInformation(); dsi.Company = "NPOI Team"; hssfworkbook.DocumentSummaryInformation = dsi; //Create a entry of SummaryInformation SummaryInformation si = PropertySetFactory.CreateSummaryInformation(); si.Subject = "NPOI SDK Example"; hssfworkbook.SummaryInformation = si; } }}