php读取excel，以及php打包文件夹为zip文件，

首页

后端开发

php教程

php读取excel，以及php打包文件夹为zip文件，_PHP教程

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jul 13, 2016 am 10:23 AM

excelphpzip为打包文件文件夹读取

php读取excel，以及php打包文件夹为zip文件，

<span class="pln"><span>1.把文件下载到本地，放在在Apache环境下</span><br /><span>2.d.xlsx是某游戏的服务器名和玩家列表，本程序只适合此种xlsx文件结构，其他结构请修改index.php源码</span><br /><span>3.访问zip.php的功能是把生成的files文件夹打包成files.zip</span><br /><span>4.访问index.php即可生成files文件夹，里面0.js---n.js 分别存放各个服务器人名，server_name_list.js存放服务器列表。</span><br /><span>5.Classes 存放的是php读取excel的功能模块，具体任务逻辑都在index.php<br /><br />A.PHP读取excel支持excel2007<br /><br />demo逻辑代码：其中的（arrayRecursive，JSON方法是json数据处理功能，可兼容汉字）<br /></span>主要借助了：PHPExcel插件，附件中有Classes文件夹，官网：http://www.codeplex.com/PHPExcel<br />index.php<br /></span>

<?<span>php 
</span><span>/*</span><span>* Error reporting </span><span>*/</span>
<span>error_reporting</span>(0<span>);
</span><span>header</span>("Content-type: text/html; charset=utf-8"<span>); 
</span>?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>标题</title>
</head>

