如何在不同的工作表中使用PHP导出到csv或xls

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.