PHPExcel下载地址http://www.yiiframework.com/extension/phpexcel
将下载的PHPExcel压缩包解压到Yii Framework目录framework\vendors下
代码如下
/**
* 将数据导出到Excel
*/
public function actionExport()
{
//取要导出到Excel的数据
$criteria &＃61; $this->_getCriteria();
$data &＃61; Statistics::model()->findAll($criteria);
// 获取PHPExcel引用路径
$phpExcelPath &＃61; Yii::getPathOfAlias(&＃39;system.vendors&＃39;);
// 关闭YII的自动加载功能&＃xff0c;改用手动加载&＃xff0c;否则会出错&＃xff0c;PHPExcel有自己的自动加载功能
// YII框架对于组件的自动加载&＃xff0c;要求类名与文件名一致&＃xff1b;
// 而PHPExcel类对应的文件名包含了上级目录名称&＃xff0c;如&＃xff1a;IOFactory类对应的文件名为PHPExcel_IOFactory.php
spl_autoload_unregister(array(&＃39;YiiBase&＃39;,&＃39;autoload&＃39;));
include($phpExcelPath . DIRECTORY_SEPARATOR . &＃39;PHPExcel.php&＃39;);
//下面是Excel数据导出处理逻辑
$objPHPExcel &＃61; PHPExcel_IOFactory::load(&＃39;./content/template/report.xlsx&＃39;);
$objPHPExcel->getProperties()->setCreator("Kalman")
->setTitle("统计报表")
->setSubject("统计报表")
->setDescription("统计报表");
$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;);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue(&＃39;A25&＃39;, &＃39;123456&＃39;);
$objPHPExcel->getActiveSheet()->setTitle(&＃39;report&＃39;);
// Excel打开后显示的工作表
$objPHPExcel->setActiveSheetIndex(0);
//通浏览器输出Excel报表
header(&＃39;Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet&＃39;);
header(&＃39;Content-Disposition: attachment;filename&＃61;"report.xlsx"&＃39;);
header(&＃39;Cache-Control: max-age&＃61;0&＃39;);
$objWriter &＃61; PHPExcel_IOFactory::createWriter($objPHPExcel, &＃39;Excel2007&＃39;);
$objWriter->save(&＃39;php://output&＃39;);
Yii::app()->end();
//恢复Yii自动加载功能
spl_autoload_register(array(&＃39;YiiBase&＃39;,&＃39;autoload&＃39;));
}
* 将数据导出到Excel
*/
public function actionExport()
{
//取要导出到Excel的数据
$criteria &＃61; $this->_getCriteria();
$data &＃61; Statistics::model()->findAll($criteria);
// 获取PHPExcel引用路径
$phpExcelPath &＃61; Yii::getPathOfAlias(&＃39;system.vendors&＃39;);
// 关闭YII的自动加载功能&＃xff0c;改用手动加载&＃xff0c;否则会出错&＃xff0c;PHPExcel有自己的自动加载功能
// YII框架对于组件的自动加载&＃xff0c;要求类名与文件名一致&＃xff1b;
// 而PHPExcel类对应的文件名包含了上级目录名称&＃xff0c;如&＃xff1a;IOFactory类对应的文件名为PHPExcel_IOFactory.php
spl_autoload_unregister(array(&＃39;YiiBase&＃39;,&＃39;autoload&＃39;));
include($phpExcelPath . DIRECTORY_SEPARATOR . &＃39;PHPExcel.php&＃39;);
//下面是Excel数据导出处理逻辑
$objPHPExcel &＃61; PHPExcel_IOFactory::load(&＃39;./content/template/report.xlsx&＃39;);
$objPHPExcel->getProperties()->setCreator("Kalman")
->setTitle("统计报表")
->setSubject("统计报表")
->setDescription("统计报表");
$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;);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue(&＃39;A25&＃39;, &＃39;123456&＃39;);
$objPHPExcel->getActiveSheet()->setTitle(&＃39;report&＃39;);
// Excel打开后显示的工作表
$objPHPExcel->setActiveSheetIndex(0);
//通浏览器输出Excel报表
header(&＃39;Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet&＃39;);
header(&＃39;Content-Disposition: attachment;filename&＃61;"report.xlsx"&＃39;);
header(&＃39;Cache-Control: max-age&＃61;0&＃39;);
$objWriter &＃61; PHPExcel_IOFactory::createWriter($objPHPExcel, &＃39;Excel2007&＃39;);
$objWriter->save(&＃39;php://output&＃39;);
Yii::app()->end();
//恢复Yii自动加载功能
spl_autoload_register(array(&＃39;YiiBase&＃39;,&＃39;autoload&＃39;));
}
京公网安备 11010802041100号