thinkphp5导出excel

　　

 1 　　　　　Vendor('PHPExcel.PHPExcel');
 2         $objPHPExcel = new \PHPExcel();
 3         $objPHPExcel->getProperties()->setCreator("Paper Database Center")
 4             ->setLastModifiedBy("Excel Document")
 5             ->setTitle("Excel Document")
 6             ->setSubject("Excel Document")
 7             ->setDescription("Excel Document from Paper Database Center")
 8             ->setKeywords("Excel openxml php")
 9             ->setCategory("Excel export result file");
10         //根据excel坐标，添加数据
11         $objPHPExcel->setActiveSheetIndex(0)
12             ->setCellValue('A1', '序号')
13             ->setCellValue('B1', '标题')
14             ->setCellValue('C1', '作者');
15        $page_info[0] = ['title' => 'a', 'author' => 'b'];
16        //添加表格内容
17         foreach ($page_info as $k => $v) {
18             $num = $k + 2;
19             $objPHPExcel->setActiveSheetIndex(0)
20                 ->setCellValue('A' . $num, ++$k)
21                 ->setCellValue('B' . $num, $v['title'])
22                 ->setCellValue('C' . $num, $v['author']);
23         }
24         // 重命名工作sheet
25         $objPHPExcel->getActiveSheet()->setTitle('export data');
26         // 设置第一个sheet为工作的sheet
27         $objPHPExcel->setActiveSheetIndex(0);
28         ob_end_clean(); //清空缓冲区并关闭输出缓冲
29         header('Content-Type: application/vnd.ms-excel;charset=utf-8');
30         header('Content-Disposition:attachment;filename="export.xls"');
31         //header('Cache-Control: max-age=0');
32         $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
33         $objWriter->save('php://output');

 

posted @ 2018-03-02 09:43  Mr*wang  阅读(75)  评论(0)    收藏  举报