织梦DEDECMS使用PHPEXCEL将内容数据导出到excel的方法

require_once (DEDEINC . '/common.func.php');

if ($action == 'allexport') {

include_once DEDEINC . '/PHPExcel.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();

$objActSheet = $objPHPExcel->getActiveSheet();

// Set document properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")
->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")
->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")
->setCategory("Test result file");
//www.bnxb.com 笨牛网
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'id')
->setCellValue('B1', '标题')
->setCellValue('C1', '排序')
->setCellValue('D1', '出版时间')
->setCellValue('E1', '关键词')
->setCellValue('F1', '简介')
->setCellValue('G1', '发布时间')
->setCellValue('H1', '会员id')
->setCellValue('I1', 'flag')
->setCellValue('J1', '栏目id');
$query = "Select * From `dede_archives` ";
$dsql->SetQuery($query);
$dsql->Execute();

$index = 1;

while ($row = $dsql->GetArray()) {

$index++;
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A' .
$index, $row['id'])->setCellValue('B' .
$index, iconv("gb2312","utf-8",$row['title']))->setCellValue('C' .
$index, $row['sortrank'])->setCellValue('D' .
$index, "2015-7-23")->setCellValueExplicit('E' .
$index, iconv("gb2312","utf-8",$row['keywords']))->setCellValue('F' .
$index, iconv("gb2312","utf-8",$row['description']))->setCellValue('G' .
$index, gmdate("Y-m-d",$row['pubdate']))->setCellValue('H' .
$index, $row['mid'])->setCellValue('I' .
$index, $row['flag'])->setCellValue('J' .
$index, $row['typeid']);
}

// Rename worksheetwww.bnxb.com
$objPHPExcel->getActiveSheet()->setTitle('Simple');

// 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 (Excel5)
header('Content-Type: application/vnd.ms-excel');

header('Content-Disposition: attachment;filename="list.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory :: createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;

}