为什么PHPExcel不允许写超过5000行 [英] Why PHPExcel does not allow to write more than 5000 rows

问题描述

任何人都可以告诉我为什么PHPExcel不允许超过5000行. 我正在使用开放源代码的PHPExcel在我的项目中生成报告，并且无法从Mysql-DB中写入超过5000行的数据.执行查询时，我的结果集获取7230条记录.我该如何解决..

Can any one please tell me Why PHPExcel does not allow more than 5000 rows. I am using an open-source PHPExcel for report generation on my projects and i could not write more than 5000 rows of data from Mysql-DB. My result set fetch 7230 records when the query is executed. How do i fix it..

推荐答案

几乎可以肯定，这是超时或内存问题. PHPExcel对工作表大小的唯一限制是65,536行和256(IV)列(使用Excel5 Writer时)；或1,048,576行和16,384(XFD)列(使用Excel2007 Writer时).

Almost certainly this is a timeout or a memory issue. The only PHPExcel limit for worksheets size is 65,536 rows and 256 (IV) columns (when using the Excel5 Writer); or 1,048,576 rows and 16,384 (XFD) columns (when using the Excel2007 Writer).

确保始终启用错误日志记录...使用try/catch块捕获任何PHPExcel异常.并阅读有关内存和性能的PHPExcel网站讨论线程.

Ensure that your error logging is always enabled... use try/catch blocks to trap for any PHPExcel Exceptions. And read the PHPExcel site discussion threads on memory and performance.

这篇关于为什么PHPExcel不允许写超过5000行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！