require_once
APP_PATH.'PHPExcel/PHPExcel.php';
require_once
APP_PATH.'PHPExcel/PHPExcel/Writer/Excel5.php';
require_once
APP_PATH.'PHPExcel/PHPExcel/Writer/Excel2007.php';
$objPHPExcel
=
new
PHPExcel();
$objPHPExcel
->createSheet(0);
$objPHPExcel
->setActiveSheetIndex(0);
$currentSheet
=
$objPHPExcel
->getActiveSheet();
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('G')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('H')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('I')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('J')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('K')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('L')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('M')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('N')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('O')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->setActiveSheetIndex(0)->getStyle('P')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel
->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('F')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('G')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('H')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('I')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('J')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('K')->setWidth(20);
$objPHPExcel
->getActiveSheet()->getColumnDimension('L')->setWidth(20);
$currentSheet
->setCellValue('A1',
"数据1"
);
$currentSheet
->setCellValue('B1',
"数据2"
);
$currentSheet
->setCellValue('C1',
"数据3"
);
$currentSheet
->setCellValue('D1',
"数据4"
);
$currentSheet
->setCellValue('E1',
"数据5"
);
$currentSheet
->setCellValue('F1',
"数据6"
);
$currentSheet
->setCellValue('G1',
"数据7"
);
$currentSheet
->setCellValue('H1',
"数据8"
);
$currentSheet
->setCellValue('I1',
"数据9"
);
$currentSheet
->setCellValue('J1',
"数据10"
);
$currentSheet
->setCellValue('K1',
"数据11"
);
$currentSheet
->setCellValue('L1',
"数据12"
);
$currentSheet
->setCellValue('M1',
"照片数据1"
);
$currentSheet
->setCellValue('N1',
"照片数据2"
);
$currentSheet
->setCellValue('O1',
"照片数据3"
);
$currentSheet
->setCellValue('P1',
"照片数据4"
);
$idx
= 2;
$searchInfo
= M('数据表')->select();
$year_time_result
= 自定义设置的查询条件;
$i
= 0;
foreach
(
$searchInfo
as
&
$y
){
$i
++;
$currentSheet
->setCellValue('A' .
$idx
, 数据1);
$currentSheet
->setCellValue('B' .
$idx
, 数据2);
$currentSheet
->setCellValue('C' .
$idx
, 数据3);
$currentSheet
->setCellValue('D' .
$idx
, 数据4);
$currentSheet
->setCellValue('E' .
$idx
, 数据5);
$currentSheet
->setCellValue('F' .
$idx
, 数据6);
$currentSheet
->setCellValue('G' .
$idx
, 数据7);
$currentSheet
->setCellValue('H' .
$idx
, 数据8);
$currentSheet
->setCellValue('I' .
$idx
, 数据9);
$currentSheet
->setCellValue('J' .
$idx
, 数据10);
$currentSheet
->setCellValue('K' .
$idx
, 数据11);
$currentSheet
->setCellValue('L' .
$idx
, 数据12);
$currentSheet
->getRowDimension(
$idx
) -> setRowHeight(100);
$objDrawing
=
new
PHPExcel_Worksheet_Drawing();
if
(!
empty
(照片数据1)){
$objDrawing
->setPath(照片数据1);
$objDrawing
->setHeight(100);
$objDrawing
->setWidth(100);
$objDrawing
->setCoordinates('M'.
$idx
);
$objDrawing
->setOffsetX(0);
$objDrawing
->setOffsetY(0);
$objDrawing
->setWorksheet(
$objPHPExcel
->getActiveSheet());
}
$objDrawing1
=
new
PHPExcel_Worksheet_Drawing();
if
(!
empty
(照片数据2)){
$objDrawing1
->setPath(照片数据2);
$objDrawing1
->setHeight(100);
$objDrawing1
->setWidth(100);
$objDrawing1
->setCoordinates('N'.
$idx
);
$objDrawing1
->setOffsetX(0);
$objDrawing1
->setOffsetY(0);
$objDrawing1
->setWorksheet(
$objPHPExcel
->getActiveSheet());
}
$objDrawing2
=
new
PHPExcel_Worksheet_Drawing();
if
(!
empty
(照片数据3)){
$objDrawing2
->setPath(照片数据3);
$objDrawing2
->setHeight(100);
$objDrawing2
->setWidth(100);
$objDrawing2
->setCoordinates('O'.
$idx
);
$objDrawing2
->setOffsetX(0);
$objDrawing2
->setOffsetY(0);
$objDrawing2
->setWorksheet(
$objPHPExcel
->getActiveSheet());
}
$objDrawing3
=
new
PHPExcel_Worksheet_Drawing();
if
(!
empty
(照片数据4)){
$objDrawing3
->setPath(照片数据4);
$objDrawing3
->setHeight(100);
$objDrawing3
->setWidth(100);
$objDrawing3
->setCoordinates('P'.
$idx
);
$objDrawing3
->setOffsetX(0);
$objDrawing3
->setOffsetY(0);
$objDrawing3
->setWorksheet(
$objPHPExcel
->getActiveSheet());
}
$idx
++;
}
$write
=
new
PHPExcel_Writer_Excel5(
$objPHPExcel
);
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=
"导出excel的文件名(可自定义)"
');
header(
"Content-Transfer-Encoding:binary"
);
$write
->save('php: