wxksj
- wxksj 评论了扩展 phpexcel-从数据库导出Excel
1、下载PHPExcel解压到extensions,修改PHPExcel/PHPExcel_Autoloader解决自动载入问题
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(array('PHPExcel_Autoloader', 'Load')), $functions); foreach ($functions as $function) $x = spl_autoload_register($function); return $x; } // function Register()
2、修改config/main.php
'import' => array( 'application.models.*', 'application.components.*', 'application.extensions.*', ),
3、创建components/Excel.php
class Excel { private $phpExcel; function __construct(PHPExcel $phpExcel) { $this->phpExcel = $phpExcel; } /** * 根据文件名获取PHPExcel对象 * @param $file * @return PHPExcel */ public function getByFile($file) { $reader = PHPExcel_IOFactory::createReader('Excel5'); $excel = $reader->load($file); return $excel; } }
4、使用
$excel = new Excel(new PHPExcel());
- wxksj 回复了话题 大家学习yii入门花了多长时间
:L3天
- wxksj 评论了教程 由数据库控制的CMenu菜单
$menu = array( 'id' => 'nav', 'activeCssClass'=>'selected', 'linkLabelWrapper'=>null, 'htmlOptions'=>array('class'=>'topNav'), 'items'=>$items ); $this->widget('zii.widgets.CMenu', $menu);
把这个写到view里面去