How to export Excel using PHPExcel in Yii

This article mainly introduces how to use PHPExcel to export Excel in Yii, which involves settings for PHPExcel and Related File Modification skills in Yii. It has some reference value, for more information, see

This article mainly introduces how to use PHPExcel to export Excel in Yii, which involves settings for PHPExcel and Related File Modification skills in Yii. It has some reference value, for more information, see

This document describes how to use PHPExcel to export an Excel file in Yii. Share it with you for your reference. The specific analysis is as follows:

Recently I have been studying the Yii framework of PHP. I like it very much. When I encountered the problem of exporting Excel, I studied it and found the following method.

1. First Add a reference to PHPExcel in cofig/main. php. My method is as follows:

The Code is as follows:

// Autoloading model and component classes
'Import' => array (
/* 'Application. modules. srbac. controllers. SBaseController ',*/
'Application. models .*',
'Application. components .*',
'Application. extensions. phpexcel .*',
),

2. Copy the entire PHPExcel directory to the "protected/extensions/" directory of the project.

3. Modify the Autoloader. php file in the PHP Excel Code directory according to the following code:

The Code is as follows:

Public static function Register (){
/* If (function_exists ('_ autoload ')){
// Register any existing autoloader function with SPL, so we don't get any clashes
Spl_autoload_register ('_ autoload ');
}
// Register ourselves with SPL
Return spl_autoload_register (array ('phpexcel _ Autoloader ', 'load '));*/
$ Functions = spl_autoload_functions ();
Foreach ($ functions as $ function)
Spl_autoload_unregister ($ function );
$ Functions = array_merge (array ('phpexcel _ Autoloader ', 'load'), $ functions );
Foreach ($ functions as $ function)
$ X = spl_autoload_register ($ function );
Return $ x;
} // Function Register ()

In the above function, the original code is commented out.

4. The following code outputs Excel and some common attribute settings. In your Controller, the Code is as follows:

The Code is as follows:

$ ObjectPHPExcel = new PHPExcel ();
$ ObjectPHPExcel-> setActiveSheetIndex (0 );

Ob_end_clean ();
Ob_start ();

Header ('content-Type: application/vnd. ms-excel ');
Header ('content-Disposition: attachment; filename = "'. 'xiaoqiang-'. date (" Ymj ").'.xls "');
$ ObjWriter = PHPExcel_IOFactory: createWriter ($ objectPHPExcel, 'excel5 ');
$ ObjWriter-> save ('php: // output ');

I hope this article will help you design php programs based on the Yii framework.

,