Skip to content

Instantly share code, notes, and snippets.

@Norcoen
Norcoen / PHPExcel_Basics.md
Created January 5, 2016 15:45 — forked from r-sal/PHPExcel_Basics.md
PHPExcel Notes and code snippets

Basics

Creating a new PHPExcel Object.

    $this->PHPExcel = new PHPExcel();

Working with sheets

Creating a new sheet:

@Norcoen
Norcoen / flatArray.php
Created November 27, 2015 12:28
php function that Recursively converts nested array into a flat one with preserved keys connected with connector.
<?php
/**
* Recursively converts nested array into a flat one with keys preserving.
* @param array $result Resulting array
* @param array $array Source array
* @param string $prefix Key's prefix
* @param string $connector Levels connector
*/
function flatArray(array &$result, array $array, $prefix = null, $connector = '.') {
foreach ($array as $key => $value) {