Bladephp: Now with 8+ codeigniter, php, and laravel project 8+ php project From $37/Month From Rs. 2499/Month

PHPExcel export mysql to excel in Codeigniter

by
Category:codeigniter
codeigniter mysql phpexcel
 PHPExcel export mysql to excel in Codeigniter

Most of the time my clients need to download data from their database tables. Today, I decided to make a very small controller that is portable and efficient for exporting full MySQL tables to Excel using PHPExcel and CodeIgniter.

First of all, you need PHPExcel which should be installed as a CodeIgniter library. In order to do this, you should follow the steps posted here.

require_once APPPATH.'third_party/PHPExcel.php';
$this->excel = new PHPExcel(); 

PHPExcel Library in Controller.

$tamplate       = "demo.xlt";
$objReader      = PHPExcel_IOFactory::createReader('Excel5');
$exportdimond = $this->Userlist_Model->ExportDiamond();
$objPHPExcel    = $objReader->load("assets/file_template/".$tamplate);

$row = 2;
foreach ($exportdimond as $value)
{
    $objPHPExcel->getActiveSheet()->setCellValue('A'.$row, $value->id);
    $objPHPExcel->getActiveSheet()->setCellValue('B'.$row, $value->C_Shape);
    $objPHPExcel->getActiveSheet()->setCellValue('C'.$row, $value->C_Weight);
    $objPHPExcel->getActiveSheet()->setCellValue('D'.$row, $value->C_Color);
    $objPHPExcel->getActiveSheet()->setCellValue('E'.$row, $value->C_Clarity);
    $objPHPExcel->getActiveSheet()->setCellValue('F'.$row, $value->C_Cut);
    $objPHPExcel->getActiveSheet()->setCellValue('G'.$row, $value->C_Polish);
    $objPHPExcel->getActiveSheet()->setCellValue('H'.$row, $value->C_Symmetry);
    $objPHPExcel->getActiveSheet()->setCellValue('I'.$row, $value->C_Fluorescence);
    $row++;
}
$filename = "demo". date("Y-m-d-H-i-s").".csv";
header('Content-Type: application/vnd.ms-excel'); 
header('Content-Disposition: attachment;filename="'.$filename.'"');
header('Cache-Control: max-age=0'); 
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');  
$objWriter->save('php://output');

Now model call to get data in table $this->Userlist_Model->ExportDiamond();

function ExportDiamond()
{
    $query = $this->db->get('diamond_master');
    return $query->result();
}

PHPExcel import excel to mysql in Codeigniter


0 Comments


Html code work in comment box


Related Post