PHPExcel freeze row and columns

Question

Using PHPExcel, I'm attempting to freeze the top row and the first three columns in a worksheet.

I have no trouble freezing the row:

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

Or I can freeze the column without any problem:

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

However, when I try to use both, the second overwrites the first.

Is it possible to utilize both on one sheet?

Answer 1

You must be attempting to Freeze both rows and columns.

Naturally, any prior parameters you may have supplied freeze pane will be overwritten.

I observe that you are attempting to freeze the top row and the leftmost three columns in your current situation.

Try this:

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

This will freeze Row 1 and Columns A, B & C

This should get your work done!