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-from-your-database 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 -~----------~----~----~----~------~----~------~--~---
