PHPExcel: Freeze first Line and Column

Yes, PHPExcel is providing the function freezePane() with which you can selectively freeze lines, columns or both. khaki are some examples:

Freezing Lines

Freeze first line:

$objPHPExcel->getActiveSheet()->freezePane('A2');

Freeze second line:

$objPHPExcel->getActiveSheet()->freezePane('A3');

Freezing Columns

Freeze first column:

$objPHPExcel->getActiveSheet()->freezePane('B1');

Freeze second column:

$objPHPExcel->getActiveSheet()->freezePane('C1');

Freezing Columns and Lines

Freeze first column and first line:

$objPHPExcel->getActiveSheet()->freezePane('B2');

Freeze fourth column and first line:

$objPHPExcel->getActiveSheet()->freezePane('D2');

As you can see, we are passing the cell before that it should be freezed. In order to only freeze lines, you have to keep the column at "A" and in order to freeze columns, accordingly, you have to keep the line at "1". When combining this, you get the corresponding cell beyond "A" and "1".
2015-03-23 at 13:42