eexcelwriter Simple export of dataproviders to xls files.

  1. Requirements
  2. Usage
  3. Resources

EExcelWriter is a component similar to EExcelView, but uses a different library to generate the excel files, leading speed improvements of up to 10 times.

The library used is http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/ , but with a part of it modified to work also on PHP 5.4.

The extension is a work-in-progress, for now it has basic functionality for generating the spreadsheets.

Requirements

Yii 1.1 and above.

Usage

Paste the contents of the repository in your protected directory, make sure that you load components.EExcelWriter in your configuration file. Then simply call the widget in your view files like :

$this->widget('EExcelWriter', array(
    'dataProvider' => $model->search(),
    'title'        => 'EExcelWriter',
    'stream'       => FALSE,
    'fileName'     => 'file.xls',
    'columns'      => array(
        array(
            'header' => 'id',
            'name' => 'ID',
        ),
        'column1',
        'column2',
    ),
));

Resources

As stated, the component uses http://www.bettina-attack.de/jonny/view.php/projects/php_writeexcel/ with some modifications to make it work on PHP 5.4.

Github page for the extension : https://github.com/ascendro/EExcelWriter

1 0
8 followers
1 351 downloads
Yii Version: Unknown
License: LGPL-3.0
Category: Others
Developed by: Alexandru (Ascendro)
Created on: Jan 13, 2014
Last updated: 10 years ago

Downloads

show all

Related Extensions