<?php

namespace xmvc;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// composer require phpoffice/phpspreadsheet

/**
 * Excel类
 */
class Excel
{
    /**
     * 构造
     */
    public function __construct()
    {
        ;
    }

    public function test()
    {
        // 创建一个新的电子表格对象
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();

        // 设置单元格的值
        $sheet->setCellValue('A1', 'Hello World !');

        // 创建Xlsx格式的写入器
        $writer = new Xlsx($spreadsheet);

        // 将文件保存到当前目录
        $writer->save(DIR_RUNTIME . '/hello_world.xlsx');
    }
}