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