PHPackages ellumilel/php-excel-writer - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [PDF & Document Generation](/categories/documents) 4. / 5. ellumilel/php-excel-writer ActiveLibrary[PDF & Document Generation](/categories/documents) ellumilel/php-excel-writer ========================== Big data Excel writer with small memory consuming v0.1.9(5y ago)50287.6k—7.9%12[2 issues](https://github.com/ellumilel/php-excel-writer/issues)3MITPHPPHP ^5.4|^7.0|^8.0CI failing Since Sep 2Pushed 5y ago7 watchersCompare [ Source](https://github.com/ellumilel/php-excel-writer)[ Packagist](https://packagist.org/packages/ellumilel/php-excel-writer)[ Docs](https://github.com/Ellumilel/php-excel-writer)[ RSS](/packages/ellumilel-php-excel-writer/feed)WikiDiscussions master Synced 1mo ago READMEChangelogDependencies (2)Versions (11)Used By (3) Big data Excel writer. Relatively low memory usage. --------------------------------------------------- [](#big-data-excel-writer-relatively-low-memory-usage) Excel spreadsheet in with (Office 2007+) xlsx format, with just basic features ### Build: [](#build) [![Latest Stable Version](https://camo.githubusercontent.com/e541b794618e82f6a099ddb31e662e2c837322c38dc4e59b719b82ea12e28dbb/68747470733a2f2f706f7365722e707567782e6f72672f656c6c756d696c656c2f7068702d657863656c2d7772697465722f762f737461626c65)](https://packagist.org/packages/ellumilel/php-excel-writer)[![Latest Unstable Version](https://camo.githubusercontent.com/65e5f2169a0ea25b805b51c2a013c7334de458629ef37cf14fcbc54daf38fd14/68747470733a2f2f706f7365722e707567782e6f72672f656c6c756d696c656c2f7068702d657863656c2d7772697465722f762f756e737461626c65)](https://packagist.org/packages/ellumilel/php-excel-writer)[![Build Status](https://camo.githubusercontent.com/fc737829deec6fdcfaad92802e24b1e6af8b5e222e9080b7afe370d3d56cc48d/68747470733a2f2f7472617669732d63692e6f72672f656c6c756d696c656c2f7068702d657863656c2d7772697465722e7376673f6272616e63683d6d6173746572)](http://travis-ci.org/ellumilel/php-excel-writer)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/8a2102ddec4d614e3ede1237b68f4450d4ce3ece42f61b9c9638e3a74bfb8633/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f656c6c756d696c656c2f7068702d657863656c2d7772697465722f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/ellumilel/php-excel-writer/?branch=master)[![License](https://camo.githubusercontent.com/06a58d048178469b0ec96f5878d7a21ce2283a0cb8442c582b93ef74e32490c1/68747470733a2f2f706f7365722e707567782e6f72672f656c6c756d696c656c2f7068702d657863656c2d7772697465722f6c6963656e7365)](https://packagist.org/packages/ellumilel/php-excel-writer)[![Total Downloads](https://camo.githubusercontent.com/7607cbffcee3edc1843e7464d00350cd0b87910ad9cca5a6f6f9ebe58cd4f651/68747470733a2f2f706f7365722e707567782e6f72672f656c6c756d696c656c2f7068702d657863656c2d7772697465722f646f776e6c6f616473)](https://packagist.org/packages/ellumilel/php-excel-writer) ### Use: [](#use) - `ZipArchive`, based on PHP's [Zip extension](http://fr.php.net/manual/en/book.zip.php) ### Supports [](#supports) - supports PHP 5.4+ - supports simple formulas - supports currency/date/numeric cell formatting - takes UTF-8 encoded input - multiple worksheets ### Dev [](#dev) - PHPUnit - Optional: PHP\_CodeSniffer for PSR-X-compatibility checks ### Installation [](#installation) The preferred way to install this extension is through [composer](http://getcomposer.org/download/). Either run ``` php composer.phar require --prefer-dist ellumilel/php-excel-writer ``` or add ``` "ellumilel/php-excel-writer": ">=0.1.3" ``` to the require section of your `composer.json` file. ### Formats [](#formats) - 'string' = 'GENERAL' - 'text' = '@' - 'integer' = '0' - 'float\_with\_sep' = '#,##0.00' - 'float' = '0.00' - 'date' = 'YYYY-MM-DD' - 'datetime' = 'YYYY-MM-DD HH:MM:SS' - 'dollar' = '\[$$-1009\]#,##0.00;\[RED\]-\[$$-1009\]#,##0.00' - 'money' = '\[$$-1009\]#,##0.00;\[RED\]-\[$$-1009\]#,##0.00' - 'euro' = '#,##0.00 \[$€-407\];\[RED\]-#,##0.00 \[$€-407\]' - 'rub' = '#,##0.00 \[$₽-419\];\[Red\]-#,##0.00 \[$₽-419\]' - 'NN' = 'DDD' - 'NNN' = 'DDDD' - 'NNNN' = 'DDDD", "' ### Examples [](#examples) #### Simple: [](#simple) ``` $header = [ 'test1' => 'YYYY-MM-DD HH:MM:SS', 'test2' => 'string', 'test3' => 'string', 'test4' => 'string', 'test5' => 'string', 'test6' => 'money', ]; $wExcel = new Ellumilel\ExcelWriter(); $wExcel->writeSheetHeader('Sheet1', $header); $wExcel->setAuthor('Your name here'); for ($i = 0; $i < 5000; $i++) { $wExcel->writeSheetRow('Sheet1', [ (new DateTime())->format('Y-m-d H:i:s'), rand(100, 10000), rand(100, 10000), rand(100, 10000), rand(100, 10000), rand(100, 10000), ]); } $wExcel->writeToFile("example.xlsx"); ``` #### 3.200.000 cell data example, low memory ~0.84 mb, fast write ~120 sec: [](#3200000-cell-data-example-low-memory-084-mb-fast-write-120-sec) ``` $header = [ 'head1' => 'YYYY-MM-DD HH:MM:SS', 'head2' => 'string', 'head3' => 'string', 'head4' => 'string', 'head5' => 'string', 'head6' => 'string', 'head7' => 'string', 'head8' => 'text', ]; $wExcel = new Ellumilel\ExcelWriter(); $wExcel->setAuthor('BigData Tester'); $wExcel->writeSheetHeader('Sheet1', $header); for ($ex = 0; $ex < 400000; $ex++) { $wExcel->writeSheetRow('Sheet1', [ (new DateTime())->format('Y-m-d H:i:s'), 'foo', 'baz', 'your text hear', rand(10000, 100000), rand(10000, 100000), rand(10000, 100000), rand(10000, 100000), ]); } $wExcel->writeToFile("output_big_data.xlsx"); ``` #### Advanced formula/format: [](#advanced-formulaformat) ``` $header = [ 'created' => 'date', 'id' => 'integer', 'count' => '#,##0', 'amount' => 'dollar', 'description' => 'string', 'money' => '[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00', 'sum' => 'dollar', 'rub' => 'rub', ]; $data = [ [ '2016-01-01', 123, 1002, '103.00', 'short string', '=D2*0.15', '=DOLLAR('.rand(10000, 100000).', 2)', rand(10000, 100000), ], [ '2016-04-12', 234, 2045, '2.00', 'loooooong string', '=D3*0.15', '=DOLLAR('.rand(10000, 100000).', 2)', rand(10000, 100000), ], [ '2016-02-05', 45, 56, '56.00', 'loooooong loooooong string', '=D4*0.15', '=DOLLAR('.rand(10000, 100000).', 2)', rand(10000, 100000), ], [ '2016-06-27', 534, 107, '678.00', 'loooooong loooooongloooooong string', '=D5*0.15', '=DOLLAR('.rand(10000, 100000).', 2)', rand(10000, 100000), ], ]; $wExcel = new Ellumilel\ExcelWriter(); $wExcel->writeSheet($data, 'Sheet1', $header); $wExcel->writeToFile('formulas.xlsx'); ``` ### Health Score 42 — FairBetter than 90% of packages Maintenance19 Infrequent updates — may be unmaintained Popularity48 Moderate usage in the ecosystem Community21 Small or concentrated contributor base Maturity64 Established project with proven stability Bus Factor1 Top contributor holds 60% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~191 days Recently: every ~380 days Total 9 Last Release 2013d ago PHP version history (2 changes)v0.1.1PHP ^5.4|^7.0 v0.1.9PHP ^5.4|^7.0|^8.0 ### Community Maintainers ![](https://www.gravatar.com/avatar/bf2b053d787776d28fa6c57dfa7f78235cc68a6ae18ad3db665847a4759c89ea?d=identicon)[Ellumilel](/maintainers/Ellumilel) --- Top Contributors [![ellumilel](https://avatars.githubusercontent.com/u/8477596?v=4)](https://github.com/ellumilel "ellumilel (3 commits)")[![samnela](https://avatars.githubusercontent.com/u/1852108?v=4)](https://github.com/samnela "samnela (1 commits)")[![yarri](https://avatars.githubusercontent.com/u/974278?v=4)](https://github.com/yarri "yarri (1 commits)") --- Tags excelfastlow-memoryphpspreadsheetxlsxlsxwriterexportexcelxlsxspreadsheetphp-excelbig-dataexcel-writerphp-excel-writerexcel-downloader ### Code Quality TestsPHPUnit Code StylePHP\_CodeSniffer ### Embed Badge ![Health badge](/badges/ellumilel-php-excel-writer/health.svg) ``` [![Health](https://phpackages.com/badges/ellumilel-php-excel-writer/health.svg)](https://phpackages.com/packages/ellumilel-php-excel-writer) ``` ### Alternatives [phpoffice/phpspreadsheet PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine 13.9k293.5M1.3k](/packages/phpoffice-phpspreadsheet)[openspout/openspout PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way 1.2k57.6M131](/packages/openspout-openspout)[avadim/fast-excel-writer Lightweight and very fast XLSX Excel Spreadsheet Writer in PHP 2951.2M7](/packages/avadim-fast-excel-writer)[nuovo/spreadsheet-reader Spreadsheet reader library for Excel, OpenOffice and structured text files 669863.2k8](/packages/nuovo-spreadsheet-reader)[kartik-v/yii2-export A library to export server/db data in various formats (e.g. excel, html, pdf, csv etc.) 1623.1M35](/packages/kartik-v-yii2-export)[akeneo-labs/spreadsheet-parser Akeneo Spreadsheet parser. Reads XLXS files from Microsoft Excel and Open Office 147598.3k6](/packages/akeneo-labs-spreadsheet-parser) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)