bablukpik/PHPExcel_Basics.md

Basics

Creating a new PHPExcel Object.

$this->PHPExcel = new PHPExcel();

Sheets

Creating a new sheet

$this->activeSheet = $this->PHPExcel->createSheet();

Setting the sheet title:

$this->activeSheet
    ->setTitle($title);

Getting/setting the active worksheet.

$this->activeSheet = $this->PHPExcel->getActiveSheet();

$sheetIndex = 2;
$this->PHPExcel->setActiveSheetIndex($sheetIndex)

Row/Column Functions

Setting the width of a specific column.

$this->activeSheet
    ->getColumnDimension($colString)
    ->setWidth($width);

Setting the default column width/row height for a sheet.

$this->activeSheet
    ->getDefaultColumnDimension()
    ->setWidth($width);
    
$this->activeSheet
    ->getDefaultRowDimension()
    ->setRowHeight($height);

Styles

// Setting default styles for the active sheet $this->activeSheet ->getDefaultStyle()->applyFromArray($this->defaultStyle);