controller_export

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

//load Spout Library
require_once APPPATH . 'third_party/spout/src/Spout/Autoloader/autoload.php';

use Box\Spout\Writer\Common\Creator\WriterEntityFactory;
use Box\Spout\Common\Entity\Row;

class Export extends CI_Controller
{

    function __construct()
    {
        parent::__construct();
        //load model
        $this->load->model('app');
    }

    public function index()
    {
        $this->load->view('export');
    }

    public function export_data()
    {
        //ambil data
        $get    = $this->app->getAll();

        //validasi jumlah data
        if ($get->num_rows() > 0) {
            $writer = WriterEntityFactory::createXLSXWriter();

            $writer->openToBrowser("data_anggota.xlsx");
            //silahkan sobat sesuaikan dengan data yang ingin sobat tampilkan
            $header = [
                WriterEntityFactory::createCell('No'),
                WriterEntityFactory::createCell('Nama'),
                WriterEntityFactory::createCell('Jenis Kelamin'),
                WriterEntityFactory::createCell('Alamat')
            ];
            /** Tambah row satu kali untuk header */
            $singleRow = WriterEntityFactory::createRow($header);
            $writer->addRow($singleRow); //tambah row untuk header data

            $data   = array(); //siapkan variabel array untuk menampung data
            $no     = 1;

            //looping pembacaan data
            foreach ($get->result() as $key) {
                //masukkan data dari database ke variabel array
                //silahkan sobat sesuaikan dengan nama field pada tabel database
                $anggota    = array(
                    WriterEntityFactory::createCell($no++),
                    WriterEntityFactory::createCell($key->nama),
                    WriterEntityFactory::createCell($key->jenis_kelamin),
                    WriterEntityFactory::createCell($key->alamat)
                );

                array_push($data, WriterEntityFactory::createRow($anggota)); //masukkan variabel array anggota ke variabel array data
            }

            $writer->addRows($data); // tambahkan row untuk data anggota

            $writer->close(); //tutup spout writer
        } else {
            echo "Data tidak ditemukan";
        }
    }
}