如何在php codeigniter中导出报表，其中数据库行在excel表格中显示为列名称

php spark make:controller ReportController

public function exportReport()
{
    // 加载数据库库
    $this->load->database();

    // 加载PHPExcel库
    require_once APPPATH . 'third_party/PHPExcel/PHPExcel.php';

    // 查询数据库获取需要导出的数据
    $query = $this->db->get('your_table_name');
    $data = $query->result_array();

    // 创建Excel对象
    $objPHPExcel = new PHPExcel();

    // 设置表头
    $columnNames = array_keys($data[0]);
    $columnIndex = 0;
    foreach ($columnNames as $columnName) {
        $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($columnIndex, 1, $columnName);
        $columnIndex++;
    }

    // 写入数据
    $rowIndex = 2;
    foreach ($data as $row) {
        $columnIndex = 0;
        foreach ($row as $cellValue) {
            $objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($columnIndex, $rowIndex, $cellValue);
            $columnIndex++;
        }
        $rowIndex++;
    }

    // 设置文件名和格式
    $filename = 'report.xlsx';

    // 保存Excel文件到服务器
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save('path/to/save/' . $filename);

    // 或者直接输出给用户下载
    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    header('Content-Disposition: attachment;filename="' . $filename . '"');
    header('Cache-Control: max-age=0');
    $objWriter->save('php://output');
}

$routes->get('export-report', 'ReportController::exportReport');