Awesome
CodeIgniter Helper: Excel Export
ci-excel
About this library
This CodeIgniter's Helper is used to create an Excel file in real time and then download it.
Its usage is recommended for CodeIgniter 2 or greater.
Usage
$this->load->helper('export_excel');
$fields = array(
'id' => 'ID',
'name' => 'Name',
'age' => 'Age'
);
// the info inside $query is usually the response of a database query from a model
// an example of how to use this is calling a model method like: $query = $this->People->exportUsers();
// the following is just an example
$query = array();
$query[] = array(
'id' => 1,
'name' => 'Ale Mohamad',
'age' => 29
);
$query[] = array(
'id' => 2,
'name' => 'John Doe',
'age' => 36
);
echo arrayToExcel($query, $fields, "People");