A wrapper around the phpexcel package, that gives it array access and some extra features

dev-master 2017-05-28 16:10 UTC

This package is auto-updated.

Last update: 2021-12-29 02:41:03 UTC


SimpleExcel is a wrapper around the PHPOffice/PHPExcel package that gives it a few extra features. Some of theses features include:

Matrix Array Access

$workbook = new PHPExcel();
$worksheet = $workbook->getActiveSheet();

$worksheet->setCellValue('A1', 'A test value');
$workbook = new Mtrajano\SimpleExcel\Workbook();
$worksheet = $workbook->getActiveSheet();

$worksheet[1]['A'] = 'A test value';

Numeric Column Access

$worksheet->setCellValue('B1', 'Another test value');
$worksheet[1][1] = 'Another test value';

Seamless export

$writer = new PHPExcel_Writer_Excel2007($workbook);

$writer = new PHPExcel_Writer_Excel5($workbook);
$workbook->save("simple.xlsx", Workbook::WRITE_Excel2007);
$workbook->save("simple.xls", Workbook::WRITE_Excel5);