PHPackages                             dbrisinajumi/tlbexcelview - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [File & Storage](/categories/file-storage)
4. /
5. dbrisinajumi/tlbexcelview

ActiveYii-extension[File & Storage](/categories/file-storage)

dbrisinajumi/tlbexcelview
=========================

Another Yii CGridView-to-Excel exporter using PHPExcel, based on EExcelView Yii extension

092PHP

Since Aug 22Pushed 9mo ago4 watchersCompare

[ Source](https://github.com/DBRisinajumi/tlbExcelView)[ Packagist](https://packagist.org/packages/dbrisinajumi/tlbexcelview)[ RSS](/packages/dbrisinajumi-tlbexcelview/feed)WikiDiscussions master Synced 2w ago

READMEChangelogDependenciesVersions (2)Used By (0)

tlbExcelView
============

[](#tlbexcelview)

Another Yii CGridView-to-Excel exporter using [PHPExcel](http://phpexcel.codeplex.com/), based on [EExcelView Yii extension](http://yiiframework.com/extension/eexcelview/)

Tested with:

- Yii 1.1.10
- PHPExcel 1.7.7

Homepage
--------

[](#homepage)

Installation
------------

[](#installation)

- Create a folder named **phpexcel** in your **/protected/extensions** folder
- Download PHPExcel from
- Unpack its **Classes** folder in your **/protected/extensions/phpexcel**
- Copy the **tlbExcelView.php** file in your widgets directory, in this example **/protected/components/widgets**

Features
--------

[](#features)

- Automatic formatting of header, body and footer
- Automatic formatting of numbers
- Automatic sum in the footer
- Automatic page formatting (with page header and footer, automatic print area…)
- Nearly all properties can be overridden.

Example of use
--------------

[](#example-of-use)

This is an example of use of tlbExcelView in the controller and view:

### Controller

[](#controller)

Based on the standard Gii / Giix admin action

```