~~~ /** * 商品庫存excel導出 */ public function excel() { //查詢出要導出的數據 $data = $this->request->param('ids/a'); //接收參數（用戶勾選多個id） $model = new StockModel(); $res = $model->excelSelect($data); //查數據 date_default_timezone_set('Asia/shanghai'); //設置時區，否則有警告 $objPHPExcel = new PHPExcel(); //composer下來的 // 設置文件屬性 $objPHPExcel->getProperties()->setCreator("xiGua")//設置作者 ->setLastModifiedBy("xiGua") //設置最后一個修改的人 ->setTitle("庫存報表") //設置標題 ->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");//EXCEL 類別 $objPHPExcel->setActiveSheetIndex(0) ->setCellValue("A1", '通馳庫存') ->mergeCells("A1:F1"); //合并單元格 //設置行第一行高度為25px $objPHPExcel->getActiveSheet()->getRowDimension(1)->setRowHeight(25); $objPHPExcel->getActiveSheet() //設置行高 居中 ->getStyle('A1')->getAlignment() ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //添加數據 $objPHPExcel->setActiveSheetIndex(0) //指定在當前活動的表格中添加 ->setCellValue('A2', '品牌') //在xx中插入 ->setCellValue('B2', '型號') ->setCellValue('C2', '進價') ->setCellValue('D2', '進貨數量') ->setCellValue('E2', '現庫存') ->setCellValue('F2', '進貨時間'); $num_key = 3; //第1行是合并后的標題，第2行是列名，所以數據需要從第3行開始 foreach($res as $value){ $num_key++; $objPHPExcel->setActiveSheetIndex(0) //庫中查出來的數據放這 ->setCellValue('A'.$num_key, $value['brand']) ->setCellValue('B'.$num_key, $value['version']) ->setCellValue('C'.$num_key, $value['stock_bid']) ->setCellValue('D'.$num_key, $value['num']) ->setCellValue('E'.$num_key, $value['remnant_inventory']) ->setCellValue('F'.$num_key, date("Y-m-d H:i:s",$value['update_time'])); } // Rename worksheet $objPHPExcel->getActiveSheet()->setTitle('標簽1'); // Set active sheet index to the first sheet, so Excel opens this as the first sheet $objPHPExcel->setActiveSheetIndex(0); ob_clean(); // Redirect output to a client’s web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="通馳庫存.xls"'); //下載文件名字 header('Cache-Control: max-age=0'); // If you're serving to IE 9, then the following may be needed header('Cache-Control: max-age=1'); // If you're serving to IE over SSL, then the following may be needed header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1 header ('Pragma: public'); // HTTP/1.0 $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); //exit; } ~~~