PHPExcel如何使用codeigniter动态设置单元格值

<?php
if (!defined('BASEPATH')) exit('No direct script access allowed');

require_once APPPATH . 'libraries/PHPExcel/PHPExcel.php';

class CI_PHPExcel extends PHPExcel
{
    public function __construct()
    {
        parent::__construct();
    }
}

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class ExcelController extends CI_Controller {
    public function __construct()
    {
        parent::__construct();
        $this->load->library('CI_PHPExcel');
    }

    public function index()
    {
        // 创建一个新的Excel对象
        $objPHPExcel = new CI_PHPExcel();

        // 设置单元格的值
        $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Hello World');

        // 保存Excel文件
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
        $objWriter->save('path/to/save/file.xlsx');
    }
}