java框架excel表格导出,destoon框架导出EXCEL表格有用请拿走~~

第一步现将PHPExcel插件类库下载下来并放在项目的目录里(下面的实例是放在了根目录下的vendor下)

第二步实现方法如下

function exportExam($itemids){

//引用

require_once DT_ROOT.&＃39;/vendor/PHPExcel/PHPExcel.php&＃39;;

$PHPExcel &＃61; new PHPExcel(); //实例化PHPExcel类&＃xff0c;类似于在桌面上新建一个Excel表格

$PHPSheet &＃61; $PHPExcel->getActiveSheet(); //获得当前活动sheet的操作对象

$PHPSheet->setTitle(&＃39;报名表&＃39;); //给当前活动sheet设置名称

//表头

//给当前活动sheet填充数据&＃xff0c;数据填充是按顺序一行一行填充的&＃xff0c;假如想给A1留空&＃xff0c;可以直接setCellValue(‘A1’,’’);

$PHPSheet->setCellValue(&＃39;A1&＃39;, &＃39;&＃39;列名称1&＃39;)

->setCellValue(&＃39;B1&＃39;, &＃39;&＃39;列名称2&＃39;)

->setCellValue(&＃39;C1&＃39;, &＃39;&＃39;列名称3&＃39;)

->setCellValue(&＃39;D1&＃39;, &＃39;&＃39;列名称4&＃39;)

->setCellValue(&＃39;E1&＃39;, &＃39;列名称5&＃39;)

;

$members &＃61; 这是从数据库查询到的数据;

foreach ($members as $k &＃61;> $v) {

$cell &＃61; $k &＃43; 2;

$PHPSheet->setCellValue(&＃39;A&＃39; . $cell, $v[&＃39;id&＃39;])

->setCellValue(&＃39;B&＃39; . $cell, $v[&＃39;id&＃39;])

->setCellValue(&＃39;C&＃39; . $cell, $v[&＃39;id&＃39;])

->setCellValue(&＃39;D&＃39; . $cell, $v[&＃39;id&＃39;])

->setCellValue(&＃39;E&＃39; . $cell, $v[&＃39;id&＃39;])

;

}

//这是设置列D的宽度

$PHPSheet->getColumnDimension(&＃39;D&＃39;)->setWidth(20);

// 生成2007excel格式的xlsx文件

$PHPWriter &＃61; \PHPExcel_IOFactory::createWriter($PHPExcel, &＃39;Excel5&＃39;);

$outFileName &＃61; &＃39;excel表名称-&＃39;.date(&＃39;YmdHis&＃39;);

$outFileName &＃61; iconv(&＃39;UTF-8&＃39;,&＃39;GBK&＃39;,$outFileName);

header(&＃39;Content-Type: text/html;charset&＃61;utf-8&＃39;);

header(&＃39;Content-Type: xlsx&＃39;);

header(&＃39;Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet&＃39;);

header(&＃39;Content-Disposition: attachment;filename&＃61;"&＃39;.$outFileName.&＃39;.xls"&＃39;);

header(&＃39;Cache-Control: max-age&＃61;0&＃39;);

$PHPWriter->save("php://output");

break;

}