There's probably a "proper" way, but I've previously had good success with:
- generate a bare html table with your data (no need for any surrounding page layout) - serve the html content with a mime-type of application/vnd.ms-excel - set a header of: Content-Disposition: attachment; filename="name_of_excel_file.xls" Excel will open your html table with an .xls file extension, and when the user saves, the file gets saved as a proper excel document. And you haven't had to fiddle around with any half-baked excel file making libraries. Cheers Daniel. On Sun, Jun 3, 2012 at 9:22 PM, alvin567 <[email protected]> wrote: > Is there a way to generate the excel spreadsheet using cakephp? > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- Daniel Baird I've tried going to the XHTML <bar /> a few times, but it's always closed. -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
