doupingpeng7567 2015-12-23 10:02
浏览 358

PHPExcel需要很长时间来加载xls,与xlsx一样好

Good day. I have xls file that looks like this:

+----+-------+--------+
| ID | PRICE | STATUS |
+----+-------+--------+
|  1 |  1000 |      1 |
|  2 |  1000 |      3 |
|  4 |  1324 |      5 |
|  8 |  3141 |      1 |
+----+-------+--------+

As you can see there is not too much rows and cols. But when i try to save it like XLS file and then load to PHPExcel like this:

$objPHPExcel = PHPExcel_IOFactory::load('1.xls');

It takes eternity to load, and Server CPU and RAM usage grows like magic tree. But when i try to do the same stuff with XLSX it works like LeBron James. Like this:

$objPHPExcel = PHPExcel_IOFactory::load('1.xlsx');

PHP extensions: zip, xml, gd, xmlreader, xmlwriter, xmlrpc are installed and works. PHP ver 5.6.12 FastCGI.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 数学建模,尽量用matlab回答,论文格式
    • ¥15 昨天挂载了一下u盘,然后拔了
    • ¥30 win from 窗口最大最小化,控件放大缩小,闪烁问题
    • ¥20 易康econgnition精度验证
    • ¥15 msix packaging tool打包问题
    • ¥28 微信小程序开发页面布局没问题,真机调试的时候页面布局就乱了
    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能