Wiki

Clone wiki

Aspose 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