yyky/application/test/controller/Phpexcel.php

<?php
namespace app\test\controller;

use app\common\server\PhpExcel as PhpExcelServer;

class Phpexcel
{
    public function test()
    {
        $s_pes = new PhpExcelServer();
        $title = [
            ['cell' => 'A1', 'value' => '测试1'],
            ['cell' => 'B1', 'value' => '测试2'],
        ];
        $body = [
            [
                'test1' => ['cell' => 'A2', "value" => 2],
                'test2' => ['cell' => 'B2', "value" => 5],
            ],
        ];
        $exportData = [
            'title' => $title,
            'body' => $body,
        ];
        $s_pes->setmararycache();
        $s_pes->getsheetobj($body, $title);
        $s_pes->sevefile('test.xml');
    }

}