PHPExcel Freezepane not working

Question

for ($char = 'A'; $char <= 'Z'; $char++) {
  $objPHPExcel->getActiveSheet()->setCellValue($char.'5','40');
}
for ($i=1;$i<=100;$i++){
    $objPHPExcel->getActiveSheet()->setCellValue('A'.$i,generateRandomString());
}
$objPHPExcel->getActiveSheet()->freezePane('B');
// Write the PHPExcel object to browser as HTML
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->save('php://output');

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

Freeze not happened for the " A " (First column) column.

Attached screen shot FYI. showing first column(A Col) details here Freeze not happened for the " A " (First column) column. When i scroll COL A not freeze, col A also hidding.

What exactly is not working. At all I think you should select the row too. `freezePane('A1')` — Royal Bg, Jun 14 '13 at 10:01

score 18 · Accepted Answer · answered Jun 14 '13 at 11:30

18

the freezePane() coordinate should be a cell reference for the top-left cell of the non-frozen part of the worksheet, so

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

tells Excel to freeze rows above row 2, and to the left of column "B"... i.e. row 1 and column "A" will be frozen.

answered Jun 14 '13 at 11:30

Mark Baker

209,507
32
346
385

1

This freezpane functionality will work only for xls output, but here trying for HTML Writer , i believe it is not possible for HTML Writer. – Bharanikumar Jun 15 '13 at 14:27
1

No, it's only supported by the Excel5 and Excel2007 Writers – Mark Baker Jun 15 '13 at 14:59

score 2 · Answer 2 · edited Jun 18 '15 at 08:14

2

Try this:

$ColumnCount=0;
$RowIndex=8;
$objPHPExcel->getActiveSheet()->freezePaneByColumnAndRow($ColumnCount, $RowIndex);

edited Jun 18 '15 at 08:14

Jørgen R

10,568
7
42
59

answered Jun 18 '15 at 08:08

tamil arasan

21
1

Could you also add an explanation? – Robert Jun 18 '15 at 08:27

PHPExcel Freezepane not working

2 Answers2