尝试这个
$ objPHPExcel = new PHPExcel();
$ objPHPExcel-> getProperties() - > setCreator(“Maarten Balliauw”)
- > setLastModifiedBy(“Maarten Balliauw”)
- > setTitle(“Office 2007 XLSXtesting文档”)
- > setSubject(“Office 2007 XLSXtesting文档”)
- > setDescription(“使用PHP类生成的Office 2007 XLSX的testing文档”。)
- > setKeywords(“office 2007 openxml php”)
- > setCategory(“testing结果文件”);
$ objPHPExcel-> setActiveSheetIndex(0);
$ sheet = $ objPHPExcel-> getActiveSheet();
$ sheet-> setCellValue('A1','No');
$ sheet-> setCellValue('B1','Job ID');
$ sheet-> setCellValue('C1','Job completed Date');
$ sheet-> setCellValue('D1','Job Archived Date');
$ styleArray = array(
'font'=>数组(
'bold'=> true
)
);
$片状>的getStyle( 'A1') - > applyFromArray($ styleArray);
$片状>的getStyle( 'B1') - > applyFromArray($ styleArray);
$片状>的getStyle( 'C1') - > applyFromArray($ styleArray);
$片状>的getStyle( 'D1') - > applyFromArray($ styleArray);
$ sheet-> getPageSetup() - > setRowsToRepeatAtTopByStartAndEnd(1,1);