• logo
  • PHP
  • PHP OOPs
  • script
    • JavaScript
    • JQuery
    • Ajax
    • AngularJs
    • VueJs
    • NodeJs
    • ReactJs
  • wordpress
  • Codeigniter
  • Codeigniter 4
  • Laravel
  • Python
  • MySql
  • Json
  • C
  • C++
  • More ...
    • Cakephp Framework
    • MongoDb
    • MySqli PDO
    • .htaccess
    • HTML 5
    • CSS
    • SEO
    • DCA

Codeigniter Tutorials

  • What is codeigniter?
  • Application_Architecture
  • MVC Architecture
  • HMVC Architecture
  • Codeigniter Configuration
  • Remove index.php from url in codeigniter
  • MVC Concept
  • View
  • Alternate PHP Syntax for View Files
  • Routing
  • Codeigniter URL
  • Get Current URL
  • Previous page URL get
  • Seo Friendly URL
  • Slug Create in codeigniter
  • What is _remap() function
  • Remove controller name from url in codeigniter
  • Codeigniter Controller Class
  • Class Constructor
  • GET $ POST method in Codeigniter
  • Models
  • Basepath, Apppath, FCPATH
  • URI Segment
  • Page Redirect
  • Helper class
  • Custom Helper class
  • Form Helper
  • Common Helper Functions
  • Common Function
  • Array Problems
  • Call controller in Helper
  • Add active class to menu using Helper class
  • Custom Library
  • Custom Library Example
  • when to use get_instance()
  • Codeigniter Hook
  • how to work inline css in codeigniter
  • Custom 404 page
  • 404 custom error page
  • Create custom config file in codeigniter
  • How to set and get config item value
  • How to Speed Up CodeIgniter App?
  • Codeigniter Functions
  • Session
  • cookies
  • How to Set & Get Tempdata in Codeigniter
  • flash messages in Codeigniter
  • Flashdata
  • Encryption and Decryption In CodeIgniter
  • Codeigniter security
  • csrf token form security
  • Password Hashing
  • Form Validation
  • Custom Validation
  • Registration Form with validation
  • Server Side Form Validation
  • Validate Select Option Field
  • Date Format Validation
  • Date Format change in codeigniter
  • Date Functions
  • DOB Validation
  • CI CRUD
  • User SignUp
  • User Login
  • User Logout
  • Login Account
  • Login form with RememberMe
  • Login Form with session
  • User change password
  • Change Password with Callback Validation to Check Old Password
  • Forgot password
  • Reset password
  • Insert data in database
  • Fetch data from database
  • Update data in database
  • Delete data in database
  • File Upload
  • Image Upload with resize Image
  • Upload Multiple file and images
  • Upload Multiple images with CRUD
  • File and image update
  • Upload Image Using Ajax.
  • Email Send
  • Email Send Using Email library
  • Email Send Using SMTP Gmail
  • Notification send
  • store data in json format in DB
  • Json parse
  • Fetch data Using Ajax with Json data
  • How to Show data Using Ajax with Json parse
  • Get JSON Data from PHP Script using jQuery Ajax
  • Insert data Using Ajax
  • Submit data Using Ajax with form validation
  • How to show data Using Ajax in codeigniter
  • Insert & Update Using Ajax
  • Registration Form With Validation Using Ajax in codeigniter
  • Delete data Using Ajax Confirmation
  • Delete All data Using checkbox selection
  • Ajax CSRF Token
  • Ajax Post
  • Ajax serverside form validation
  • Contact form using AJAX with form validation
  • DataTable Using Ajax dynamically
  • DataTables pagination using AJAX with Custom filter
  • DataTables AJAX Pagination with Search and Sort in codeigniter
  • DataTables in Codeigniter using Ajax
  • Ajax Custom Serarch
  • Ajax Live Data Search using Jquery PHP MySql
  • Ajax Custom Serarch and sorting in datatable
  • Dynamic Search Using Ajax
  • Autocomplete using jquery ajax
  • Jquery Ajax Autocomplete Search using Typeahead
  • Dynamic Dependent Dropdown Using Ajax
  • Dynamic Dependent Dropdown list Using Ajax
  • Dynamic Dependent Dropdown in codeigniter using Ajax
  • ajax username/email availability check using JQuery
  • Check Email Availability Using Ajax
  • Data Load on mouse scroll
  • Ajax CI Pagination
  • Pagination in codeigniter
  • Ajax Codeigniter Pagination
  • email exists or not using ajax with json
  • CRUD using AJAX With Modal popup in CI
  • Add / Show Data on modal popup using Ajax
  • Modal popup Validation using Ajax
  • Data show on Modal popup Using Ajax
  • Add / Remove text field dynamically using jquery ajax
  • How to Add/Delete Multiple HTML Rows using JavaScript
  • Delete Multiple Rows using Checkbox
  • Multiple Checkbox value
  • Form submit using jquery Example
  • REST & SOAP API
  • Multi-Language implementation in CodeIgniter
  • How to pass multiple array in view
  • Captcha
  • create zip file and download
  • PhpOffice PhpSpreadsheet Library (Export data in excel sheet)
  • data export in excel sheet
  • Excel File generate in Codeigniter using PHPExcel
  • Dompdf library
  • tcpdf library
  • Html table to Excel & docs download
  • CI Database Query
  • Database Query
  • SQL Injection Prevention
  • Auth Model
  • Join Mysql
  • Tree View in dropdown option list
  • OTP Integration in codeigniter
  • curl post
  • download file using curl
  • Sweet Alert
  • Sweet alert Delete & Success
  • Log Message in Codeigniter
  • Menu & Submenu show dynamically
  • Set Default value in input box
  • Cron Jobs
  • Stored Procedure
  • Display Loading Image when AJAX call is in Progress
  • Send SMS
  • IP Address
  • Codeigniter Tutorialspoint
  • Website Link
  • How To Create Dynamic Xml Sitemap In Codeigniter
  • Paypal Payment Integration
  • Get Latitude and Longitude From Address in Codeigniter Using google map API
  • How To Create Simple Bar Chart In Codeigniter Using AmCharts?
  • dynamic Highcharts in Codeigniter
  • Barcode in Codeigniter
  • Codeigniter Interview Questions
  • Project
