ridho pratama ridho pratama - 5 months ago 127
PHP Question

how to fix import excel file in php

i have problem with import data excel in php use excel_reader.

this is error view

pict error

this is my code :

$config['upload_path'] = './assets/excel/';
$config['allowed_types'] = 'xls';
$config['max_size'] = 1024 * 8;

$this->load->library('upload', $config);

if ( ! $this->upload->do_upload())
{
echo'<script>alert("Upload gagal. Perhatikan ekstensi file. Ekstensi harus xls. Apabila ekstensi sudah xls namun gagal, lengkapi data dalam file xls.");</script>';
$this->load->view('include/header');
$this->load->view('upload_excel_cust');
$this->load->view('include/footer');

}
else
{
$data = array('error' => false);
$upload_data = $this->upload->data();


$this->load->library('Excel_reader');
$this->excel_reader->setOutputEncoding('230787');

$file = $upload_data['full_path'];
$this->excel_reader->read($file);
error_reporting(E_ALL ^ E_NOTICE);

// Sheet 1
$data = $this->excel_reader->sheets[0] ;
$dataexcel = Array();
for ($i = 1; $i <= $data['numRows']; $i++) {

if($data['cells'][$i][1] == '') break;
$dataexcel[$i-1]['tgl'] = $data['cells'][$i][2];
$dataexcel[$i-1]['nama_tempat'] = $data['cells'][$i][3];


i've been read the problem cause excel_reader file not support in php 7,
how i can fix it?

thankyou...

[solved]

this problem solved, i just need change name function same with name class in to (__construct)

thankyou..

Answer

Hi to read excel file you can read this post read excel file

Verify that your PHPExcel folderPHPExcel file are in your third_party folder, then in your application/library folder you need to create a Excel.php with

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

require_once APPPATH."/third_party/PHPExcel.php";

class Excel extends PHPExcel {

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