There was a simple solution to generating excel sheets using PHP. A friend of mine had created it using a simple code and without much formatting. Unfortunately, when it came to client side demands everything had to “LOOK” good.

This forced me to look for an alternate solution to the generation of fully formatted excel sheets. And then I found Spreadsheet_Excel_Writer. Well, this was class based and I had to include a lot of files (some of them weren’t even there in the package) but the final output was sweet and since it included formatting too, the clients were pretty happy with the stuff too.

Just to go thru the entire thing in basic details I’ll explain a pretty short example and hope that you’ll follow up on the stuff later.
Let’s start off then.

/*
* Creating object of class
* The second part within ()
* indicates the save location
* of the file
*/

$workbook = new Spreadsheet_Excel_Writer(’../../../excelfiles/OnlineExcel.xls’);
Read More

Comments (2) Oct 28 2008