$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="01simple.xls"');
header('Cache-Control: max-age=0');
$objWriter->save('php://output');//保存的文件不对
$objWriter->save("./ttt.xls");//保存的包含网页信息
可以参考一下
/**
* 导出
*/
public function exportExcel()
{
$data = input('data', '', 'trim,strip_tags');
$dataArr = json_decode($data, true);
if (empty($dataArr)) {
$this->error('没有数据可以导出');
}
$PHPExcel = new \PHPExcel(); //实例化PHPExcel类,类似于在桌面上新建一个Excel表格
$PHPSheet = $PHPExcel->getActiveSheet(); //获得当前活动sheet的操作对象
$PHPSheet->setTitle('导出潜客管理数据'); //给当前活动sheet设置名称
//表头
//给当前活动sheet填充数据,数据填充是按顺序一行一行填充的,假如想给A1留空,可以直接setCellValue(‘A1’,’’);
$PHPSheet->setCellValue('A1', 'ID')
->setCellValue('B1', '线索名称')
->setCellValue('C1', '意向标签')
->setCellValue('D1', '联系人')
->setCellValue('E1', '联系方式')
->setCellValue('F1', '线索来源')
->setCellValue('G1', '跟进阶段')
->setCellValue('H1', '负责人')
->setCellValue('I1', '负责部门')
->setCellValue('J1', '最后跟进时间');
foreach ($dataArr as $k1 => $v1) {
$cell = $k1 + 2;
$PHPSheet->setCellValue('A' . $cell, $v1['id'])
->setCellValue('B' . $cell, $v1['customer_name'])
->setCellValue('C' . $cell, $v1['intention_label'])
->setCellValue('D' . $cell, $v1['contacts'])
->setCellValue('E' . $cell, $v1['contact_us'])
->setCellValue('F' . $cell, $v1['clue_source'])
->setCellValue('G' . $cell, $v1['follow_stage'])
->setCellValue('H' . $cell, $v1['person_charge'])
->setCellValue('I' . $cell, $v1['person_department'])
->setCellValue('J' . $cell, $v1['last_follow_time']);
}
$time = date("Ymd");
$execlpath = './uploads/potenTableExcel/' . $time . '/';
if (!file_exists($execlpath)) {
mkdir($execlpath);
}
$execlpath .= rand_string(12, '', time()) . 'excel.xls';
$PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel2007'); //按照指定格式生成Excel文件,‘Excel2007’表示生成2007版本的xlsx
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header('Content-Disposition:attachment;filename=11111.xlsx');
$PHPWriter->save($execlpath);
$this->success('导出成功,请到任务列表下载');
}