CODEWITHSUNDEEP
phpmysqlexcel
JM4
JM4

Reputation: 6788

How to populate Excel Spreadsheet with MySQL Data using PHP

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

Upvotes: 3

Views: 8643

Answers (1)

Wade
Wade

Reputation: 852

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

Upvotes: 5

Related Questions