PHPExcel是用来操作Office Excel 文档的一个PHP类库,它基于微软的OpenXML标准和PHP语言。可以使用它来读取、写入不同格式的电子表格,如 Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML等等。
创建PHPExcel对象:
include libfile('class/PHPExcel'); $objPHPExcel = new PHPExcel(); //设置Excel表格参数 以Office 2007为例 $objPHPExcel->getProperties()->setCreator("Maarten Balliauw") ->setLastModifiedBy("Maarten Balliauw") ->setTitle("Office 2007 XLSX Document") ->setSubject("Office 2007 XLSX Document") ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.") ->setKeywords("office 2007 openxml php") ->setCategory("Test result file"); |
合并单元格:
$objPHPExcel->getActiveSheet()->mergeCells('A1:F1'); //合并 $objPHPExcel->getActiveSheet()->unmergeCells('A1:F1'); // 拆分 |
加粗和居中
$objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray( array( 'font' => array ( 'bold' => true ), 'alignment' => array( 'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER ) ) ); |
加边框
$objPHPExcel->getActiveSheet()->getStyle('A2:F2')->applyFromArray( array( 'borders' => array( 'top' => array( 'style' => PHPExcel_Style_Border::BORDER_THIN ) ) ) ); |
表格导出时单元格换行效果:数据中需带有换行符( \n )
$objPHPExcel->setActiveSheetIndex(0)->getStyle('A1')->getAlignment()->setWrapText(true); |