How can transfer a table from a Mysql db to an Excel sheet?

Can anyone help me to transfer a table from mysql to excel?any open source link or any readymade script will be great help for me.

 

You may use PHPMyAdmin but it will be export your tables into .csv format and csv format can open in excel, once you open in excel, save this file with .xls extensions

 

csv is text format,
for binary excel file use the class I attach, it's not mine

 

thank you gibex for the scripts.it is helpful.thanks a lot.

 

Keep in mind that for the vast majority of things you can take the other guys advice and just use PHPMyAdmin and export as CSV.

Of course it depends on your specific needs, but don't waste time setting up classes and (relatively) complex code if you can just use PHPMyAdmin.

 

thanks for your suggestion.
yes trying it from PHPMyAdmin is an easy solution,but the scripts those he attached was also helpful.everything has an alternative.
His scripts were only an alternative and it was helpful for me

 

Oh good, I didn't mean it the way I think it might have sounded. Definitely give the classes a try if you need to do complex stuff, but I've wasted many hours trying to figure out other peoples' class code and was just trying to spare you that if possible .