Export data to excel in php codeigniter

In this blog, we will learn how to Export data into Excel in CodeIgniter. Export data functionality makes your web application user-friendly and helps the user to maintain list data. There are various file formats are available to export data and download it as a file. Microsoft Excel is a widely used spreadsheet format that organizes and maintains data.

Step 1: Download PHP_XLSXWriter Library.

This library is designed to be lightweight, and have minimal memory usage.

Step 2: Copy paste above downloaded file xlsxwriter.class.php inside application/models folder

Step 3: Now create one view file like swiftcode_report_view.php inside application/views folder and write below code

<form method="post" action="https://app.shinerweb.com/index.php/bankcode/download_swift_code">
<input type="submit" value="Download SWIFT Code Report">
</form>

Step 4 : Now create one file bankcode.php inside your application/controllers folder and write below code

<?php
class bankcode extends CI_Controller { 
	public function __construct() {
			parent::__construct();
			$this->load->helper(array('form', 'url'));
			$this->load->library("pagination");
			$this->load->model('bankcode_model');
	}
    function swift_code_report()
    {
        $this->load->view('swiftcode_report_view');
    }
	function download_swift_code()
    {
        $this->bankcode_model->download_swift_code();
    }
}
?>

You can access your view page with this link: https://app.shinerweb.com/index.php/bankcode/swift_code_report

Step 5: Once your view and controller code completed after that you need to create one more file bankcode_model.php inside your application/models folder

<?php
error_reporting(E_ALL ^ E_DEPRECATED);	
class bankcode_model extends CI_Model 
{    
function download_swift_code()
    {
    
    $query=$this->db->query("SELECT BANK, CITY, SWIFT_CODE
    FROM BANK_SWIFT_CODE limit 5"); //take your table here
    
    $i=0;
    $cnt = 2;
    $rowcount = $query->num_rows();
    	if($rowcount != 0)
    	{
        
		include_once("xlsxwriter.class.php");
		$arr=array();			
		foreach ($query->result_array() as $row)
		{	
			$arr[$i][0]=$row['BANK'];//your table column fields
			$arr[$i][1]=$row['CITY'];
			$arr[$i][2]=$row['SWIFT_CODE'];
			$i=$i+1;
		}

		// Prepare Excel
		$filename = "SWIFT_Code_Report.xlsx";
		header('Content-disposition: attachment; filename="'.$filename.'"');
		header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");

		// Create writer
		$writer = new XLSXWriter();
		$writer->setAuthor('Divyesh Patel');
		// Optional: add header row if needed
		$header = array(
					  'Bank'=>'string',
						'City'=>'string',
						'SWIFT Code'=>'string'
					);
					
		$col_options = array('fill'=>'#699E96','font-style'=>'bold','color'=>'#ffffff', 'border'=>'left,right,top,bottom', 'border-style'=>'thin', 'height'=>15,'wrap_text'=>true,'valign'=>'center','halign'=>'center');

		$writer->writeSheetHeader('Sheet1', $header, $col_options);
		$border = array( 'border'=>'left,right,top,bottom');
		$border_style = array( 'border-style'=>'thin');
		// Write data
		foreach($arr as $row) {
			$writer->writeSheetRow('Sheet1', $row, $border, $border_style);
		}

		// Output
		$writer->writeToStdOut();
		exit();
    	}
    	else
    	{
    	echo "<script>alert('No record(s) found.') </script>";  
    	// Redircet to Home Page		
    	echo "<script language=\"javascript\">window.location = '".	site_url('/bankcode/swift_code_report')."'  </script>";
    	}
    }
	//end function
}
?>