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
Our Free Plans just got better! | Auth0
You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
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.