yiiman/yii-lib-excel

Simple library for parse and manipulate excel files

dev-master 2024-01-28 11:20 UTC

Requires

• php: ^8.0
• ext-xml: *
• ext-zip: *
• larapack/dd: 1.*
• phpoffice/phpspreadsheet: 2.0.0

BSD-3-Clause

• yiiman-dev

README

Yii2 Excel Functions and class based PHPExcel package

Install

composer require yiiman/yii-lib-excel

Usage

Create component from YiiMan\YiiLibExcel\Excel class

Create Component In Yii2

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

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