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 笨牛網(wǎng)
    $objPHPExcel->setActiveSheetIndex(0)
    ->setCellValue('A1', 'id')
    ->setCellValue('B1', '標(biāo)題')
    ->setCellValue('C1', '排序')
    ->setCellValue('D1', '出版時(shí)間')
    ->setCellValue('E1', '關(guān)鍵詞')
    ->setCellValue('F1', '簡(jiǎn)介')
    ->setCellValue('G1', '發(fā)布時(shí)間')
    ->setCellValue('H1', '會(huì)員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;
 
}