Extract from MySQL to XLS (code included)
Moderator: General Moderators
-
spitfire_esquive
- Forum Commoner
- Posts: 37
- Joined: Sun Nov 06, 2005 6:46 am
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
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