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 <[email protected]> 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 <[email protected]> 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 [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to