后端开发|php教程
excel,php
后端开发-php教程
这篇文章主要介绍了关于PHP如何读取大excel文件数据的方法,有着一定的参考价值,现在分享给大家,有需要的朋友可以参考一下
微信红包系统源码,Ubuntu连接arm,tomcat活动连接数,爬虫箱养护,ufeff php,武隆区seo优化以客为尊lzw
场景和痛点
微信小程序 上墙源码,vscode 编译工具链路径,ubuntu 安装 迅雷,tomcat无法用ip,爬虫json数据,asp在线转php,品牌seo优化代理项目平台,仿快乐麻花手机版wap网站模板,3d翻页效果js模板lzw
说明
编写过程
网页源码修改软件utf8,ubuntu命令保存退出,趣头条爬虫破解,php 浮动,密云seo外包lzw
说明
代码
Sheets();if (!$sheets) { die("没有工作表");}//改变当前处理的工作表$Reader->ChangeSheet(0);//打印当前所在工作表的当前所在行数据var_dump($Reader->current());//因为reader类集成了Iter所以可以用迭代方式处理//这里提醒 如果文件超大,这边的处理速度会过慢,不过不会引发内存性能问题//$i = 0;//foreach ($Reader as $Row)//{// if ($i>=3) {// break;// }//// echo $i . PHP_EOL;// print_r($Row);//// $i++;//}$endTime = microtime(true);$memoryUse = memory_get_usage();echo "内存占用:" . convert($memoryUse) . "; 用时:" . ($endTime - $startTime) . PHP_EOL;
结果
测试说明
日志记录内存使用率
147.77 kbarray (size=50) 0 => string xxxxxxxxxxxxxx (length=25) 1 => string xxxxxxxxxxxxxx (length=15) 2 => string xxxxxxxxxxxxxx (length=18) 3 => string xxxxxxxxxxxxxx (length=12) 4 => string xxxxxxxxxxxxxx (length=12) 5 => string xxxxxxxxxxxxxx (length=12) 6 => string xxxxxxxxxxxxxx (length=24) 7 => string xxxxxxxxxxxxxx (length=12) 8 => string xxxxxxxxxxxxxx (length=27) 9 => string xxxxxxxxxxxxxx (length=12) 10 => string xxxxxxxxxxxxxx (length=15) 11 => string xxxxxxxxxxxxxx (length=28) 12 => string xxxxxxxxxxxxxx (length=9) 13 => string xxxxxxxxxxxxxx (length=12) 14 => string xxxxxxxxxxxxxx (length=9) 15 => string xxxxxxxxxxxxxx (length=6) 16 => string xxxxxxxxxxxxxx (length=9) 17 => string xxxxxxxxxxxxxx (length=3) 18 => string xxxxxxxxxxxxxx (length=6) 19 => string xxxxxxxxxxxxxx (length=3) 20 => string xxxxxxxxxxxxxx (length=15) 21 => string xxxxxxxxxxxxxx (length=15) 22 => string xxxxxxxxxxxxxx (length=19) 23 => string xxxxxxxxxxxxxx (length=13) 24 => string xxxxxxxxxxxxxx (length=19) 25 => string xxxxxxxxxxxxxx (length=12) 26 => string xxxxxxxxxxxxxx (length=12) 27 => string xxxxxxxxxxxxxx (length=12) 28 => string xxxxxxxxxxxxxx (length=6) 29 => string xxxxxxxxxxxxxx (length=12) 30 => string xxxxxxxxxxxxxx (length=6) 31 => string xxxxxxxxxxxxxx (length=15) 32 => string xxxxxxxxxxxxxx (length=24) 33 => string xxxxxxxxxxxxxx (length=18) 34 => string xxxxxxxxxxxxxx (length=18) 35 => string xxxxxxxxxxxxxx (length=24) 36 => string xxxxxxxxxxxxxx (length=12) 37 => string xxxxxxxxxxxxxx (length=18) 38 => string xxxxxxxxxxxxxx (length=21) 39 => string xxxxxxxxxxxxxx (length=9) 40 => string xxxxxxxxxxxxxx (length=9) 41 => string xxxxxxxxxxxxxx (length=18) 42 => string xxxxxxxxxxxxxx (length=21) 43 => string xxxxxxxxxxxxxx (length=15) 44 => string xxxxxxxxxxxxxx (length=12) 45 => string xxxxxxxxxxxxxx (length=6) 46 => string xxxxxxxxxxxxxx (length=12) 47 => string xxxxxxxxxxxxxx (length=22) 48 => string xxxxxxxxxxxxxx (length=22) 49 => string \ (length=0)内存占用:207.55 kb; 用时:9.5835480690002