Re: Export to Excel
There is a trick that almost makes me love Microsoft... You can export an html table to Excel. Just output a table, maybe some heading before and a p-tag after if you like... no layout... no full html document needed. Just make the browser think this html table is an excel file and Excel will happily import it. That is: Set the header to application/vnd.ms-excel and/or the filename to something.xls CSV is a very good format to export to since it is can be imported to any number of applications and databases. But if Excel is all you want I like the simple cheat with the table. On Aug 23, 10:54 am, delocalizer conrad.leon...@hotmail.com wrote: Adam Royle's csv helper is very nice for this...http://bakery.cakephp.org/articles/view/csv-helper-php5 cheers, Conrad. On Aug 23, 12:41 am, AMF afuhrm...@gmail.com wrote: I've been looking for a good tutorial/exaple on exporting data to excel like format. Any success/ideas/pinters. Thanks AMF --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Export to Excel
There are at least 2 articles in the bakery that describe how to create a real Excel file (no csv): http://bakery.cakephp.org/articles/view/generate-excel-spreadsheets-from-your-database http://bakery.cakephp.org/articles/view/excel-xls-helper Personally I use the second one and it works quite good. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
Re: Export to Excel
Adam Royle's csv helper is very nice for this... http://bakery.cakephp.org/articles/view/csv-helper-php5 cheers, Conrad. On Aug 23, 12:41 am, AMF afuhrm...@gmail.com wrote: I've been looking for a good tutorial/exaple on exporting data to excel like format. Any success/ideas/pinters. Thanks AMF --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~--~~~~--~~--~--~---
