解决php通过phpexcel导出多个sheet时产生的额外空的worksheet

码上驾到

于 2023-10-27 11:32:38 发布

阅读量199

点赞数 1

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

本文链接：https://blog.csdn.net/jiang886789/article/details/134072893

版权

php 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

解决方式就是重置Excel的run方法

<?php

namespace common\services\common;

use moonland\phpexcel\Excel;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use yii\base\InvalidConfigException;


class ErpExcel extends Excel
{
    /**
     * 重置run方法，解决创建多个sheet时，会产生一个额外的空的worksheet
     * @return array|\moonland\phpexcel\multitype|string|void
     * @throws InvalidConfigException
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     */
    public function run()
    {
        if ('export' == $this->mode) {
            $sheet = new Spreadsheet();

            if (!isset($this->models)) {
                throw new InvalidConfigException('Config models must be set');
            }

            if (isset($this->properties)) {
                $this->properties($sheet, $this->properties);
            }

            if ($this->isMultipleSheet) {
                $index = 0;
                $worksheet = [];
                foreach ($this->models as $title => $models) {
                    if (0 === $index) {
                        $activeSheet = $sheet->getActiveSheet();
                        $activeSheet->setTitle($title);
                        $worksheet[$index] = $activeSheet;
                    } else {
                        $sheet->createSheet($index);
                        $sheet->getSheet($index)->setTitle($title);
                        $worksheet[$index] = $sheet->getSheet($index);
                    }
                    $columns = $this->columns[$title] ?? [];
                    $headers = $this->headers[$title] ?? [];
                    $this->executeColumns($worksheet[$index], $models, $this->populateColumns($columns), $headers);
                    ++$index;
                }
            } else {
                $worksheet = $sheet->getActiveSheet();
                $this->executeColumns($worksheet, $this->models, isset($this->columns) ? $this->populateColumns($this->columns) : [], $this->headers ?? []);
            }

            if ($this->asAttachment) {
                $this->setHeaders();
            }
            $this->writeFile($sheet);
            $sheet->disconnectWorksheets();
            unset($sheet);
        } elseif ('import' == $this->mode) {
            if (is_array($this->fileName)) {
                $datas = [];
                foreach ($this->fileName as $key => $filename) {
                    $datas[$key] = $this->readFile($filename);
                }

                return $datas;
            } else {
                return $this->readFile($this->fileName);
            }
        }
    }
}