在codeigniter中将excel数据导入数据库

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

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

class ExcelImport extends CI_Controller {

    public function __construct() {
        parent::__construct();
    }

    public function index() {
        // Your code here
    }
}

public function index() {
    $inputFileName = 'path/to/your/excel/file.xlsx';

    $objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
    $worksheet = $objPHPExcel->getActiveSheet();

    $highestRow = $worksheet->getHighestRow();
    $highestColumn = $worksheet->getHighestColumn();

    for ($row = 2; $row <= $highestRow; $row++) {
        $rowData = $worksheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);

        // 将数据插入数据库
        $data = array(
            'column1' => $rowData[0][0],
            'column2' => $rowData[0][1],
            'column3' => $rowData[0][2],
            // 添加更多的列...
        );

        $this->db->insert('your_table_name', $data);
    }

    echo 'Excel数据导入成功！';
}