How to integrate codeigniter and PHPExcel?

Question

always display an error message on my browser:

An Error Was Encountered
Non-existent class: IOFactory

all classes PHPExcel, i extract on library.

Here it is my controller code

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

class Report extends CI_Controller 
{
     public function __construct()
    {
        parent::__construct();
        $this->load->helper(array('form','url'));
    }

    public function index()
    {   

        $this->load->library('phpexcel');
        $this->load->library('PHPExcel/IOFactory.php');
        $objPHPexcel = PHPExcel_IOFactory::load('tandaterima.xlsx');
        $objWorksheet = $objPHPexcel->getActiveSheet();
        //Daftar barang (4item)
        $objWorksheet->getCell('B16')->setValue('UTP');
        $objWorksheet->getCell('B17')->setValue('Cross');
        $objWorksheet->getCell('B18')->setValue('');
        $objWorksheet->getCell('B19')->setValue('');
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPexcel, 'Excel5');
        $objWriter->save('write5.xls');
    }
}

please help me.

Did you follow step #1 of the instructions from https://github.com/EllisLab/CodeIgniter/wiki/PHPExcel? And shouldn't it be `iofactory` (lowercase); though if the PHPExcel autoloader is working, you shouldn't need to include that as well as phpexcel itself — Mark Baker, Jun 27 '13 at 07:55

score 5 · Answer 1 · answered Oct 27 '13 at 17:10

5

Follow the instruction here https://github.com/EllisLab/CodeIgniter/wiki/PHPExcel

Please remember to remove the PHPExcel_ part in the class name in IOFactory.php. And change the construct function from private to public

answered Oct 27 '13 at 17:10

save_ole

300
1
3
10

Also I don't think there is a need to follow the "Updated Guide" link. Just place the PHPExcel.php and folder into the libraries folder – orbitory May 13 '15 at 13:55

score 0 · Answer 2 · answered Oct 17 '13 at 08:34

0

ensure that u save PHPExcel/IOFactory.php inside libraries folder and load it as $this->load->library('PHPExcel/iofactory');

answered Oct 17 '13 at 08:34

samlebo

27
1
7

score 0 · Answer 3 · edited Jun 19 '17 at 18:44

0

And in some Linux Server, you have to care about case.

$this->load->library('PHPExcel'); $this->load->library('PHPExcel/IOFactory');

edited Jun 19 '17 at 18:44

Megan Fox

435
2
6
20

answered May 08 '14 at 08:03

user3606625

31
1

score 0 · Answer 4 · edited May 20 '14 at 19:46

0

You can replace this line

$objWriter = PHPExcel_IOFactory::createWriter($objPHPexcel, 'Excel5');

by this line

IOFactory::createWriter($objPHPexcel, 'Excel5');

edited May 20 '14 at 19:46

Majid Golshadi

2,686
2
20
29

answered May 20 '14 at 19:15

Flaviano

1

score 0 · Answer 5 · edited Mar 12 '16 at 15:05

0

First you need to place your PHPExcel folder inside thirdparty folder. Then create class file in the library folder. There you need to include thirdparty/PHPExcel file folder and extend the class. After that you can use it in your controller.

edited Mar 12 '16 at 15:05

Martijn Pieters

1,048,767
296
4,058
3,343

answered Sep 30 '15 at 14:43

Fiaz Ahmad

55
1
9

score 0 · Answer 6 · answered Dec 07 '17 at 07:15

Codeiginiter 3 supports Composer to use PHPExcel:

In application/config/config.php, set $config['composer_autoload'] to TRUE.

Then you can use Composer to install PHPExcel in Codeiginiter :

composer require phpoffice/phpexcel

Further, You could try PHPExcel Helper to easier handle PHPExcel:

composer require yidas/phpexcel-helper

https://github.com/yidas/phpexcel-helper

How to integrate codeigniter and PHPExcel?

6 Answers6