php读取excel长度限制问题
今天用php导入一个excel文件。文件长度超过2000行。字段超过15000行。一开始导入不成功,更改了php.ini设置:
max_execution_time = 36000 ; Maximum execution time of each script, in seconds
max_input_time = 60; Maximum amount of time each script may spend parsing request data
;max_input_nesting_level = 64 ; Maximum input variable nesting level
memory_limit =128M;
max_input_vars = 20000;
即可
另外,一个很好的phpexcel操作类下载地址:http://download-codeplex.sec.s-msft.com/Download/Release?ProjectName=phpexcel&DownloadId=809023&FileTime=130382506270130000&Build=21031
这个类比起来以前经常用的简单点的phpexcelreader,bug少,稳定
标签:Excel, PHP