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
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 :