Home » Codeigniter » 

How to Generate Excel File in Codeigniter using PHPExcel library


Library Download

Libraries/Excel.php

File Name : Excel.php

<?php
if (!defined('BASEPATH')) exit('No direct script access allowed');
require_once('PHPExcel-1.8/Classes/PHPExcel.php');

class Excel extends PHPExcel
{
public function __construct()
{
parent::__construct();
}
}

?>

Libraries/IOFactory.php

File Name : IOFactory.php

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

require_once('PHPExcel-1.8/Classes/PHPExcel/IOFactory.php');
class IOFactory extends PHPExcel_IOFactory
{
public function __construct()
{
parent::__construct();
}
}

?>

Controller

File Name : Excel_export.php

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

class Excel_export extends CI_Controller {

function index()
{
$this->load->model("Common_model");
$data["employee_data"] = $this->Common_model->fetch_data();
$this->load->view("excel_list_view", $data);
}

public function excel_view($pid)
{
$id = base64_decode($pid);

$this->load->library("Excel");

$obj = new PHPExcel();
$result = $this->Common->fetch_case_details_excel($id);

$obj->setActiveSheetIndex(0);
// $this->excel->setActiveSheetIndex(0);
$obj->getActiveSheet()->setTitle('Case list');


$table_columns = array("id","first_name","last_name","address","dob","email","mobile","pin");

$column = 0;

foreach($table_columns as $field)
{
$obj->getActiveSheet()->setCellValueByColumnAndRow($column, 1, $field);
$obj->getActiveSheet()->getColumnDimension("D")->setAutoSize(true);
$obj->getActiveSheet()->getColumnDimension("F")->setAutoSize(true);

$obj->getActiveSheet()->getStyle("A1:H1")->getFont()->setBold(true);
//$obj->getActiveSheet()->getStyle("A1:E1")->applyFromArray(array("font" => array("bold" => true)));
$column++;
}



$excel_row = 2;

foreach($result as $row)
{

$obj->getActiveSheet()->setCellValueByColumnAndRow(0, $excel_row, $row->id);
$obj->getActiveSheet()->setCellValueByColumnAndRow(1, $excel_row, $row->first_name);
$obj->getActiveSheet()->setCellValueByColumnAndRow(2, $excel_row, $row->last_name);
$obj->getActiveSheet()->setCellValueByColumnAndRow(3, $excel_row, $row->address);
$obj->getActiveSheet()->setCellValueByColumnAndRow(4, $excel_row, $row->dob);
$obj->getActiveSheet()->setCellValueByColumnAndRow(5, $excel_row, $row->email);
$obj->getActiveSheet()->setCellValueByColumnAndRow(6, $excel_row, $row->mobile);
$obj->getActiveSheet()->setCellValueByColumnAndRow(7, $excel_row, $row->pin);

$excel_row++;
}

// $this->excel->getActiveSheet()->fromArray($result);

$object_writer = PHPExcel_IOFactory::createWriter($obj, 'Excel5');
// $objWriter = PHPExcel_IOFactory::createWriter($this->excel, 'Excel2007');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Data.xls"');
header('Cache-Control: max-age=0'); //no cache
$object_writer->save('php://output');

//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
//if you want to save it as .XLSX Excel 2007 format


}

}

