phpexcel 设置标题

<?php
require_once 'PHPExcel.php';

// 创建一个新的 PHPExcel 对象
$objPHPExcel = new PHPExcel();

// 设置文档属性
$objPHPExcel->getProperties()
    ->setCreator("Your Name")
    ->setLastModifiedBy("Your Name")
    ->setTitle("Sample Excel Document")
    ->setSubject("Sample Excel Document")
    ->setDescription("Sample Excel Document")
    ->setKeywords("office PHPExcel")
    ->setCategory("Sample");

// 设置标题行
$objPHPExcel->setActiveSheetIndex(0)
    ->setCellValue('A1', 'ID')
    ->setCellValue('B1', 'Name')
    ->setCellValue('C1', 'Age');

// 设置工作表名称
$objPHPExcel->getActiveSheet()->setTitle('Sample Sheet');

// 写入文件
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('sample.xlsx');
?>

$objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('A1', 'ID', PHPExcel_Cell_DataType::TYPE_STRING);