php 导出多个excel并输出压缩文件

最新推荐文章于 2025-02-20 15:07:06 发布

xufei_0425

最新推荐文章于 2025-02-20 15:07:06 发布

阅读量3.5k

点赞数 4

分类专栏： php 文章标签： excel php

本文链接：https://blog.youkuaiyun.com/xufei_0425/article/details/83826103

版权

本文介绍了一种使用phpExcel库高效地导出多个Excel文件，并将它们打包成压缩文件的方法，简化了多Excel文件处理的复杂性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

set_time_limit(0);
    ob_end_clean();
    header('Content-Encoding: none');
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename='.$fileName);
    header('Pragma: no-cache');
    header('Expires: 0');

    //查询数据库中唯一的省份
    $distinct_company = C::t('common_usercompany')->fetch_distinct_company_exportall();
    $arr = [];
    $fileNameArr = array();

    //每个省份导出一个excel
    foreach ($distinct_company as $key => $value) {
        $uids = C::t('common_usercompany')->fetch_all_conpany_users($value);
        $detail = '';
        //excel的header头
        $title = array('UID','用户名','member_type'=> '用户类型','field1' => '','mobile' => '', 'company'=>'公司','company_address' => '公司区域','stock_code'=>'公司代码', 'gender' => '', 'birthyear' => '', 'birthmonth' => '', 'birthday' => '',
            'address' => '',  'bio' => '',  'auth_completed' => '是否验证');
        foreach(C::t('common_member_profile_setting')->range() as $v1) {
            if(isset($title[$v1['fieldid']])) {
                $title[$v1['fieldid']] = $v1['title'];
            }
        }

        //如果该省份下有注册的用户,则输出excel表
        if($uids && is_array($uids)) {
            $arr[] = $uids;
            $allprofile = C::t('common_member_profile')->fetch_all($uids);
            $company = C::t('common_usercompany')->fetch_by_province($value);
            $allusername = C::t('common_member')->fetch_all_by_uid($uids);
            $member_types = get_member_type();

            //生成临时文件
            $filename = $company['province'].'.csv';
            $filename = iconv("UTF-8","GBK//IGNORE",$filename);
            $fp = fopen($filename, 'w'

最低0.47元/天解锁文章