Extract from MySQL to XLS (code included)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

spitfire_esquive
Forum Commoner
Posts: 37
Joined: Sun Nov 06, 2005 6:46 am

Post by spitfire_esquive »

the PEAR Excel Spreadsheet Writer words like a dream :D
User avatar
phpScott
DevNet Resident
Posts: 1206
Joined: Wed Oct 09, 2002 6:51 pm
Location: Keele, U.K.

Post by phpScott »

did you try making it a csv file, Excel takes in csv files

get the data to save to a file like

Name, address, phone, email
scott, somewhere, 555-5555, bob@bob.com
steve, somewhere else, 555-5656, steve@steve.com

save the file as data.csv

let the user download and save it.

Excel has import data wizards which worked just fine for me as a test
Post Reply