PHP excel类使用 下载文件

require_once(DIR_APPLICATION.'controller/PHPExcel/PHPExcel.php');

$objPHPExcel = new PHPExcel();

 

//设置工作页

$objPHPExcel->setActiveSheetIndex(0);

//设置工作页名

$objPHPExcel->getActiveSheet()->setTitle('Questionnaire--ZH');

//设置title

$objPHPExcel->getActiveSheet()

                ->setCellValue('A1', 'Customer Id')

                ->setCellValue('B1', 'Customer Name')

                ->setCellValue('C1', 'Reason')

                ->setCellValue('D1', 'Favorite Product')

                ->setCellValue('E1', 'Propose')

                ->getStyle('A1:E1')

                ->getFont()

                ->getColor()

                ->setARGB(PHPExcel_Style_Color::COLOR_BLUE);

$num = 1;

foreach ($list['zh'] as $key => $val) {

    $num++;

    $objPHPExcel->getActiveSheet()

                ->setCellValue('A'.$num, $val['customer_id'])

                ->setCellValue('B'.$num, $val['customer_name'])

                ->setCellValue('C'.$num, $val['content']['reason'])

                ->setCellValue('D'.$num, $val['content']['favProduct'])

                ->setCellValue('E'.$num, $val['content']['propose'])

}

 

//如果还需要第二个工作页

$sheetIndex = 1;

$objPHPExcel->createSheet();

$objPHPExcel->setActiveSheetIndex($sheetIndex);

$objPHPExcel->getActiveSheet()->setTitle('Questionnaire--'.en);

//以此类推

 

 

header('Content-Type: application/vnd.ms-excel');

header('pragma:public');

header('Content-Disposition: attachment;filename="'.$name.'.xls"');

header('Cache-Control: max-age=0');

header('Content-Type: text/html; charset=utf-8');

 

$objWrite = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');

 

//保存文件

$objWrite->save('php://output');

exit;