phpspread使用完整示例

//导出
    public function export(Request $request)
    {
        $data = $request->all();
        $pageName = $data['pageName'] ?? '';
        $options['webConfigKV'] = WebConfigService::S()->getWebConfigKV();
        $tpl = $data['tpl'] ?? Project::$tplInfo;
        $filename = $options['webConfigKV']['tpl'][$tpl] . '_' . date('Y-m-d');
        if (Str::startsWith($pageName, 'check')) {
            $header = [
                'id' => 'id',
                'control' => '控制项',
                'desc' => '描述',
                'purpose' => '检查目的',
                'tab' => '类别',
                'tabCn' => '类别中文',
                'law' => '法律依据',
                'standard' => '标准依据',
                'disk' => '判断规则',
                'dangerConditions' => '风险条件',
                'source' => '判断依据',
                'conditions' => '条件',
            ];
            $columnWidth = [
                'B' => 100,
                'C' => 100,
                'D' => 100,
                'G' => 100,
                'H' => 100,
                'I' => 100,
            ];
        } elseif (Str::startsWith($pageName, 'question')) {
            $header = [
                'id' => 'id',
                'title' => '问题',
                'type' => '类型',
                'typeCn' => '类型中文',
                'parentId' => '父id',
                'conditions' => '存在条件',
                'field' => '字段',
                'tab' => '类别',
                'tabCn' => '类别中文',
                'replace' => '标题替换',
                'level' => '级别',
                'isRequired' => '必填',
                'isInline' => '单行',
            ];
            $columnWidth = [
                'B' => 120,
            ];
        }
        switch ($pageName) {
            case 'checkList':
                $filename = '数据盘点检查库-' . $filename;
                LibraryCheckListService::S()->exportCheck(Project::$processList, $tpl, $filename, $header, $columnWidth);
                break;
            case 'checkSystem':
                $filename = '体系评估检查库-' . $filename;
                LibraryCheckSystemService::S()->exportCheck(Project::$processSystem, $tpl, $filename, $header, $columnWidth);
                break;
            case 'questionList':
                $filename = '数据盘点问题库-' . $filename;
                LibraryQuestionListService::S()->exportQuestion(Project::$processList, $tpl, $filename, $header, $columnWidth);
                break;
            case 'questionSystem':
                $filename = '体系评估问题库-' . $filename;
                LibraryQuestionSystemService::S()->exportQuestion(Project::$processSystem, $tpl, $filename, $header, $columnWidth);
                break;
        }
        return;
    }

public function exportQuestion($theType, $tpl, $filename, $header, $columnWidth)
    {
        $data = [];
        $headerFields = array_keys($header);
        $headerTitles = array_values($header);

        $questions = $this->questionModel::where('isRemoved', 0)
            ->where('tpl', $tpl)
            ->get();
        $options = ProjectProcessList::getMap($tpl)
            + ProjectProcessSystem::getMap($tpl)
            + LibraryQuestion::getMap();

        $i = 0;
        foreach ($questions as &$question) {
            $question->unpack();
            $type = $question->type;
            $question->typeCn = $options['answer'][$type];
            $question->tabCn = $options[$theType . 'Tab'][$question->tab] ?? $question->tab;
            foreach ($headerFields as $field) {
                if ($field == 'conditions') {
                    $data[$i][$field] = \Util::libraryJson2Str($question->$field);
                } else if (in_array($field, ['replace'])) {
                    $data[$i][$field] = implode(",", $question->$field);
                } else {
                    $data[$i][$field] = strval($question->$field);
                }
            }
            if (in_array($type, [LibraryQuestion::$answerTable
                , LibraryQuestion::$answerTableDisplay
                , LibraryQuestion::$answerCheckbox
                , LibraryQuestion::$answerRadio])) {
                foreach ($question->answer as $answer) {
                    $i++;
                    foreach ($headerFields as $field) {
                        if($field == 'title') {
                            $data[$i][$field] = ('[' . $answer['key'] . ']' . $answer['val']);
                        } elseif($field == 'type' && isset($answer['type'])) {
                            $data[$i][$field] = $answer['type'];
                        } elseif($field == 'field' && isset($answer['field'])) {
                            $data[$i][$field] = $answer['field'];
                        } elseif($field == 'isRequired' && isset($answer['isRequired'])) {
                            $data[$i][$field] = strval($answer['isRequired']);
                        } else {
                            $data[$i][$field] = '';
                        }
                    }
                }
            }
            $i++;
        }
        return \Util::export($headerTitles, $data, $filename, $columnWidth);
    }

public static function export($headerTitles, $data, $filename, $columnWidth = [])
    {
        $spreadsheet = new Spreadsheet();
        $titleArr[] = $headerTitles;
        $result = array_merge($titleArr, $data);

        $spreadsheet->getActiveSheet()->getDefaultColumnDimension()->setWidth(15);  //默认列宽
        if ($columnWidth) {
            foreach ($columnWidth as $character => $width) {
                $spreadsheet->getActiveSheet()->getColumnDimension($character)->setWidth($width);
            }
        }
        $spreadsheet->getActiveSheet()->getDefaultRowDimension()->setRowHeight(20); //默认行高
        $spreadsheet->getActiveSheet()->fromArray($result);
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment;filename="' . $filename . '.xlsx"');
        header('Cache-Control: max-age=0');

        $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
        ob_end_clean();
        $writer->save('php://output');
        /* 释放内存 */
        $spreadsheet->disconnectWorksheets();
        unset($spreadsheet);
        return;
    }