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
Turn Your Content into Interactive Magic - For Free
Transform anything you share into an engaging digital experience - for free. Instantly convert your PDFs, slides, and files into dynamic, interactive sessions with built-in collaboration tools, activities, and real-time assessment. From teaching to training to team building, make every presentation unforgettable. Used by millions for education, business, and professional development.
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.