Wiki
Clone wikiAspose for Apache POI / Freeze-Panes
Apache POI SS
// 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
Updated