arogachev/yii2-excel

ActiveRecord import and export based on PHPExcel for Yii 2 framework

Maintainers

Details

github.com/arogachev/yii2-excel

Homepage

Source

Issues

Installs: 74 752

Dependents: 1

Suggesters: 0

Security: 0

Stars: 64

Watchers: 13

Forks: 25

Open Issues: 30

Type:yii2-extension

0.1.1 2016-07-23 06:45 UTC

Requires

Requires (Dev)

BSD-3-Clause e8321b9b3e121323a6f6e8cc1df14d72dd6eacc3

  • Alexey Rogachev <arogachev90.woop@gmail.com>

excelimportActive RecordexportPHPExcelyii2

This package is not auto-updated.

Last update: 2024-12-21 17:48:38 UTC

README

ActiveRecord import and export based on PHPExcel for Yii 2 framework.

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.

The important notes:

  • 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.

Latest Stable Version Total Downloads Latest Unstable Version License

Installation

The preferred way to install this extension is through composer.

Either run

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

or add

"arogachev/yii2-excel": "*"

to the require section of your composer.json file.

Running import

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

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