mk-j / php_xlsxwriter
PHP Library to write XLSX files
Installs: 5 439 287
Dependents: 28
Suggesters: 1
Security: 0
Stars: 1 843
Watchers: 95
Forks: 664
Open Issues: 45
Requires
- php: >=5.2.1
- ext-zip: *
Requires (Dev)
- phpunit/phpunit: 4.3.*
This package is not auto-updated.
Last update: 2024-10-04 12:42:06 UTC
README
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:
$data = array( array('year','month','amount'), array('2003','1','220'), array('2003','2','153.5'), ); $writer = new XLSXWriter(); $writer->writeSheet($data); $writer->writeToFile('output.xlsx');
Simple/Advanced Cell Formats:
$header = array( 'created'=>'date', 'product_id'=>'integer', 'quantity'=>'#,##0', 'amount'=>'price', 'description'=>'string', 'tax'=>'[$$-1009]#,##0.00;[RED]-[$$-1009]#,##0.00', ); $data = array( array('2015-01-01',873,1,'44.00','misc','=D2*0.05'), array('2015-01-12',324,2,'88.00','none','=D3*0.05'), ); $writer = new XLSXWriter(); $writer->writeSheetHeader('Sheet1', $header ); foreach($data as $row) $writer->writeSheetRow('Sheet1', $row ); $writer->writeToFile('example.xlsx');
50000 rows: (1.4s, 0MB memory usage)
include_once("xlsxwriter.class.php"); $writer = new XLSXWriter(); $writer->writeSheetHeader('Sheet1', array('c1'=>'integer','c2'=>'integer','c3'=>'integer','c4'=>'integer') ); for($i=0; $i<50000; $i++) { $writer->writeSheetRow('Sheet1', array($i, $i+1, $i+2, $i+3) ); } $writer->writeToFile('huge.xlsx'); echo '#'.floor((memory_get_peak_usage())/1024/1024)."MB"."\n";
Simple cell formats map to more advanced cell formats
Basic cell styles have been available since version 0.30