Download
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
License
GNU General Public License version 2.0 (GPLv2)Follow Excel Writer (XML) for PHP
nel_h2
MongoDB Atlas runs apps anywhere
MongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
Rate This Project
Login To Rate This Project
User Reviews
-
Thank you for your work.
-
sorry i was op the wrong repos
-
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 ;)
-
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.
-
It's simple to use. Cuts to the point. No need to install various libraries etc. Simply amazing.