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