I didn't follow the actual links before - yes it is #3. I don't recall us having any problems getting it working, other than large files being corrupted when using version 8. But then we did extend the helper a little for other reasons, so perhaps that also fixed some issues? Send me a direct email if you'd like a copy of what we use.
But behind the scenes it just uses the PEAR spreadsheet_excel_writer, which we've used directly in Cake projects before with no problems. On Oct 12, 11:58 pm, Matt Kosoy <[EMAIL PROTECTED]> wrote: > Did you mean method # 3? Method #2 is used as a component - sorry. > > On Oct 11, 7:20 pm, Grant Cox <[EMAIL PROTECTED]> wrote: > > > We use a modified version of the helper on the Bakery (#2 in your > > list). We found that same issue of larger files being invalid - this > > was fixed by just removing the > > > $this->workbook->setVersion(8); > > > call from the constructor of the helper. > > > On Oct 12, 8:34 am, Matt Kosoy <[EMAIL PROTECTED]> wrote: > > > > Hello. > > > > I'm having a ton of problems trying to get cakephp to generate excel > > > files correctly, and I was wondering if anyone out there has any info/ > > > suggestions. > > > > So far I have tried the following: > > > > 1. Re-writing a class I found on phpclasses.org (http:// > > > phpclasses.promoxy.com/browse/package/2037.html) > > > this method generates the files correctly, but the problem is that > > > the xls files that are created do not open on Windows machines. This > > > class works perfect from outside of cakephp -- it's a shame. > > > > 2. I attempted to implement this helper: > > > http://bakery.cakephp.org/articles/view/excel-xls-helper > > > using this method is ok, but for larger result sets (more than 100 > > > rows returned) "bad" files are created which can not be opened by > > > Excel on any platform. > > > > 3. The "Generate Excel spreadsheets from your database" method > > > --http://bakery.cakephp.org/articles/view/generate-excel-spreadsheets-f... > > > > I can not make this method work for the life of me. With debugging > > > set to 0 the only result that's returned is complete gobbeldygook. > > > > 4. I have attempted to use PEAR's spreadsheet_excel_writer > > > module, but we are hitting an open_basedir error/warning. We're > > > trying to work that out right now. > > > > I can post code examples. Any help, suggestion, or advice would be > > > greatly appreciated. I'm tearing my eyeballs out over this. > > > > Thanks World!!!! > > > > -matt > > > > 4. Using the raw PEAR 'Spreadsheet_Excel_Writer' module -- this > > > method is producing an open_basedir warning/error, and we are > > > attempting to work out the problem with our server ppl. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
