slam/php-excel

Old faster PHPExcel

Monday, February 5, 2018
by Slam
Repository
1 Watchers
7 Stars
3,877 Installations

PHP
0 Dependents
0 Suggesters
1 Forks
0 Open issues
20 Versions
4 % Grown

The README.md

ABANDONED, use `slam/openspout-helper`

Slam PHPExcel old&faster

, _(*1)

This package is NOT intended to be complete and flexible, but to be fast., _(*2)

PHPOffice/PHPExcel and PHPOffice/PhpSpreadsheet are great libraries, but abstract everything in memory before writing to the disk. This is extremely inefficent and slow if you need to write a giant XLS with thousands rows and hundreds columns., _(*3)

Based on Spreadsheet_Excel_Writer v0.9.3, which can be found active on Github. This is not a fork: I copied it and adapted to work with PHP 7.1 and applied some coding standard fixes and some Scrutinizer patches., _(*4)

Installation

composer require slam/php-excel, _(*5)

Usage

From version 4 the code is split in two parts:, _(*6)

Slam\Excel\Pear namespace, the original Pear code
Slam\Excel\Helper namespace, an helper to apply a trivial style on a Table structure:

use Slam\Excel\Helper as ExcelHelper;

require __DIR__ . '/vendor/autoload.php';

// Being an Iterator, the data can be any dinamically generated content
// for example a PDOStatement set on unbuffered query
$users = new ArrayIterator([
    [
        'column_1' => 'John',
        'column_2' => '123.45',
        'column_3' => '2017-05-08',
    ],
    [
        'column_1' => 'Mary',
        'column_2' => '4321.09',
        'column_3' => '2018-05-08',
    ],
]);

$columnCollection = new ExcelHelper\ColumnCollection([
    new ExcelHelper\Column('column_1',  'User',     10,     new ExcelHelper\CellStyle\Text()),
    new ExcelHelper\Column('column_2',  'Amount',   15,     new ExcelHelper\CellStyle\Amount()),
    new ExcelHelper\Column('column_3',  'Date',     15,     new ExcelHelper\CellStyle\Date()),
]);

$filename = sprintf('%s/my_excel_%s.xls', __DIR__, uniqid());

$phpExcel = new ExcelHelper\TableWorkbook($filename);
$worksheet = $phpExcel->addWorksheet('My Users');

$table = new ExcelHelper\Table($worksheet, 0, 0, 'My Heading', $users);
$table->setColumnCollection($columnCollection);

$phpExcel->writeTable($table);
$phpExcel->close();

Result:, _(*7)

Example , _(*8)

The Versions

05/02 2018

dev-master

9999999-dev

Old faster PHPExcel

library php-excel

Old faster PHPExcel

slam/php-excel

The README.md

ABANDONED, use slam/openspout-helper

Slam PHPExcel old&faster

Installation

Usage

The Versions

dev-master

The Requires

The Development Requires

by Filippo Tessarotto

v4.4.0

The Requires

The Development Requires

by Filippo Tessarotto

v4.3.1

The Requires

The Development Requires

by Filippo Tessarotto

v4.3.0

The Requires

The Development Requires

by Filippo Tessarotto

v4.2.1

The Requires

The Development Requires

by Filippo Tessarotto

v4.2.0

The Requires

The Development Requires

by Filippo Tessarotto

v4.1.2

The Requires

The Development Requires

by Filippo Tessarotto

v4.1.1

The Requires

The Development Requires

by Filippo Tessarotto

v4.1.0

The Requires

The Development Requires

by Filippo Tessarotto

v4.0.0

The Requires

The Development Requires

by Filippo Tessarotto

v3.0.0

The Requires

The Development Requires

by Filippo Tessarotto

v2.1.0

The Development Requires

by Filippo Tessarotto

v2.0.1

The Development Requires

by Filippo Tessarotto

v2.0.0

The Development Requires

by Filippo Tessarotto

v1.2.1

The Development Requires

by Filippo Tessarotto

v1.2.0

The Development Requires

by Filippo Tessarotto

v1.1.2

The Development Requires

by Filippo Tessarotto

v1.1.1

by Filippo Tessarotto

v1.1.0

by Filippo Tessarotto

v1.0.0

by Filippo Tessarotto

ABANDONED, use `slam/openspout-helper`