function export(){
$data=!empty($_POST) ? $_POST : $_GET;
$ser="";
$where=array("name"=>"%{$_POST["name"]}%","tel"=>"%{$_POST["tel"]}%","kemu"=>"%{$_POST["kemu"]}%");
//$where=array();
if(!empty($data["chenggong"])){
$ser.="/chenggong/{$data["chenggong"]}";
$where["chenggong"]=$data["chenggong"];
}
if(!empty($data["start"])){
$ser.="/start/{$data["start"]}";
$where["start"]=$data["start"];
}
if(!empty($data["tuijianschool"])){
$ser.="/tuijianschool/{$data["tuijianschool"]}";
$where["tuijianschool"]=$data["tuijianschool"];
}
if(!empty($data["banbie"])){
$ser.="/banbie/{$data["banbie"]}";
$where["banbie"]=$data["banbie"];
}
$model=D("content");
$OrdersData=$model->where($where)->order('start desc')->limit($page->limit)->select();
include "classes/PHPExcel.php";
// Create new PHPExcel object
$objPHPExcel=new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("ctos")
->setLastModifiedBy("ctos")
->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");
//set width
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(10);
//$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(10);
//设置行高度
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(22);
$objPHPExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
//set font size bold
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//设置水平居中
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// $objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->mergeCells('A1:J1');
// set table header content
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1',iconv("UTF-8", "UTF-8",'邦杰外语课程汇总 时间:'.date('Y-m-d H:i:s')))
->setCellValue('A2',iconv("UTF-8", "UTF-8",'咨询日期'))
->setCellValue('B2',iconv("UTF-8", "UTF-8",'科目'))
->setCellValue('C2',iconv("UTF-8", "UTF-8",'课程级别'))
->setCellValue('D2',iconv("UTF-8", "UTF-8",'班别'))
->setCellValue('E2',iconv("UTF-8", "UTF-8",'学员姓名'))
->setCellValue('F2',iconv("UTF-8", "UTF-8",'性别'))
->setCellValue('G2',iconv("UTF-8", "UTF-8",'学员手机'))
->setCellValue('H2',iconv("UTF-8", "UTF-8",'推荐校区'))
->setCellValue('I2',iconv("UTF-8", "UTF-8",'接电员码'))
->setCellValue('J2',iconv("UTF-8", "UTF-8",'联系状态'));
// ->setCellValue('K2', '接电员码');
// Miscellaneous glyphs, UTF-8
for($i=0;$i<count($OrdersData)-1;$i++){
$objPHPExcel->getActiveSheet(0)->setCellValue('A'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['start']));
$objPHPExcel->getActiveSheet(0)->setCellValue('B'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['kemu']));
$objPHPExcel->getActiveSheet(0)->setCellValue('C'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['jibie']));
$objPHPExcel->getActiveSheet(0)->setCellValue('D'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['banbie']));
$objPHPExcel->getActiveSheet(0)->setCellValue('E'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['name']));
$objPHPExcel->getActiveSheet(0)->setCellValue('F'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['sex']));
$objPHPExcel->getActiveSheet(0)->setCellValue('G'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['tel']));
$objPHPExcel->getActiveSheet(0)->setCellValue('H'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['tuijianschool']));
$objPHPExcel->getActiveSheet(0)->setCellValue('I'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['jiedianhua']));
$objPHPExcel->getActiveSheet(0)->setCellValue('J'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['chenggong']));
// $objPHPExcel->getActiveSheet(0)->setCellValue('K'.($i+3), $OrdersData[$i]['chenggong']);
// $objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':K'.($i+3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':J'.($i+3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':J'.($i+3))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getRowDimension($i+3)->setRowHeight(16);
}
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('bangjieup');
// 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="bangjieup('.date('Ymd-His').').xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
$data=!empty($_POST) ? $_POST : $_GET;
$ser="";
$where=array("name"=>"%{$_POST["name"]}%","tel"=>"%{$_POST["tel"]}%","kemu"=>"%{$_POST["kemu"]}%");
//$where=array();
if(!empty($data["chenggong"])){
$ser.="/chenggong/{$data["chenggong"]}";
$where["chenggong"]=$data["chenggong"];
}
if(!empty($data["start"])){
$ser.="/start/{$data["start"]}";
$where["start"]=$data["start"];
}
if(!empty($data["tuijianschool"])){
$ser.="/tuijianschool/{$data["tuijianschool"]}";
$where["tuijianschool"]=$data["tuijianschool"];
}
if(!empty($data["banbie"])){
$ser.="/banbie/{$data["banbie"]}";
$where["banbie"]=$data["banbie"];
}
$model=D("content");
$OrdersData=$model->where($where)->order('start desc')->limit($page->limit)->select();
include "classes/PHPExcel.php";
// Create new PHPExcel object
$objPHPExcel=new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("ctos")
->setLastModifiedBy("ctos")
->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");
//set width
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(10);
//$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(10);
//设置行高度
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(22);
$objPHPExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
//set font size bold
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A2:J2')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//设置水平居中
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// $objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->mergeCells('A1:J1');
// set table header content
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1',iconv("UTF-8", "UTF-8",'邦杰外语课程汇总 时间:'.date('Y-m-d H:i:s')))
->setCellValue('A2',iconv("UTF-8", "UTF-8",'咨询日期'))
->setCellValue('B2',iconv("UTF-8", "UTF-8",'科目'))
->setCellValue('C2',iconv("UTF-8", "UTF-8",'课程级别'))
->setCellValue('D2',iconv("UTF-8", "UTF-8",'班别'))
->setCellValue('E2',iconv("UTF-8", "UTF-8",'学员姓名'))
->setCellValue('F2',iconv("UTF-8", "UTF-8",'性别'))
->setCellValue('G2',iconv("UTF-8", "UTF-8",'学员手机'))
->setCellValue('H2',iconv("UTF-8", "UTF-8",'推荐校区'))
->setCellValue('I2',iconv("UTF-8", "UTF-8",'接电员码'))
->setCellValue('J2',iconv("UTF-8", "UTF-8",'联系状态'));
// ->setCellValue('K2', '接电员码');
// Miscellaneous glyphs, UTF-8
for($i=0;$i<count($OrdersData)-1;$i++){
$objPHPExcel->getActiveSheet(0)->setCellValue('A'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['start']));
$objPHPExcel->getActiveSheet(0)->setCellValue('B'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['kemu']));
$objPHPExcel->getActiveSheet(0)->setCellValue('C'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['jibie']));
$objPHPExcel->getActiveSheet(0)->setCellValue('D'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['banbie']));
$objPHPExcel->getActiveSheet(0)->setCellValue('E'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['name']));
$objPHPExcel->getActiveSheet(0)->setCellValue('F'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['sex']));
$objPHPExcel->getActiveSheet(0)->setCellValue('G'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['tel']));
$objPHPExcel->getActiveSheet(0)->setCellValue('H'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['tuijianschool']));
$objPHPExcel->getActiveSheet(0)->setCellValue('I'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['jiedianhua']));
$objPHPExcel->getActiveSheet(0)->setCellValue('J'.($i+3), iconv("UTF-8", "UTF-8",$OrdersData[$i]['chenggong']));
// $objPHPExcel->getActiveSheet(0)->setCellValue('K'.($i+3), $OrdersData[$i]['chenggong']);
// $objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':K'.($i+3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':J'.($i+3))->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A'.($i+3).':J'.($i+3))->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getRowDimension($i+3)->setRowHeight(16);
}
// Rename sheet
$objPHPExcel->getActiveSheet()->setTitle('bangjieup');
// 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="bangjieup('.date('Ymd-His').').xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
如果输出的filename就是下载文件名需要中文的话可以iconv转成gb2312.