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);