phpexcel 生成大数据量excel耗时有关问题 -PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

phpexcel 生成大数据量excel耗时有关问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 pm 01:17 PM

cellexcelphpexcel

phpexcel 生成大数据量excel耗时问题
最近在用phpexcel做一个报表模板，把用户数据做一些处理，然后导出excel供客户查看。
现在遇到了些问题：
1.耗时问题
经过测试生成一个10000行、6列的只含一个sheet的excel，总共需要耗时26秒多
我把代码内部各部分耗时都打印出来了，发现填充sheet里cell的值和样式很费时，两个加起来要11秒；
还有一个就是保存到本地文件里save('test.xls','Excel5')时间花得也很长需要15秒(不知道为什么这么长)。
填充sheet里cell的值我使用的是phpexcel里的fromArray方法，设置样式也是使用getCell($cellRange)来做的，
请问还有优化的点的方法，能缩短时间吗？

2内存使用问题
上面的情况我代码使用内存最高峰有103m，数据量在大点那就无法想象了，我的数据都是保存在数组中的，
和这个有关吗？有什么好的建议吗？

请帮帮忙，先谢谢了！

------解决方案--------------------
第一个问题不好说
第二个问题，你把一万条数据都放数组里了，当程序开始执行的时候，就一次性吧数据全部加载进内存了，肯定会消耗很多内存，可以考虑将数据写进数据库，然后循环处理，或者写入文件，用指针处理
------解决方案--------------------
from array?也就是先生成一个很大的数组然后插入么？

不是可以循环插入的么？

我之前做过导出约50 0000条数据的excel.确实时间会比较长（10多个sheet,大约30s左右），内存占用也很恐怖。据说新版的phpexcel加入了单元格缓存的功能，可能会对性能提升有所帮助。
------解决方案--------------------
不如写入csv格式咯

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Explain the concept of a PHP session in simple terms.Apr 26, 2025 am 12:09 AM

PHPsessionstrackuserdataacrossmultiplepagerequestsusingauniqueIDstoredinacookie.Here'showtomanagethemeffectively:1)Startasessionwithsession_start()andstoredatain$_SESSION.2)RegeneratethesessionIDafterloginwithsession_regenerate_id(true)topreventsessi

How do you loop through all the values stored in a PHP session?Apr 26, 2025 am 12:06 AM

In PHP, iterating through session data can be achieved through the following steps: 1. Start the session using session_start(). 2. Iterate through foreach loop through all key-value pairs in the $_SESSION array. 3. When processing complex data structures, use is_array() or is_object() functions and use print_r() to output detailed information. 4. When optimizing traversal, paging can be used to avoid processing large amounts of data at one time. This will help you manage and use PHP session data more efficiently in your actual project.

Explain how to use sessions for user authentication.Apr 26, 2025 am 12:04 AM

The session realizes user authentication through the server-side state management mechanism. 1) Session creation and generation of unique IDs, 2) IDs are passed through cookies, 3) Server stores and accesses session data through IDs, 4) User authentication and status management are realized, improving application security and user experience.

Give an example of how to store a user's name in a PHP session.Apr 26, 2025 am 12:03 AM

Tostoreauser'snameinaPHPsession,startthesessionwithsession_start(),thenassignthenameto$_SESSION['username'].1)Usesession_start()toinitializethesession.2)Assigntheuser'snameto$_SESSION['username'].Thisallowsyoutoaccessthenameacrossmultiplepages,enhanc

What are some common problems that can cause PHP sessions to fail?Apr 25, 2025 am 12:16 AM

Reasons for PHPSession failure include configuration errors, cookie issues, and session expiration. 1. Configuration error: Check and set the correct session.save_path. 2.Cookie problem: Make sure the cookie is set correctly. 3.Session expires: Adjust session.gc_maxlifetime value to extend session time.

How do you debug session-related issues in PHP?Apr 25, 2025 am 12:12 AM

Methods to debug session problems in PHP include: 1. Check whether the session is started correctly; 2. Verify the delivery of the session ID; 3. Check the storage and reading of session data; 4. Check the server configuration. By outputting session ID and data, viewing session file content, etc., you can effectively diagnose and solve session-related problems.

What happens if session_start() is called multiple times?Apr 25, 2025 am 12:06 AM

Multiple calls to session_start() will result in warning messages and possible data overwrites. 1) PHP will issue a warning, prompting that the session has been started. 2) It may cause unexpected overwriting of session data. 3) Use session_status() to check the session status to avoid repeated calls.

How do you configure the session lifetime in PHP?Apr 25, 2025 am 12:05 AM

Configuring the session lifecycle in PHP can be achieved by setting session.gc_maxlifetime and session.cookie_lifetime. 1) session.gc_maxlifetime controls the survival time of server-side session data, 2) session.cookie_lifetime controls the life cycle of client cookies. When set to 0, the cookie expires when the browser is closed.

See all articles