mk-j/php_xlsxwriter导出_米醋屋个人技术博客

封装。

<?php

namespace App\Common\Tool;

class Export
	{

/**
     *
     * @desc  大批量快速导出数据
     * @param string $file_name
     * @param array  $header
     * @param array  $rows
     */
    public static function export($file_name='export',$header=[],$rows = [])
    {
        $filename = $file_name.".xlsx";
        header('Content-disposition: attachment; filename="' . \XLSXWriter::sanitize_filename($filename) . '"');
        header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        header('Content-Transfer-Encoding: binary');
        header('Cache-Control: must-revalidate');
        header('Pragma: public');

$writer = new \XLSXWriter();
        $writer->setAuthor('Some Author');
        $writer->writeSheetRow('Sheet1', array_values($header));
        //$writer->writeSheetHeader('Sheet1', array_values($header));
        foreach ($rows as $row) {
            $temp = [];
            foreach ($header as $k => $v) {
                $temp[] = $row[$k] ?? '';
            }
            //dd($temp);
            $writer->writeSheetRow('Sheet1', $temp);
        }

$writer->writeToStdOut();

//echo $writer->writeToString();
        exit(0);
    }
}

使用

$mod = new \App\Model\Factory\CrossBorder();
        $list = $mod->getList($page,$limit);
        // return  $res;

$header = [
          "dealer_network"          =>  "网络",
          "dealer_division"         =>  "营销中心",
          "audit_state"             =>  "状态",
        ];

Export::export('厂端-越界申诉导出',$header,$list);
        die;

注:原创不易,转载请注明出处( http://www.micuu.com/new/1974.html )，本站所有资源来源于网络收集，如有侵权请联系QQ245557979进行清除。