There is an excel generator: http://phpexcel.codeplex.com/ <http://phpexcel.codeplex.com/>Works pretty good, with formatting, tabs, and everything u can imagine.
Pretty simple to use with cake: http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=54383 <http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=54383>But if u dont want to use third-part code, you can learn to write excel xml syntax. Pretty simple too. But will be able to read only on excel 2003 or latter. -- Renato de Freitas Freire [email protected] On Mon, Dec 20, 2010 at 8:21 PM, cricket <[email protected]> wrote: > On Mon, Dec 20, 2010 at 8:42 AM, Ryan Schmidt > <[email protected]> wrote: > > On Dec 20, 2010, at 06:16, Mike Karthauser wrote: > >> On Mon, December 20, 2010 11:49 am, rakeshyadav rakeshyadav wrote: > >>> i am trying to export my reports to excel in .xls formate and > i > >>> need to maintain > >>> > >>> same view in both MSExcel and Openoffice can any one please > >>> suggest me the > >>> > >>> easy way to achive this > >> > >> yes. export as a csv. that will go into either spreadsheet package. > > > > If you need more control than a CSV can provide (for example, if you want > to specify any formatting), you could write an Excel file directly. Several > years ago I used the PEAR module Spreadsheet_Excel_Writer for this purpose: > > > > > > http://pear.php.net/package/Spreadsheet_Excel_Writer > > I've used that in the past, also. Works really well. And there's also > an ExcellHelper out there somewhere, IIRC. Check the bakery. > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > 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]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
