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.
让我们继续这样做 - 我意识到我可以用php和mysql生成表格并以“几乎”的方式输出我需要的任何格式但是在这种情况下，excel电子表格以一些奇怪的方式格式化（布局，颜色，等）客户不会让步。我必须使用确切的Excel电子表格。
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?
我试图从mysql数据库中提取数据，并在其后面进行php计算，并在Excel文件中填充各种单元格。是否有可能做到这一点？
Thank you ahead of time
提前谢谢你
1 个解决方案
#1
5
You can try PHPExcel ( http://phpexcel.codeplex.com/). I think this is what you are looking for.
您可以尝试使用PHPExcel（http://phpexcel.codeplex.com/）。我想这就是你要找的东西。
#1
5
You can try PHPExcel ( http://phpexcel.codeplex.com/). I think this is what you are looking for.
您可以尝试使用PHPExcel（http://phpexcel.codeplex.com/）。我想这就是你要找的东西。