<body>
    <?<span>php 
    </span><span>/*</span><span>*************************************************************
     *
     *  使用特定function对数组中所有元素做处理
     *  @param  string  &$array     要处理的字符串
     *  @param  string  $function   要执行的函数
     *  @return boolean $apply_to_keys_also     是否也应用到key上
     *  @access public
     *
     ************************************************************</span><span>*/</span>
    <span>function</span> arrayRecursive(&<span>$array</span>, <span>$function</span>, <span>$apply_to_keys_also</span> = <span>false</span><span>)
    {
        </span><span>static</span> <span>$recursive_counter</span> = 0<span>;
        </span><span>if</span> (++<span>$recursive_counter</span> > 1000<span>) {
            </span><span>die</span>('possible deep recursion attack'<span>);
        }
        </span><span>foreach</span> (<span>$array</span> <span>as</span> <span>$key</span> => <span>$value</span><span>) {
            </span><span>if</span> (<span>is_array</span>(<span>$value</span><span>)) {
                arrayRecursive(</span><span>$array</span>[<span>$key</span>], <span>$function</span>, <span>$apply_to_keys_also</span><span>);
            } </span><span>else</span><span> {
                </span><span>$array</span>[<span>$key</span>] = <span>$function</span>(<span>$value</span><span>);
            }
     
            </span><span>if</span> (<span>$apply_to_keys_also</span> && <span>is_string</span>(<span>$key</span><span>)) {
                </span><span>$new_key</span> = <span>$function</span>(<span>$key</span><span>);
                </span><span>if</span> (<span>$new_key</span> != <span>$key</span><span>) {
                    </span><span>$array</span>[<span>$new_key</span>] = <span>$array</span>[<span>$key</span><span>];
                    </span><span>unset</span>(<span>$array</span>[<span>$key</span><span>]);
                }
            }
        }
        </span><span>$recursive_counter</span>--<span>;
    }
     
    </span><span>/*</span><span>*************************************************************
     *
     *  将数组转换为JSON字符串（兼容中文）
     *  @param  array   $array      要转换的数组
     *  @return string      转换得到的json字符串
     *  @access public
     *
     ************************************************************</span><span>*/</span>
    <span>function</span> JSON(<span>$array</span><span>) {
        arrayRecursive(</span><span>$array</span>, 'urlencode', <span>true</span><span>);
        </span><span>$json</span> = json_encode(<span>$array</span><span>);
        </span><span>return</span> <span>urldecode</span>(<span>$json</span><span>);
    }

    </span><span>require_once</span> 'Classes\PHPExcel.php'<span>;  
    </span><span>require_once</span> 'Classes\PHPExcel\IOFactory.php'<span>;  
    </span><span>require_once</span> 'Classes\PHPExcel\Reader\Excel2007.php'<span>;  
    </span><span>$uploadfile</span>='d.xlsx'<span>;  
      
    </span><span>$objReader</span> = PHPExcel_IOFactory::createReader('Excel2007');<span>/*</span><span>Excel5 for 2003 excel2007 for 2007</span><span>*/</span> 
    <span>$objPHPExcel</span> = PHPExcel_IOFactory::load(<span>$uploadfile</span><span>);
    </span><span>$sheet</span> = <span>$objPHPExcel</span>->getSheet(0<span>);  
    </span><span>$highestRow</span> = <span>$sheet</span>->getHighestRow(); <span>//</span><span> 取得总行数  </span>
    <span>$highestColumn</span> = <span>$sheet</span>->getHighestColumn(); <span>//</span><span> 取得总列数  </span>

    <span>/*</span><span>方法【推荐】</span><span>*/</span>  
    <span>$objWorksheet</span> = <span>$objPHPExcel</span>-><span>getActiveSheet();          
    </span><span>$highestRow</span> = <span>$objWorksheet</span>->getHighestRow();   <span>//</span><span> 取得总行数       </span>
    <span>$highestColumn</span> = <span>$objWorksheet</span>-><span>getHighestColumn();          
    </span><span>$highestColumnIndex</span> = PHPExcel_Cell::columnIndexFromString(<span>$highestColumn</span>);<span>//</span><span>总列数  </span>
    <span>$list</span> = <span>array</span><span>();
    </span><span>for</span> (<span>$row</span> = 1;<span>$row</span> <= <span>$highestRow</span>;<span>$row</span>++<span>)         {  
        </span><span>$strs</span>=<span>array</span><span>();  
        </span><span>//</span><span>注意highestColumnIndex的列数索引从0开始  </span>
        <span>for</span> (<span>$col</span> = 0;<span>$col</span> < <span>$highestColumnIndex</span>;<span>$col</span>++<span>)            {  
            </span><span>$strs</span>[<span>$col</span>] =<span>$objWorksheet</span>->getCellByColumnAndRow(<span>$col</span>, <span>$row</span>)-><span>getValue();  
        }  
        </span><span>array_push</span>(<span>$list</span>, <span>$strs</span><span>);  
    }
    </span><span>//</span><span>读取完毕 $list
    //处理数据，生成新的结构</span>
    <span>$n</span> = 0<span>;
    </span><span>$ser</span> = <span>array</span><span>();
    </span><span>for</span>(<span>$i</span> = 0 ; <span>$i</span> < <span>count</span>(<span>$list</span>); <span>$i</span>++<span> ){
        </span><span>$ser</span>[<span>$n</span>][0] = <span>$list</span>[<span>$i</span>][0<span>];
         </span><span>if</span>(!<span>is_array</span>(@<span>$ser</span>[<span>$n</span>][1<span>])){
            </span><span>$ser</span>[<span>$n</span>][1] = <span>array</span><span>();
        }
         </span><span>array_push</span>(<span>$ser</span>[<span>$n</span>][1], <span>$list</span>[<span>$i</span>][1<span>]);
        </span><span>if</span>(<span>$i</span> != <span>count</span>(<span>$list</span>) -1<span>){
          </span><span>if</span>(<span>$list</span>[<span>$i</span>][0] != <span>$list</span>[<span>$i</span>+1][0<span>]){
                </span><span>$n</span>++<span>;
            } 
        }
     }
    </span><span>/*</span><span>输出文件</span><span>*/</span>
    <span>$sname</span> = <span>array</span><span>();
    </span><span>$f</span> = 'files/';<span>//</span><span>存放目录</span>
    <span>if</span> (! <span>file_exists</span> ( <span>$f</span><span> )) {
        </span><span>mkdir</span> ( <span>$f</span><span> );
    }
    </span><span>for</span>(<span>$j</span> = 0;<span>$j</span> < <span>count</span>(<span>$ser</span>); <span>$j</span>++<span>){
        </span><span>$file</span> = <span>$f</span>.<span>$j</span>.'.js'<span>;
        </span><span>echo</span> <span>$file</span>."<br />"<span>;
        </span><span>$fp</span>=<span>fopen</span>("<span>$file</span>", "w+"); <span>//</span><span>打开文件指针，创建文件</span>
        <span>if</span> ( !<span>is_writable</span>(<span>$file</span><span>) ){
              </span><span>die</span>("文件:" .<span>$file</span>. "不可写，请检查！"<span>);
        }
        </span><span>if</span> (<span>is_writable</span>(<span>$file</span>) == <span>false</span><span>) {
                </span><span>die</span>('我是鸡毛,我不能'<span>);
        }
        </span><span>$data</span> = <span>$ser</span>[<span>$j</span>][1<span>];
        </span><span>array_push</span>(<span>$sname</span>, <span>$ser</span>[<span>$j</span>][0<span>]);
        </span><span>file_put_contents</span> (<span>$file</span>, JSON(<span>$data</span><span>));
        </span><span>fclose</span>(<span>$fp</span>);  <span>//</span><span>关闭指针</span>
<span>    }
        </span><span>$file</span> = <span>$f</span>.'server_name_list.js'<span>;
        </span><span>echo</span> <span>$file</span>."<br />"<span>;;
        </span><span>$fp</span>=<span>fopen</span>("<span>$file</span>", "w+"); <span>//</span><span>打开文件指针，创建文件</span>
        <span>if</span> ( !<span>is_writable</span>(<span>$file</span><span>) ){
              </span><span>die</span>("文件:" .<span>$file</span>. "不可写，请检查！"<span>);
        }
        </span><span>if</span> (<span>is_writable</span>(<span>$file</span>) == <span>false</span><span>) {
                </span><span>die</span>('我是鸡毛,我不能'<span>);
        }
        </span><span>file_put_contents</span> (<span>$file</span>, JSON(<span>$sname</span><span>));
        </span><span>echo</span> "生成完毕！"<span>;
        </span><span>echo</span> '<a href="zip.php">打包生成文件</a>'
    ?>
