PHP는 PHPExcel을 사용하여 Excel 코드를 내보냅니다.-PHP 튜토리얼-php.cn

PHP는 PHPExcel을 사용하여 Excel 코드를 내보냅니다.

WBOY

풀어 주다： 2016-07-25 08:44:20

원래의

885명이 탐색했습니다.

vendor("PHPExcel176.PHPExcel");
// 새 PHPExcel 객체 생성
$objPHPExcel = new PHPExcel();
// 속성 설정
$objPHPExcel->getProperties()->setCreator("ctos")
->setLastModifiedBy("ctos")
->setTitle("Office 2007 XLSX 테스트 문서")
- >setSubject("Office 2007 XLSX 테스트 문서")
->setDescription("PHP 클래스를 사용하여 생성된 Office 2007 XLSX용 테스트 문서.")
->setKeywords("office 2007 openxml php")
->setCategory("테스트 결과 파일");
//너비 설정
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(80);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(80);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')-> ;setWidth(80);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(80);
$objPHPExcel->getActiveSheet()->getColumnDimension( 'E')->setWidth(80);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(80);
//속도 이동 높이
//$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(22);
//$objPHPExcel->getActiveSheet()->getRowDimension('2') ->setRowHeight(20);
//글꼴 크기를 굵게 설정
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
//$objPHPExcel->getActiveSheet()->getStyle('A2:F2')->getFont()->setBold(true);
//$objPHPExcel->getActiveSheet()- >getStyle('A2:F2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//$objPHPExcel->getActiveSheet()->getStyle('A2:F2' )->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//设置水平居中
//$objPHPExcel->getActiveSheet()->getStyle( 'A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$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()->mergeCells('A1:F1') ;
//글꼴 크기를 굵게 설정
//$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
//$objPHPExcel ->getActiveSheet()->getStyle('A2:F2')->getFont()->setBold(true);
//$objPHPExcel->getActiveSheet()->getStyle(' A2:F2')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//$objPHPExcel->getActiveSheet()->getStyle('A2:F2')->getBorders ()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);????????????
$objPHPExcel->getActiveSheet()->getStyle('A1')- >getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$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);
//???cell
$objPHPExcel->getActiveSheet()->mergeCells('A1:F1');
/ / 테이블 헤더 내용 설정
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', iconv("utf-8","gb2312","주문 데이터 요약 시간:'.date('Y-m-d H:i:s')"))
->setCellValue ('A2', iconv("utf-8","gb2312","주문 ID"))
->setCellValue('B2', iconv("utf-8","gb2312","주문자 "))
->setCellValue('C2', iconv("utf-8","gb2312","고객 이름"))
->setCellValue('D2', iconv("utf - 8","gb2312","주문 시간"))
->setCellValue('E2', iconv("utf-8","gb2312","필수 모델"))
- >setCellValue ('F2', iconv("utf-8","gb2312","필요 수량"));
// 기타 글리프, UTF-8
for($i=0;$i< ;count( $OrdersData)-1;$i ){
$objPHPExcel->getActiveSheet(0)->setCellValue('A'.($i 3), iconv("utf-8","gb2312 ",$ OrdersData[$i]['id']));
$objPHPExcel->getActiveSheet(0)->setCellValue('B'.($i 3), iconv("utf-8" ,"gb2312 ",$OrdersData[$i]['reid']));
$objPHPExcel->getActiveSheet(0)->setCellValue('C'.($i 3), iconv("utf -8" ,"gb2312",$OrdersData[$i]['topid']));
//$objPHPExcel->getActiveSheet(0)->setCellValue('D'.($i 3) , iconv( 'utf-8','gb2312',toDate($OrdersData[$i]['typename']))) //??????common.php?????? >getActiveSheet(0)->setCellValue('D'.($i 3), iconv("utf-8","gb2312",$OrdersData[$i]['typename'] ));
$objPHPExcel->getActiveSheet(0)->setCellValue('E'.($i 3), iconv("utf-8","gb2312",$OrdersData[$i][' typelink']));
$objPHPExcel->getActiveSheet(0)->setCellValue('F'.($i 3), iconv("utf-8","gb2312",$OrdersData[$i ]['keyword'] ));
//$objPHPExcel->getActiveSheet()->getStyle('A'.($i 3).':F'.($i 3))-> ;getAlignment()-> ;setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//$objPHPExcel->getActiveSheet()->getStyle('A'.($i 3).':F'.($ i 3))-> ;getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
//$objPHPExcel->getActiveSheet()->getRowDimension($i 3)- >setRowHeight(16) ;
}
// 시트
$objPHPExcel->getActiveSheet()->setTitle( iconv("utf-8","gb2312",'주문 요약 테이블' ));
// 활성 시트 인덱스를 첫 번째 시트로 설정하여 Excel에서 이를 첫 번째 시트로 엽니다
$objPHPExcel->setActiveSheetIndex(0);
// Excel 헤더 매개변수
헤더('Content-Type: application/vnd.ms-excel; charset=utf-8');
header('Content-Type: 애플리케이션/force-download');
header('Content-Type: 애플리케이션/옥텟-스트림' );
header('Content-Type: 애플리케이션/다운로드');
//header('Content-type:charset=utf-8);
//header( 'Content-Transfer-Encoding : utf-8');
header('Content-Disposition: attachment;filename='.iconv("utf-8","gb2312","주문 요약".date('Ymd -His')." .xls")); //날짜는 파일 이름 접미사입니다.
//header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter( $objPHPExcel, ' excel5'); //excel5는 xls 형식이고 excel2007은 xlsx 형식입니다
$objWriter->save('php://output');

코드 복사

PHP, PHPExcel, 엑셀