How can i export to csv or xls using PHP , in different worksheets

Question

How can i export data in different work sheets.

If data is more than 25000 , i want to write next 25000 in next worksheet,

in xls data can be in different tabs..

How can i make that structure using PHP export to csv or xls.

Will it help to reduce load , if i write in different sheets.?

Answer 1

I believe the PEAR class Spreadsheet_Excel_Writer can create multiple worksheets.

I don't think adding worksheets will reduce load, because the filesize will still be the same. I'd suggest you use multiple files instead, if load/filesize is a concern.

Answer 2

PHPExcel is another library, similar to the PEAR Spreadsheet_Excel_Writer class, that can write to multiple worksheets; but it won't necessarily reduce load. If you have more than 25,000 rows (for example, in an array) then this will be using a lot of PHP's memory