</body>
</html>

B.PHP打包文件夹为zip文件

zip.php

<?<span>php 
</span><span>/*</span><span>* Error reporting </span><span>*/</span>
<span>error_reporting</span>(0<span>);
</span><span>header</span>("Content-type: text/html; charset=utf-8"<span>); 
</span>?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>标题</title>
</head>

<body>
<?<span>php
    </span><span>function</span> addFileToZip(<span>$path</span>,<span>$zip</span><span>){
    </span><span>$handler</span>=<span>opendir</span>(<span>$path</span>); <span>//</span><span>打开当前文件夹由$path指定。</span>
    <span>while</span>((<span>$filename</span>=<span>readdir</span>(<span>$handler</span>))!==<span>false</span><span>){
        </span><span>if</span>(<span>$filename</span> != "." && <span>$filename</span> != ".."){<span>//</span><span>文件夹文件名字为'.'和&lsquo;..&rsquo;，不要对他们进行操作</span>
            <span>if</span>(<span>is_dir</span>(<span>$path</span>."/".<span>$filename</span>)){<span>//</span><span> 如果读取的某个对象是文件夹，则递归</span>
                addFileToZip(<span>$path</span>."/".<span>$filename</span>, <span>$zip</span><span>);
            }</span><span>else</span>{ <span>//</span><span>将文件加入zip对象</span>
                <span>$zip</span>->addFile(<span>$path</span>."/".<span>$filename</span><span>);
            }
        }
    }
    @</span><span>closedir</span>(<span>$path</span><span>);
}


