强大的excel写入类XLSXWriter，节省内存，带demo

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');

$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');

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