Hello I am looking to dump data from a MySQL database to an excel spreadsheet. I know I can dump it to a CSV file and import that way, no problem. But I want to dump the data to a specific spreadsheet in an excel and specific cells.

I have an excel that has macros created to chart patients blood data, I want to dump their data to the excel so they can run the macro and make the charts as easy as possible. Any help? Is this even possible?

I am using PHP and a MySQL database on Godaddy hosting.

Recommended Answers

Perhaps this tool can help: http://phpexcel.codeplex.com/

Jump to Post

All 2 Replies

Not much, I guess I am not as good of a programmer as I thought I was! I just wish I could get this to work.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.