Apache POI SS - Freeze Panes

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

Aspose.Cells

worksheet1.freezePanes(0,2,0,2); // Freezing Columns
worksheet2.freezePanes(2,0,2,0); // Freezing Rows     


Download Source Code

For More Examples, Please Visit Aspose Docs

Last edited Apr 26, 2014 at 6:16 AM by shoaibkhan, version 5