arogachev/yii2-excel

ActiveRecord import and export based on PHPExcel for Yii 2 framework

Yii 2 Excel

ActiveRecord import and export based on PHPExcel for Yii 2 framework., _(*1)

This library is mainly designed to import data, export is in the raw condition (even it's working in basic form), under development and not documented yet., _(*2)

The important notes:, _(*3)

• It uses ActiveRecord models and PHPExcel library, so operating big data requires pretty good hardware, especially RAM. In case of memory shortage I can advise splitting data into smaller chunks.
• This is not just a wrapper on some PHPExcel methods, it's a tool helping import data from Excel in human readable form with minimal configuration.
• This is designed for periodical import.
• The library is more effective when working with multiple related models and complex data structures.

, _(*4)

• Installation
• Import Basics
• Basic import
• Advanced import
• Running import

Installation

The preferred way to install this extension is through composer., _(*5)

Either run, _(*6)

php composer.phar require --prefer-dist arogachev/yii2-excel

or add, _(*7)

"arogachev/yii2-excel": "*"

to the require section of your composer.json file., _(*8)

Running import

if (!$importer->run()) {
    echo $importer->error;

    if ($importer->wrongModel) {
        echo Html::errorSummary($importer->wrongModel);
    }
}