Re: Export to Excel

2009-08-24 Thread Braindead

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

2009-08-23 Thread Martin Westin


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  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  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

2009-08-23 Thread delocalizer

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  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
-~--~~~~--~~--~--~---