View

File Name : excel_list_view.php

<table id="example" class="table table-striped table-bordered" style="width:100%">
<thead style="background-color:#f4f4f4; color:#000;">
<tr>
<th style="width:1%"><center><strong>S.No</strong></center></th>
<th style="width:8%"><center> Id </center></th>
<th style="width:8%"><center>First Name</center></th>
<th style="width:10%"><center>Last Name </center></th>
<th style="width:10%"><center>Address</center></th>
<th style="width:10%"><center>Dob</center></th>
<th style="width:10%"><center>Email </center></th>
<th style="width:10%"><center>Mobile </center></th>
<th style="width:10%"><center>PIN </center></th>

<th style="width:20%"><center>Action</center> </th>
</tr>
</thead>
<tbody>

<?php $i = 1;
foreach($search_result as $row){
?>

<tr>
<td align="center"> <?php echo $i++;?></td>
<td align="center"> <a href="<?php echo base_url()?>Excel_export/view/<?php echo base64_encode($row->id); ?>" target="_blank" > <?php echo $row->file_no; ?> </a></td>
<td align="center"><?php echo $row->id; ?> </td>
<td align="center"><?php echo $row->first_name; ?> </td>
<td align="center"><?php echo $row->last_name; ?> </td>
<td align="center"><?php echo $row->address; ?> </td>
<td align="center"><?php echo $row->dob; ?> </td>
<td align="center"><?php echo $row->mobile; ?> </td>
<td align="center"><?php echo $row->email; ?> </td>
<td align="center"><?php echo $row->pin; ?> </td>



<td>
<!--
<a href="<?php echo base_url()?>Excel_export/view/<?php echo base64_encode($row->id); ?>" target="_blank" class="btn btn-info active navbar-brand"> View </a>
-->

<a href="<?php echo base_url()?>Excel_export/excel_view/<?php echo base64_encode($row->id); ?>" target="_blank" class="btn btn-info active navbar-brand"> Excel </a>


<a href="<?php echo base_url()?>Excel_export/pdfview/<?php echo base64_encode($row->id); ?>" target="_blank" class="btn btn-info active navbar-brand"> PDF </a> </td>
</tr>
<?php } ?>




</tbody>
</table>

Model

File Name : Common_model.php

function fetch_case_details_excel($id)
{
$this->db->select('*');
$this->db->from('itechxpert');
$this->db->where('id', $id);
$query=$this->db->get();
$result=$query->result();
return $result;
}

File Name :





Itechtuto

Connect Us Socially:

Quick Links

  • itech
  • About Us
  • Feedback
  • Trademarks
  • Privacy Policy
  • Terms of Use
  • Sitemap
  • Trademarks
  • Privacy Policy
  • Terms of Use
  • Sitemap

Copyright © 2016 itechxpert (P) Ltd. All rights reserved.

Copyright © 2016 itechxpert (P) Ltd. All rights reserved.