如何使用PHP填充使用MySQL数据的Excel电子表格 [英] How to populate Excel Spreadsheet with MySQL Data using PHP
问题描述
我试图从一个mysql数据库中提取数据,并在其后面使用php计算并填充Excel文件中的各种单元格。是否可以这样做?
提前感谢
p>您可以尝试PHPExcel( http://phpexcel.codeplex.com/ )。我认为这是你正在寻找的。 p>
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.
这篇关于如何使用PHP填充使用MySQL数据的Excel电子表格的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!