yiiman/yii-lib-excel

Composer 安装命令：


                            composer require yiiman/yii-lib-excel

包简介

Simple library for parse and manipulate excel files

Yii2 Excel Functions and class based PHPExcel package

composer require yiiman/yii-lib-excel

Create component from YiiMan\YiiLibExcel\Excel class

    'components'=>
    [
    'excel'=>[
        'class'=>\YiiMan\YiiLibExcel\Excel::class
    ]  
];

Yii::$app->excel
    ->loadFile(__DIR__.'/list.xlsx')
    ->freezeFirstRow()
    ->setValue(1,2,'Hello excel')
    ->saveAndGetFilePath();