Download the PHP package ixc-soft/php_xlsxwriter without Composer
On this page you can find all versions of the php package ixc-soft/php_xlsxwriter. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package php_xlsxwriter
PHP_XLSXWriter by IXCSoft
Pacote adaptado para funcionamento no ERP IXCProvedor.
Instalação
composer require ixc-soft/php_xlsxwriter
PHP_XLSXWriter
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+
- 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 | GENERAL |
integer | 0 |
date | DD/MM/YYYY |
datetime | DD/MM/YYYY HH:MM:SS |
time | HH:MM:SS |
money | ( R$ * #,##0.00); (R$ * #,##0.00);( R$ * - ??) |
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 |