How Yii uses Phpexcel to import Excel files

1. Download Phpexcel, copy the classes in the compressed package to protected/extensions and modify it to phpexcel.

2. Modify YII configuration file config/main.php [PHP]View Plaincopy

1. ' Import ' = =Array (
2. ' Application.extensions.PHPExcel.PHPExcel ',
3. ),

(The following methods to deal with Phpexcel AutoLoad and yii autoload conflict of choice, recommended 4th, most consistent with the YII standard)
3.1, modify the Phpexcel in the autoloader.php [PHP]View Plaincopy

1. Phpexcel_autoloader::register ();
2. Phpexcel_shared_zipstreamwrapper::register ();

Revision changed to [PHP]View Plaincopy

1. Yii::registerautoloader (Array (' Phpexcel_autoloader ',' Register '), true);

3.2. Modify the autoloader.php file in the Phpexcel code directory according to the following code [PHP]View Plaincopy

2. Public static function Register () {
4. /* 
6. if (function_exists (' __autoload ')) {
8. Register any existing autoloader function with SPL, so we don ' t get any clashes
10. Spl_autoload_register (' __autoload ');
12. }
14. Register ourselves with SPL
16. return Spl_autoload_register (Array (' Phpexcel_autoloader ', ' Load '));
18. */
20. $functions = Spl_autoload_functions ();
22. foreach ( $functions as $function)
24. Spl_autoload_unregister ($function);
26. $functions = array_merge (Array (' phpexcel_autoloader ',' Load '),$functions);
28. foreach ( $functions as $function)
30. $x = Spl_autoload_register ($function);
32. return $x;
34. } //function Register ()

3.3. Use the following code when you need to use Phpexcel [PHP]View Plaincopy

2. $filePath = '/home/public_html/sqt/protected/data/queuesql/company.xls ';
4. Spl_autoload_unregister (Array (' yiibase ', ' autoload '));
6. $phpExcelPath = Yii::getpathofalias (' application.extensions.PHPExcel.PHPExcel ');
8. Include ($phpExcelPath. Directory_separator.  ' iofactory.php ');
10. Spl_autoload_register (Array (' yiibase ', ' autoload '));
12. $PHPExcel = Phpexcel_iofactory::load ( $filePath);

3.4, as long as the set Yii:: $enableIncludePath to False, the third-party class library has the opportunity to execute its own AutoLoad method, and do not need to configure config/main.php, very convenient and flexible [PHP]View Plaincopy

1. Yii::$enableIncludePath = false;
2. Yii::import (' Application.extensions.PHPExcel.PHPExcel ', 1);

-------------------------------------------------------------------------------
Import Excel File method [PHP]View Plaincopy

2. Public function Actionload () {
4. if (isset ($_post[' Submit ')) {
6. $file = cuploadedfile::getinstancebyname (' file '); Get an uploaded file instance
8. if ($file-getType () = = ' application/vnd.ms-excel ') {
10. $excelFile = $file->gettempname (); Get file name
12. //Here is the import Phpexcel package, to use when you add such two sentences, convenient bar
14. Yii::$enableIncludePath = false;
16. Yii::import (' Application.extensions.PHPExcel.PHPExcel ', 1);
18. $phpexcel = new Phpexcel;
20. $excelReader = Phpexcel_iofactory::createreader (' Excel5 ');
22. $phpexcel = $excelReader->load ($excelFile)->getsheet (0); Load a file and get the first sheet
26. $total _line = $phpexcel->gethighestrow ();
28. $total _column = $phpexcel->gethighestcolumn ();
32. For ($row = 2; $row <= $total _line; $row + +) {  
34. $data = Array ();
36. For ($column = ' A '; $column <= $total _column; $column + +) {  
38. $data [] = Trim ($phpexcel->getcell ($column.   $row), GetValue ());
40. }
42. }
44. }
46. }

This article transferred from: http://blog.csdn.net/tinico/article/details/18033575

How Yii uses Phpexcel to import Excel files