Bagaimana cara mengimpor data dari excel di codeigniter?

public function dipExcelUpload($file=""){
    
        ini_set('MAX_EXECUTION_TIME', -1);
        ini_set('memory_limit', '-1');   

        $file_upload    = $file;

        if (isset($file_upload) && !empty($file_upload)){ 

        //You can add directly the Composer Autoloder in your controller: 
        require FCPATH . 'vendor/autoload.php';

        try{   
            $objPHPExcel = PHPExcel_IOFactory::load($file_upload);   
        }   
        catch (Exception $e){
            die('Error loading file "' . pathinfo($file_upload, PATHINFO_BASENAME) . '": '.@$e->getMessage()); 
        }   
    
        $allDataInSheet         = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);  
        $sheet                  = $objPHPExcel->getSheet(0);  
        $highestRow             = $sheet->getHighestRow();  
        $highestCol             = $sheet->getHighestColumn();  
        $highestco              = $sheet->getHighestDataColumn();  
        $arrayCount             = count($allDataInSheet);   
        $now                    = date("Y-m-d H:i:s");      
        $flag = 0;

        $check_template = array(
            'A' => 'FIN_ID',
            'B' => 'SECCODE',
            'C' => 'SCHEME_NO',
            'D' => 'SEC_SCH',
            'E' => 'DIPNO',
            'F' => 'DIPDT',
            'G' => 'DIPQTY',
            'H' => 'RATE',
            'I' => 'BILLQTY',       
            'J' => 'BILLREF',       
            'K' => 'DUMMY',       
            'L' => 'BILLDT',       
            'M' => 'EORP',       
        );

        $input_template = $allDataInSheet[1];

        array_walk($input_template, $this->trim_value);

        $result = array_diff($check_template, $input_template);

        if(empty($result))
        {
            $this->srObject->truncTableDip();

            # loop for inserting data 
            for ($i = 2,$j=0; $i <= $highestRow; $i++){

                $db_ch_ot = 64;

                $fin_id         = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $sec_code       = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $sch_no         = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $sec_sch        = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $dip_no         = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $dip_dt         = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);

                if(empty($dip_dt)) {
                    $dip_dt = null;
                }else{
                    $dip_dt = date("Y-m-d",strtotime($dip_dt));                    
                }

                $dip_qty        = trim($allDataInSheet[$i][chr(++$db_ch_ot)]); 
                $rate           = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $bill_qty       = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $bill_ref       = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $dummy          = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);
                $bill_dt        = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);

                if(empty($bill_dt)){
                    $bill_dt = null;
                }

                $eorp           = trim($allDataInSheet[$i][chr(++$db_ch_ot)]);

                $dt             = date('Y-m-d H:i:s');
                
                $insert_data = array(  
                    "fin_id_data"           => $fin_id,
                    "sec_code_data"         => $sec_code,
                    "sch_no_data"           => $sch_no,
                    "sec_sch_data"          => $sec_sch,
                    "dip_no_data"           => $dip_no,
                    "dip_dt_data"           => $dip_dt,
                    "dip_qty_data"          => $dip_qty,
                    "rate_data"             => $rate,
                    "bill_qty_data"         => $bill_qty,
                    "bill_ref_data"         => $bill_ref,
                    "dummy_data"            => $dummy,
                    "bill_dt_data"          => $bill_dt,
                    "eorp_data"             => $eorp,
                    "created_at_data"       => $dt,
                    "updated_at_data"       => $dt,           
                );
                
                if($this->srObject->insertSdipData($insert_data))
                {
                    ++$flag;
                }


            } //loop close  

            // routine call          
            $this->load->library('mydb');
            $this->mydb->GetMultiResults("CALL ut_sreco_dip_routine()");

        }  else {
            $this->session->set_flashdata('error', 'Error. Invalid Excel Template');
            redirect(site_url('schill-bill-checking-suuti/sreco'));
        }   

        $this->session->set_flashdata('success', 'File Uploaded Successfully ..'.' New Record Inserted : '.$flag);
        redirect(site_url('schill-bill-checking-suuti/sreco'));

     
    }
 
}

Bagaimana cara import file excel di codeigniter?

Bagaimana cara import data dari excel ke codeigniter 4?

Bagaimana cara mengimpor data file excel ke tabel MySQL menggunakan CodeIgniter?

Bagaimana cara membaca data dari excel di php?