Download the PHP package maksimovic/php-xlsx-writer without Composer
On this page you can find all versions of the php package maksimovic/php-xlsx-writer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download maksimovic/php-xlsx-writer
More information about maksimovic/php-xlsx-writer
Files in maksimovic/php-xlsx-writer
Package php-xlsx-writer
Short Description PHP Library to write XLSX files
License MIT
Homepage https://github.com/maksimovic/PHP_XLSXWriter
Informations about the package php-xlsx-writer
This is a fork of mk-j/php_xlsxwriter compatible with PHP versions:
- 7.2
- 7.3
- 7.4
- 8.0
- 8.1
- 8.2
- 8.3
- 8.4
- 8.5
PHP_XLSXWriter
Installation: composer require maksimovic/php-xlsx-writer
This library is designed to be lightweight, and have minimal memory usage.
It is designed to output an Excel compatible spreadsheet in (Office 2007+) xlsx format, with just basic features supported:
- supports PHP
5.2.1+7.2+ and 8.0+ - takes UTF-8 encoded input
- multiple worksheets
- supports currency/date/numeric cell formatting, simple formulas
- supports basic cell styling
- supports writing huge 100K+ row spreadsheets
Never run out of memory with PHPExcel again.
Simple PHP CLI example:
Simple/Advanced Cell Formats:
50000 rows: (1.4s, 0MB memory usage)
| rows | time | memory |
|---|---|---|
| 50000 | 1.4s | 0MB |
| 100000 | 2.7s | 0MB |
| 150000 | 4.1s | 0MB |
| 200000 | 5.7s | 0MB |
| 250000 | 7.0s | 0MB |
Simple cell formats map to more advanced cell formats
| simple formats | format code |
|---|---|
| string | @ |
| integer | 0 |
| date | YYYY-MM-DD |
| datetime | YYYY-MM-DD HH:MM:SS |
| time | HH:MM:SS |
| price | #,##0.00 |
| dollar | [$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00 |
| euro | #,##0.00 [$€-407];[RED]-#,##0.00 [$€-407] |
Basic cell styles have been available since version 0.30
| style | allowed values |
|---|---|
| font | Arial, Times New Roman, Courier New, Comic Sans MS |
| font-size | 8,9,10,11,12 ... |
| font-style | bold, italic, underline, strikethrough or multiple ie: 'bold,italic' |
| border | left, right, top, bottom, or multiple ie: 'top,left' |
| border-style | thin, medium, thick, dashDot, dashDotDot, dashed, dotted, double, hair, mediumDashDot, mediumDashDotDot, mediumDashed, slantDashDot |
| border-color | #RRGGBB, ie: #ff99cc or #f9c |
| color | #RRGGBB, ie: #ff99cc or #f9c |
| fill | #RRGGBB, ie: #eeffee or #efe |
| halign | general, left, right, justify, center |
| valign | bottom, center, distributed |
All versions of php-xlsx-writer with dependencies
ext-zip Version *