I can fix cells with PHPExcel?

Topics: Developer Forum, Project Management Forum, User Forum
May 31, 2013 at 10:13 PM
hello.

I can fix cells with PHPExcel?

another way to say..

immobilized panels on the worksheet?

how could I?

Thank you.
Coordinator
May 31, 2013 at 10:27 PM
Edited May 31, 2013 at 10:29 PM
$objPHPExcel->getActiveSheet()->freezePane('A2');
will freeze row #1
$objPHPExcel->getActiveSheet()->freezePane('C1');
will freeze columns A and B
$objPHPExcel->getActiveSheet()->freezePane('B3');
will freeze column A and rows 1 and 2
May 31, 2013 at 10:59 PM
you saved my life MarkBaker, thank you very much for your help.