PHPExcel Convenience Functions

phpexcel_convenience.php

<?php // use as-is with PHPExcel, or build a utility class around them

// $addColumn($sheet, 'A', 1, ['value_in_A1', 'value_in_A2']);
$addColumn = function(\PHPExcel_Worksheet $worksheet, $column, $row, $values) {
    for ($i = 0, $count = count($values); $i < $count; $i++, $row++)
        $worksheet->getCell($column . $row)->setValue($values[$i]);
};

// $addRow($sheet, 'A', 1, ['value_in_A1', 'value_in_B1']);
$addRow = function(\PHPExcel_Worksheet $worksheet, $column, $row, $values) {
    for ($i = 0, $count = count($values); $i < $count; $i++, $column++)
        $worksheet->getCell($column . $row)->setValue($values[$i]);
};

// $addMatrix($sheet, 'A', 1, [['value_in_A1', 'value_in_B1'], ['value_in_A2', 'value_in_B2']]);
$addMatrix = function(\PHPExcel_Worksheet $worksheet, $column, $row, $values) use ($addRow) {
    for ($i = 0, $count = count($values); $i < $count; $i++, $row++)
        $addRow($worksheet, $column, $row, $values[$i]);
};

// $setWidths($sheet, [10, 15, 20, 15], 'B');
$setWidths = function(\PHPExcel_Worksheet $worksheet, $values, $left_column = 'A') {
    for ($i = 0, $count = count($values); $i < $count; $i++, $left_column++)
        $worksheet->getColumnDimension($left_column)->setWidth($values[$i]);
}

Blog post on inspiration here: http://empoweringaccess.tumblr.com/post/103189682800/phpexcel-functional-programming