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
Other Useful Business Software
Build Securely on Azure with Proven Frameworks
Moving to the cloud brings new challenges. How can you manage a larger attack surface while ensuring great network performance? Turn to Fortinet’s Tested Reference Architectures, blueprints for designing and securing cloud environments built by cybersecurity experts. Learn more and explore use cases in this white paper.
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.