This question asked several times, and did not get the answer, so I carefully study, see the relevant information, finally get out.
Http://www.youyax.com/forum/index.php/Content-index-id-5058.shtml
It's the principle that
For example, the database has 10,000 records to export, then the export of 10,000 an estimated browser will also crash.
The idea of this approach is that
1, first query Xx.xls file does not exist, does not exist on the creation (first judgment)
2, set the first row header (first judgment), then read the total number of rows, and then export 500 records
3, write Xx.xls file,
4, jump to the current page, cycle the above operation.
Reply to discussion (solution)
1w Browser crashes? That Excel support single tab Max 65535 lines, Phpexcel is not very weak
Such a simple description, rookie we still won't
Uh, uh, huh????
Phpexcel provides a variety of caching methods, why don't you
