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]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/ |
Welcome Guest, Not a member yet? Register Sign In |