在YII里面使用PHPExcelexternallibrary

首先修改PHPEXCEL /Autoloader.php的文件

public static function Load($pObjectName){ if ((class_exists($pObjectName)) || (strpos($pObjectName, &＃39;PHPExcel&＃39;) &＃61;&＃61;&＃61; False)) { return false;} // this is the code that shows what I am saying $pObjectFilePath &＃61; PHPEXCEL_ROOT.str_replace(&＃39;_&＃39;,DIRECTORY_SEPARATOR,$pObjectName).&＃39;.php&＃39;;if ((file_exists($pObjectFilePath) &＃61;&＃61;&＃61; false) || (is_readable($pObjectFilePath) &＃61;&＃61;&＃61; false)) { return false;} require($pObjectFilePath);

} // function Load()

然后

class TestController extends Controller{ // no layouts here public $layout &＃61; &＃39;&＃39;;public function actionTest() { // // get a reference to the path of PHPExcel classes $phpExcelPath &＃61; Yii::getPathOfAlias(&＃39;ext.phpexcel.Classes&＃39;);// Turn off our amazing library autoload spl_autoload_unregister(array(&＃39;YiiBase&＃39;,&＃39;autoload&＃39;)); // // making use of our reference, include the main class // when we do this, phpExcel has its own autoload registration // procedure (PHPExcel_Autoloader::Register();) include($phpExcelPath . DIRECTORY_SEPARATOR . &＃39;PHPExcel.php&＃39;);// Create new PHPExcel object $objPHPExcel &＃61; new PHPExcel();// Set properties $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") ->setLastModifiedBy("Maarten Balliauw") ->setTitle("PDF Test Document") ->setSubject("PDF Test Document") ->setDescription("Test document for PDF, generated using PHP classes.") ->setKeywords("pdf php") ->setCategory("Test result file");// Add some data $objPHPExcel->setActiveSheetIndex(0) ->setCellValue(&＃39;A1&＃39;, &＃39;Hello&＃39;) ->setCellValue(&＃39;B2&＃39;, &＃39;world!&＃39;) ->setCellValue(&＃39;C1&＃39;, &＃39;Hello&＃39;) ->setCellValue(&＃39;D2&＃39;, &＃39;world!&＃39;);// Miscellaneous glyphs, UTF-8 $objPHPExcel->setActiveSheetIndex(0) ->setCellValue(&＃39;A4&＃39;, &＃39;Miscellaneous glyphs&＃39;) ->setCellValue(&＃39;A5&＃39;, &＃39;éàèùâêîôûëïüÿäöüç&＃39;);// Rename sheet $objPHPExcel->getActiveSheet()->setTitle(&＃39;Simple&＃39;);// Set active sheet index to the first sheet, // so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0);// Redirect output to a client’s web browser (Excel2007) header(&＃39;Content-Type: application/pdf&＃39;);header(&＃39;Content-Disposition: attachment;filename&＃61;"01simple.pdf"&＃39;);header(&＃39;Cache-Control: max-age&＃61;0&＃39;);$objWriter &＃61; PHPExcel_IOFactory::createWriter($objPHPExcel, &＃39;PDF&＃39;);$objWriter->save(&＃39;php://output&＃39;);Yii::app()->end();// // Once we have finished using the library, give back the // power to Yii... spl_autoload_register(array(&＃39;YiiBase&＃39;,&＃39;autoload&＃39;));} }