</span><span>$zip</span>=<span>new</span><span> ZipArchive();
</span><span>if</span>(<span>$zip</span>->open('files.zip', ZipArchive::OVERWRITE)=== <span>TRUE</span><span>){
    addFileToZip(</span>'files', <span>$zip</span>); <span>//</span><span>调用方法，对要打包的根目录进行操作，并将ZipArchive的对象传递给方法</span>
    <span>$zip</span>->close(); <span>//</span><span>关闭处理的zip文件</span>
<span>}
</span><span>echo</span> '打包完毕！'."<br />"<span>;
</span><span>echo</span> "<a href='files.zip'>下载files.zip</a>"
?>
</body>
</html>

代码下载：php-read-excel

http://files.cnblogs.com/zhidong123/php-read-excel.zip

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

PHP与Python：了解差异Apr 11, 2025 am 12:15 AM

PHP和Python各有优势，选择应基于项目需求。1.PHP适合web开发，语法简单，执行效率高。2.Python适用于数据科学和机器学习，语法简洁，库丰富。

php：死亡还是简单地适应？Apr 11, 2025 am 12:13 AM

PHP不是在消亡，而是在不断适应和进化。1)PHP从1994年起经历多次版本迭代，适应新技术趋势。2)目前广泛应用于电子商务、内容管理系统等领域。3)PHP8引入JIT编译器等功能，提升性能和现代化。4)使用OPcache和遵循PSR-12标准可优化性能和代码质量。

PHP的未来：改编和创新Apr 11, 2025 am 12:01 AM

PHP的未来将通过适应新技术趋势和引入创新特性来实现：1)适应云计算、容器化和微服务架构，支持Docker和Kubernetes；2)引入JIT编译器和枚举类型，提升性能和数据处理效率；3)持续优化性能和推广最佳实践。

您什么时候使用特质与PHP中的抽象类或接口？Apr 10, 2025 am 09:39 AM

在PHP中，trait适用于需要方法复用但不适合使用继承的情况。1)trait允许在类中复用方法，避免多重继承复杂性。2)使用trait时需注意方法冲突，可通过insteadof和as关键字解决。3)应避免过度使用trait，保持其单一职责，以优化性能和提高代码可维护性。

什么是依赖性注入容器（DIC），为什么在PHP中使用一个？Apr 10, 2025 am 09:38 AM

依赖注入容器（DIC）是一种管理和提供对象依赖关系的工具，用于PHP项目中。DIC的主要好处包括：1.解耦，使组件独立，代码易维护和测试；2.灵活性，易替换或修改依赖关系；3.可测试性，方便注入mock对象进行单元测试。

与常规PHP阵列相比，解释SPL SplfixedArray及其性能特征。Apr 10, 2025 am 09:37 AM

SplFixedArray在PHP中是一种固定大小的数组，适用于需要高性能和低内存使用量的场景。1)它在创建时需指定大小，避免动态调整带来的开销。2)基于C语言数组，直接操作内存，访问速度快。3)适合大规模数据处理和内存敏感环境，但需谨慎使用，因其大小固定。

PHP如何安全地上载文件？Apr 10, 2025 am 09:37 AM

PHP通过$\_FILES变量处理文件上传，确保安全性的方法包括：1.检查上传错误，2.验证文件类型和大小，3.防止文件覆盖，4.移动文件到永久存储位置。

什么是无效的合并操作员（??）和无效分配运算符（?? =）？Apr 10, 2025 am 09:33 AM

JavaScript中处理空值可以使用NullCoalescingOperator(??)和NullCoalescingAssignmentOperator(??=)。1.??返回第一个非null或非undefined的操作数。2.??=将变量赋值为右操作数的值，但前提是该变量为null或undefined。这些操作符简化了代码逻辑，提高了可读性和性能。

See all articles