php excel类 phpExcel使用方法介绍

()->getStyle(''E4′)->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE);
　　$objPHPExcel->getActiveSheet()->duplicateStyle( $objPHPExcel->getActiveSheet()->getStyle(''E4′), ‘E5:E13′ );
　　设置宽width
　　// Set column widths
　　$objPHPExcel->getActiveSheet()->getColumnDimension(''B'')->setAutoSize(true);
　　$objPHPExcel->getActiveSheet()->getColumnDimension(''D'')->setWidth(12);
　　设置font
　　$objPHPExcel->getActiveSheet()->getStyle(''B1′)->getFont()->setName(''Candara'');
　　$objPHPExcel->getActiveSheet()->getStyle(''B1′)->getFont()->setSize(20);
　　$objPHPExcel->getActiveSheet()->getStyle(''B1′)->getFont()->setBold(true);
　　$objPHPExcel->getActiveSheet()->getStyle(''B1′)->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
　　$objPHPExcel->getActiveSheet()->getStyle(''B1′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
　　$objPHPExcel->getActiveSheet()->getStyle(''E1′)->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
　　$objPHPExcel->getActiveSheet()->getStyle(''D13′)->getFont()->setBold(true);
　　$objPHPExcel->getActiveSheet()->getStyle(''E13′)->getFont()->setBold(true);
　　设置align
　　$objPHPExcel->getActiveSheet()->getStyle(''D11′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
　　$objPHPExcel->getActiveSheet()->getStyle(''D12′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
　　$objPHPExcel->getActiveSheet()->getStyle(''D13′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
　　$objPHPExcel->getActiveSheet()->getStyle(''A18′)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY);
　　//垂直居中
　　$objPHPExcel->getActiveSheet()->getStyle(''A18′)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
　　设置column的border
　　$objPHPExcel->getActiveSheet()->getStyle(''A4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
　　$objPHPExcel->getActiveSheet()->getStyle(''B4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
　　$objPHPExcel->getActiveSheet()->getStyle(''C4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
　　$objPHPExcel->getActiveSheet()->getStyle(''D4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
　　$objPHPExcel->getActiveSheet()->getStyle(''E4′)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
　　设置border的color
　　$objPHPExcel->getActiveSheet()->getStyle(''D13′)->getBorders()->getLeft()->getColor()->setARGB(''FF993300′);
　　$objP