Excel Writer (XML) for PHP
Description
Set of classes for PHP that allow Excel XML files to be generated dynamically.
Nearly a full implementation of the MS XML architecture.
Requires PHP 5+
Does not require any XML libraries
Categories
License
Update Notifications
User Ratings
User Reviews
-
Great tool
-
sorry i was op the wrong repos
-
Very easy to use excelwriterxml
-
Excellent Library. only 1 problem with the "MergeAcross" tag for OpenOffice.. the bug they never resolved, apparently... :S So what I did was rewriting the "ExcelWriterXML_Sheet.php" at lines 320. Replaced it with this block of code: else { /* the block below replaces the original line -- this prevents OpenOffice from acting up on MergeAcross=0*/ if ($this->mergeCells[$row][$column]['width']>0 && $this->mergeCells[$row][$column]['height']>0) $mergeCell = 'ss:MergeAcross="'.$this->mergeCells[$row][$column]['width'].'" ss:MergeDown="'.$this->mergeCells[$row][$column]['height'].'"'; elseif ($this->mergeCells[$row][$column]['width']>0 && $this->mergeCells[$row][$column]['height']<1) $mergeCell = 'ss:MergeAcross="'.$this->mergeCells[$row][$column]['width'].'"'; elseif ($this->mergeCells[$row][$column]['width']<1 && $this->mergeCells[$row][$column]['height']>0) $mergeCell = ' ss:MergeDown="'.$this->mergeCells[$row][$column]['height'].'"'; } /* original line commented out */ //$mergeCell = 'ss:MergeAcross="'.$this->mergeCells[$row][$column]['width'].'" ss:MergeDown="'.$this->mergeCells[$row][$column]['height'].'"'; Hope it help others like me who are using OO ;)
-
O melhor programa para compartilhamento
-
A simple, self-contained solution to creating formatted Excel spreadsheets. To improve security, I put the database connection function outside document root and provided additional functions, query_to_sheet and table_to_sheet, that do not require db, user, and password parameters.