public function PHPExcel_Worksheet::freezePane in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php \PHPExcel_Worksheet::freezePane()

Freeze Pane

Parameters

string $pCell Cell (i.e. A2): Examples: A2 will freeze the rows above cell A2 (i.e row 1) B1 will freeze the columns to the left of cell B1 (i.e column A) B2 will freeze the rows above and to the left of cell A2 (i.e row 1 and column A)

Return value

PHPExcel_Worksheet

Throws

PHPExcel_Exception

2 calls to PHPExcel_Worksheet::freezePane()

PHPExcel_Worksheet::freezePaneByColumnAndRow in vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php

Freeze Pane by using numeric cell coordinates

PHPExcel_Worksheet::unfreezePane in vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php

Unfreeze Pane

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php, line 1969

Class

PHPExcel_Worksheet

PHPExcel_Worksheet

Code

public function freezePane($pCell = '') {

  // Uppercase coordinate
  $pCell = strtoupper($pCell);
  if (strpos($pCell, ':') === false && strpos($pCell, ',') === false) {
    $this->_freezePane = $pCell;
  }
  else {
    throw new PHPExcel_Exception('Freeze pane can not be set on a range of cells.');
  }
  return $this;
}