php 使用PHPExcel 导出数据为Excel

<?php

require_once 'PHPExcel/Classes/PHPExcel.php';

/**
 * 导出数据为Excel
 * @param array $fieldArr 标题数组
 * @param array $dataArr 数据数组
 */
function exportExcel($fieldArr, $dataArr) {
    if (empty($fieldArr) || empty($dataArr)) {
        return;
    }

    //创建PHPExcel对象
    $obj = new PHPExcel();
    //创建excel写入对象
    $writer = new PHPExcel_Writer_Excel5($obj);
    //得到当前工作表对象
    $curSheet = $obj->getActiveSheet();
    
    $fieldNum = count($fieldArr);
    $dataRow = count($dataArr) + 2;
    
    for($col = 0; $col < $fieldNum; ++$col) {
        $cellName = PHPExcel_Cell::stringFromColumnIndex($col) . '1';
        $curSheet->setCellValue($cellName, $fieldArr[$col]);
    }
    
    for($row = 2; $row < $dataRow; ++$row) {
        for($col = 0; $col < $fieldNum; ++$col) {
            $cellName = PHPExcel_Cell::stringFromColumnIndex($col) . $row;
            $curSheet->setCellValue($cellName, $dataArr[$row-2][$col]);
        }
    }

    $fileName = date('YmdHis', time());
    header('Content-Type: application/vnd.ms-execl');
    header('Content-Disposition: attachment;filename="' . $fileName . '.xls"');
    header('Cache-Control: max-age=0');
    $writer->save('php://output');
}