MySQL to Excel??? how can i export data from MySQL to excel in codeIgniter?

[eluser]Unknown[/eluser]
hello everyone:
There have a table "userInfo"(two fields,"username","address") in MySQL database. I want to
export data from the userInfo table into a excel file and can download it in website(every record has its own link,click the link ,popup a dialog,we can download the content of that record),how can i do that? i am a fresh in world of codeIgniter.

[eluser]Kindari[/eluser]
Export it as a csv file, which excel can open. See here:

http://ellislab.com/codeigniter/user-gui...s.html#csv

[eluser]daparky[/eluser]
Or you could do it in PHPMyAdmin?

[eluser]Unknown[/eluser]
About your question, I want to recommand you an article which is published on Codeproject.
It shows how to export data to excel with a small tool. Also, it displays the data source.
You can read the article on http://www.codeproject.com/KB/cs/Excel_P...rtWiz.aspx
Hope helpful!

[eluser]Brad K Morse[/eluser]
Try this http://codeigniter.com/wiki/Excel_Plugin/