[symfony-users] Re: [ Export data To excel ]

2009-02-22 Thread Sherif
I have found PHPExcel to consume a LOT of memory. Was trying to export 30,000 rows, lots of memory issues. Memory issues were resolved when I switched to the pear libary SPREADSHEET_EXCEL_WRITER Which I would recommend, it is a little bit buggy, but will do for most things. Your other option as Fa

[symfony-users] Re: [ Export data To excel ]

2009-02-20 Thread cleve
I use Fabrice's HTML table formatted as Excel method, but also consider or use http://www.kunalbabre.com/projects/table2CSV.php On Feb 20, 10:58 am, Fabrice B wrote: > I know three solutions to do Excel exports. > >  - Csv > > It is in my opinion not an interesting one, unless your rows ar

[symfony-users] Re: [ Export data To excel ]

2009-02-20 Thread Fabrice B
I know three solutions to do Excel exports. - Csv It is in my opinion not an interesting one, unless your rows are already formatted into arrays. In that case implode(';',$row) might be interesting - HTML table formatted as Excel This is a nice trick I once discovered. You can do a simple H

[symfony-users] Re: [ Export data To excel ]

2009-02-20 Thread Gareth McCumskey
Ant I believe is talking about creating a CSV file (filename.csv) as opposed to a direct Excel file (filename.xls). CSV files can be opened in Excel but do not permit advanced formatting options like you can get in an Excel spreadsheet. CSV files only allow you to dump lists of data. Depending on

[symfony-users] Re: [ Export data To excel ]

2009-02-20 Thread Nabil EL GHALI
Thank's Ant i'm new in symfony , but i dont know i must create a new action ( executeExport() ) and a new layout in the template folder to do that ? because i must customize the excel file with the compagny informations and an footer with export date and time . 2009/2/20 Ant Cunningham > > C

[symfony-users] Re: [ Export data To excel ]

2009-02-20 Thread Ant Cunningham
Create the csv string in your action, set layout to false, change the response headers accordingly, and dump the var in the template. Its been covered numerous times search the forum or the news group or more verbose insights :-) Nabil EL GHALI wrote: > Hi everyone , > > > i'm searching to