fastadmin 导出xls表格导出数据

/**
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx as Wxlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;

        $title=["z_sn"=>"商品编号(*)","z_sxjzt"=>"上下柜状态（*）","z_xgyy"=>"下柜原因（下柜状态，原因必填）","z_shr"=>"审核人(*)","z_txjyy"=>"具体下架原因(*)"];
        $list=[];
        $filename="上柜作业_".date("Y_m_d_H_i_s");
     * 
     * [数据导出]
     * @return [type] [description]
     */
    public function _export($title,$list,$filename) {

        // Create new Spreadsheet object
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        //表头
        //设置单元格内容
        $titCol = 'A';
        foreach ($title as $key => $value) {
            // 单元格内容写入
            $sheet->setCellValue($titCol . '1', $value);
            //$spreadsheet->getActiveSheet()->getColumnDimension($titCol)->setAutoSize(true);
            $spreadsheet->getActiveSheet()->getColumnDimension($titCol)->setWidth(20);
            $spreadsheet->getActiveSheet()->getStyle($titCol . '1')->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);
            $spreadsheet->getActiveSheet()->getStyle($titCol . '1')->getFont()->setBold(true);

            $titCol++;
        }
        $row = 2; // 从第二行开始
        foreach ($list as $item) {
            $dataCol = 'A';
            // 单元格内容写入
            foreach ($title as $key => $value) {
                //$sheet->setCellValue($dataCol . $row, $item[$key]);$dataCol++;
                $sheet->getCell($dataCol . $row)->setValueExplicit($item[$key],\PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING2);$dataCol++;
            }
            $row++;
        }
     
        $name = $filename;
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="' . $name . '.xlsx"');
        header('Cache-Control: max-age=0');
        $writer = new Wxlsx($spreadsheet);
        $writer->save('php://output');
        //删除清空：
        $spreadsheet->disconnectWorksheets();
     
    }

快捷键：daochuxls

源：PHP

sublime_text格式

<snippet>
    <content><![CDATA[
/**
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx as Wxlsx;
use PhpOffice\PhpSpreadsheet\IOFactory;

        \$title=["z_sn"=>"商品编号(*)","z_sxjzt"=>"上下柜状态（*）","z_xgyy"=>"下柜原因（下柜状态，原因必填）","z_shr"=>"审核人(*)","z_txjyy"=>"具体下架原因(*)"];
        \$list=[];
        \$filename="上柜作业_".date("Y_m_d_H_i_s");
     * 
     * [数据导出]
     * @return [type] [description]
     */
    public function _export(\$title,\$list,\$filename) {

        // Create new Spreadsheet object
        \$spreadsheet = new Spreadsheet();
        \$sheet = \$spreadsheet->getActiveSheet();
        //表头
        //设置单元格内容
        \$titCol = 'A';
        foreach (\$title as \$key => \$value) {
            // 单元格内容写入
            \$sheet->setCellValue(\$titCol . '1', \$value);
            //\$spreadsheet->getActiveSheet()->getColumnDimension(\$titCol)->setAutoSize(true);
            \$spreadsheet->getActiveSheet()->getColumnDimension(\$titCol)->setWidth(20);
            \$spreadsheet->getActiveSheet()->getStyle(\$titCol . '1')->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);
            \$spreadsheet->getActiveSheet()->getStyle(\$titCol . '1')->getFont()->setBold(true);

            \$titCol++;
        }
        \$row = 2; // 从第二行开始
        foreach (\$list as \$item) {
            \$dataCol = 'A';
            // 单元格内容写入
            foreach (\$title as \$key => \$value) {
                //\$sheet->setCellValue(\$dataCol . \$row, \$item[\$key]);\$dataCol++;
                \$sheet->getCell(\$dataCol . \$row)->setValueExplicit(\$item[\$key],\PhpOffice\PhpSpreadsheet\Cell\DataType::TYPE_STRING2);\$dataCol++;
            }
            \$row++;
        }
     
        \$name = \$filename;
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="' . \$name . '.xlsx"');
        header('Cache-Control: max-age=0');
        \$writer = new Wxlsx(\$spreadsheet);
        \$writer->save('php://output');
        //删除清空：
        \$spreadsheet->disconnectWorksheets();
     
    }
]]></content>
   <tabTrigger>daochuxls(fastadmin 导出xls表格导出数据)</tabTrigger>
   <scope></scope>
</snippet>