TP6导出excel并自定义导出项

最新推荐文章于 2024-08-22 11:49:39 发布

最好_

最新推荐文章于 2024-08-22 11:49:39 发布

阅读量1.3k

点赞数

文章标签： php 开发语言后端

本文链接：https://blog.csdn.net/weixin_47377738/article/details/121185697

版权

ThinkPHP6 phpspreadsheet Excel导出自定义字段数据操作

关键词由CSDN通过智能技术生成

目标：

我们在项目开发中经常会遇到导出excel的需求，下面就利用TP6完成这一需求，并实现自定义导出项。

1、首先我们先利用composer安装我们需要的扩展

composer require phpoffice/phpspreadsheet

2、下面进入愉快的写代码时刻！！

<?php


namespace app\index\controller;

use think\facade\Db;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

/**
 * ClassName: Index
 * Description:
 * Date: 2021-11-06
 * Version:
 */
class Index
{

    /*
     * @param array $fields 字段, eg: ['字段1', '字段2'...]
     * @param string|null $filename 导出文件名
     * */
    public static function export(array $fields = [], string $filename = '123')
    {
        if (!is_array($fields)) {
            return false;
        }
        
        //首先我们先定义号每个字段的含义  键是数据库里的字段名  值是含义
        $field_title = [
            'id' => '编号',
            'username' => '用户名',
            'title' => '标题',
            'desc' => '简介',
            'content' => '内容'
        ];

        $field_res = [];

        //然后根据所需导出的字段组成相应的结果集
        foreach ($fields as $k => $v) {
            $field_res[$k]['title'] = $field_title[$v];
            $field_res[$k]['field'] = $v;
        }

		//查询数据
        $data = Db::name('user')->field($fields)->select()->toArray();
        
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        // sheet title
        $sheet->setTitle($filename);
        $startRow = 1; // 数据起始行
        foreach ($data as $key => $value) {
            foreach ($field_res as $k => $v) {
                $column = Coordinate::stringFromColumnIndex($k + 1);
                if ($key == 0) {
                    $sheet->setCellValue($column . $startRow, $v['title']);
                    $sheet->getColumnDimension($column)->setWidth(20);
                }
                $i = $key + 2; //表格是从2开始的
                //dd($v);
                $sheet->setCellValue($column . $i, $value[$v['field']]);
            }
        }
        $filename = urlencode($filename) . '.xlsx';
        // make file
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header("Content-Disposition: attachment;filename=$filename");
        header('Cache-Control: max-age=0');
        header('Pragma: public');
        $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
        $writer->save('php://output');
        exit;
    }
}

Index::export(['id','username'],'123');