I'm not exactly sure if this is what you're looking for, but you can have your code write directly to an XLS file. I used this bakery post as a starting point:
http://bakery.cakephp.org/articles/view/generate-excel-spreadsheets-from-your-database One caveat: be sure to write the excel file to your server, rather than attempt to send headers to the browser. Good luck! -M On Apr 29, 11:27 am, SumanRS <[EMAIL PROTECTED]> wrote: > Hi, > > I've been using CakePHP for creating an online version of a listing > that has long been maintained using Excel. There are several hundred > rows in this table. > > However, one thing where the Excel UI wins is in allowing a new field > (column) to be added. After that, it is easy to update the field for > all rows. If I wanted to do this in Cake, I would have to click "Edit" > on each row and edit the value for the field for each row. > > One way I can think of solving this is: > 1. Export the CakePHP values to a CSV > 2. Edit the CSV in Excel > 3. Write PHP to open the edited CSV and update the fields (I've done > this before) > > Is there a way to do this natively (and easily) in CakePHP? > > Thanks, > SumanRS --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
