Writing Excel File

[eluser]phusiondesign[/eluser]
I have been trying to use CI to write data from my MySQL database to an excel spreadsheet. I been running into a problem with the header information being passed preemptively from CI and no from the definitions in my controller.

Does anyone have a script already which dumps data from SQL to excel via PHP? I would appreciate any help or advice.

Thanks.

[eluser]TheFuzzy0ne[/eluser]
[quote author="phusiondesign" date="1209169218"]I have been trying to use CI to write data from my MySQL database to an excel spreadsheet. I been running into a problem with the header information being passed preemptively from CI and no from the definitions in my controller.

Does anyone have a script already which dumps data from SQL to excel via PHP? I would appreciate any help or advice.

Thanks.[/quote]

Does your solution have to be PHP-based?

Please check out http://www.heritage-tech.net/267/interfa...via-excel/

I cannot vouch for it, but it's made by MySQL, so it's bound to be pretty good. The only catches are that you must be running winblows, and you'll need to install MyODBC (the software).

EDIT: Upon closer inspection, it would seem that you can run MyODBC on just about any platform.

[eluser]phusiondesign[/eluser]
Solved... check this out: http://codeigniter.com/wiki/Excel_Plugin/

Thanks!

[eluser]TheFuzzy0ne[/eluser]
[quote author="phusiondesign" date="1209171366"]Solved... check this out: http://codeigniter.com/wiki/Excel_Plugin/

Thanks![/quote]

Great stuff! Thanks.

Note to self: Check out the CI Wiki.

[eluser]geshan[/eluser]
Yes thats great, I'm using it too. All thanks to Derek I guess.