php填充mysql表格,如何使用PHP填充使用MySQL数据的Excel电子表格

Let's go ahead and get this out of the way - i realize I can generate tables with php and mysql and output in 'almost' any format I need but in this scenario, the excel spreadsheet is formatted in some strange ways (layout, color, etc) and the client won't budge. I have to use the exact excel spreadsheet.

I am trying to pull data from a mysql database with php calculations behind it and populate various cells within an Excel file. Is it possible to do this?

Thank you ahead of time

解决方案

You can try PHPExcel ( http://phpexcel.codeplex.com/). I think this is what you are looking for.