How to populate Excel Spreadsheet with MySQL Data using PHP

Question

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

Start by looking at PHP libraries capable of writing Excel files... you have googled for PHP and Excel haven't you? — Mark Baker
– Mark Baker, Commented Jan 19, 2011 at 22:16
I am not looking to write an excel file. As I mention, I want to open an existing file, add data to it, and save it all with PHP — JM4
– JM4, Commented Jan 19, 2011 at 22:18
@Mark - you are correct, if I googled every possible search term on the planet involving xls, excel, microsoft, php, mysql I might have found the answer in three seconds. My question is posted here to get clarification from a network of trusted individuals who might provide insight into what is "good", what works, and what is crap. You ask me for a recommendation on what is good to eat in New York and I tell you to Google it for the answer is absurd. Note: "populate excel spreadsheet php" and "write to existing .xls php" do not talk about the software at all. — JM4
– JM4, Commented Jan 19, 2011 at 22:26

Wade · Accepted Answer · 2011-01-19 22:16:06Z

5

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

answered Jan 19, 2011 at 22:16

Wade

8621 gold badge8 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JM4 Over a year ago

thanks for the link. I came across this link before (and i should have added to my intial question) but we run Excel 2003 so the XML from 2007 does not apply (I think).

Mark Baker Over a year ago

MS Excel 2003 reads/writes BIFF8 xls files as its default format... This is the Exce5 Reader/Writer in PHPExcel

Collectives™ on Stack Overflow

How to populate Excel Spreadsheet with MySQL Data using PHP

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related