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