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 php")
    ->setCategory("Sample File");

// 添加数据到工作表
$objPHPExcel->setActiveSheetIndex(0)
    ->setCellValue('A1', 'Hello')
    ->setCellValue('B1', 'World');

// 设置活动工作表的标题
$objPHPExcel->getActiveSheet()->setTitle('Sample Sheet');

// 设置第一个工作表为活动工作表
$objPHPExcel->setActiveSheetIndex(0);

// 导出 Excel 文件
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="sample.xlsx"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
?>

$objPHPExcel = PHPExcel_IOFactory::load($filePath, $encode = 'utf-8');

ob_end_clean();
$objWriter->save('php://output');