Creating a new PHPExcel Object.
$this->PHPExcel = new PHPExcel();
- Creating a new sheet:
- `$this->activeSheet = $this->PHPExcel->createSheet();`
- Getting the active Sheet:
- ```$this->activeSheet = $this->PHPExcel->getActiveSheet();```
- Creating a new sheet:
$this->activeSheet = $this->PHPExcel->createSheet(); - Getting the active Sheet:
$this->activeSheet = $this->PHPExcel->getActiveSheet();
Renaming a worksheet:
$this->activeSheet->setTitle($title);
Setting the active sheet:
$sheetIndex = 2;
$this->PHPExcel->setActiveSheetIndex($sheetIndex)
Setting column width
Setting width for a single column:
$this->activeSheet
->getColumnDimension($colString)
->setWidth($width);
Setting the default width for all columns on a sheet:
$this->activeSheet
->getDefaultColumnDimension()
->setWidth($width);
Setting row height
Setting the default row height for an entire sheet:
$this->activeSheet
->getDefaultRowDimension()
->setRowHeight($height);
Text can be added to a cell using setCellValue($colRow, $data)
$colRow - The column and row to write to (i.e. 'A2')
$data - The data to write
$this->activeSheet->setCellValue($colRow, $data);
$this->activeSheet->setCellValueByColumnAndRow($column, $row, $data);
$this->activeSheet->setCellValueExplicit($coord, $value, $dataType);
$this->activeSheet->setCellValueExplicitByColumnAndRow($col, $row, $value, $dataType);
A 2-dimensional array can be written to the current sheet usng fromArray($twoDimArray)
$twoDimArray- the 2D array to be written$useWhenNull- what to use if there is a null value$topLeftCorner- where the top left corner should be.
$this->activeSheet->fromArray($sheet);
$this->activeSheet->fromArray($sheet, "", $colRow);
Or the array can be written manually by looping through the array and calling setCellValue
foreach($rows as $row => $columns) {
foreach($columns as $column => $data) {
$this->activeSheet->setCellValue($column.$row, $data);
}
}
Setting default styles for the active sheet
$this->activeSheet
->getDefaultStyle()
->applyFromArray($this->defaultStyle);
nice