+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Need help exporting data to CSV, Excel and XML (/showthread.php?tid=7827)
Need help exporting data to CSV, Excel and XML - El Forum - 04-24-2008
[eluser]geshan[/eluser]
Dear All,
I'm working on something and I need to export the results of a query (table mainly) to .CSV,.xls and .xml (.pdf) also ok. So please help me with it how do I do it in CI?
Need help exporting data to CSV, Excel and XML - El Forum - 04-24-2008
[eluser]xwero[/eluser]
$this->dbutil->csv_from_result($db_result) and $this->dbutil->xml_from_result($db_result).
To xsl seems a little strange as it is a transforming file.
Need help exporting data to CSV, Excel and XML - El Forum - 04-24-2008
[eluser]Seppo[/eluser]
xls, not xsl... That means excel...
If you want excel to open it, you can use an HTML table... but if you want a real XLS the thing gets harder... You can search for some class, like this one, for example
Need help exporting data to CSV, Excel and XML - El Forum - 04-24-2008
[eluser]xwero[/eluser]
ok my mistake
Need help exporting data to CSV, Excel and XML - El Forum - 04-24-2008
[eluser]Ch!ps[/eluser]
Derek Allard, http://www.derekallard.com , has created a wonderful plug-in to export as Excel file.
http://codeigniter.com/wiki/Excel_Plugin/
Pretty certain he has developed one for XML as well
Need help exporting data to CSV, Excel and XML - El Forum - 10-28-2008
[eluser]llbbl[/eluser]
http://ellislab.com/codeigniter/user-guide/database/utilities.html#csv