Excellence is a simple and lightweight implementation to write Excel files. This library will only support xlsx (OfficeOpenXml format) files.
Library is currently under development
- PHP Version 5.3.0 or higher
- PHP extension php_zip enabled
You can just download the source via github and manage it by yourself.
git clone https://github.com/Scyks/Excellence
To add Excellence as a dependency to your project, just add a dependency on scyks/excellence to your composer.json file.
{
"require": {
"scyks/excellence": "dev-master"
}
}
Performance tests made on Mac OSX 10.9 (2.4 GHz Intel Core 2 Duo, 4 GB DDR3 Ram) PHP 5.4 executing in terminal window. There where no styles added or something else, this is just creating a simple lightweight Excel file.
Excel Table looks like this one:
| Rows | A | B | C | D | ... | T |
|---|---|---|---|---|---|---|
| 1 | test column value | 22 | 0.9 | =SUM(B1:C1) | ... | =SUM(Q1:R1) |
| 2 | test column value | 22 | 0.9 | =SUM(B2:C2) | ... | =SUM(Q2:R2) |
| ... | ... | ... | ... | ... | ... | ... |
| Excellence | PHPExcel | |||||||
|---|---|---|---|---|---|---|---|---|
| Lines/Columns | Memory | Time | Filesize | Memory | Time | Filesize | ||
| 1000 / 20 | 4,75 MB | ~ 0,9 sec | 85 KB | 21.5 MB | ~ 12 sec | 86 KB | ||
| 5000 / 20 | 21,00 MB | ~ 4,3 sec | 406 KB | 81.75 MB | ~ 55 sec | 402 KB | ||
| 10000 / 20 | 41,00 MB | ~ 9 sec | 806 KB | 153.5 MB | ~ 114 sec | 796 KB | ||
| 50000 / 20 | 204.00 MB | ~ 44 sec | 3,8 MB | 736 MB | ~ 763 sec | 4,1 MB | ||
| 1000 / 100 | 19.50 MB | ~ 5,0 sec | 393 KB | 77.75 MB | ~ 59 sec | 388 KB | ||
| 5000 / 100 | 95,50 MB | ~ 25 sec | 1,86 MB | 367.75 MB | ~ 339 sec | 1,89 MB | ||
| 10000 / 100 | 190,75 MB | ~ 51 sec | 3,7 MB | 651.0 MB | ~ 744 sec | 4,0 MB | ||
| 50000 / 100 | 957.75 MB | ~ 266 sec | 18.4 MB | > 2,7 GB | > 70 min | ? |