almost 9 years ago
Hello Readers! In this blog we are going to export data from database using PHPExcel. PHPExcel supports reading and writing of many formats in one API. PHPExcel is a library that provides a set of classes for the PHP programming language, which allow us to write to and read from different spreadsheet file formats, like Excel .xls, Excel 2007 .xlsx, CSV, Libre/OpenOffice Calc .ods PDF, etc.
Some of PHPExcel features are:
Create following function in controller file:
public function excel(){// create new empty worksheet and set default font$this->PhpExcel->createWorksheet()->setDefaultFont('Calibri', 12);// define table cells$table = array(array('label' => __('id')),array('label' => __('name')),array('label' => __('department')),array('label' => __('number')),array('label' => __('address')),array('label' => __('salary')),);// print_r($table);die();// add heading with different font and bold text$this->PhpExcel->addTableHeader($table, array('name' => 'Cambria', 'bold' => true));// add data$data=$this->Employee->find('all');// print_r($data);die();foreach ($data as $d) {$this->PhpExcel->addTableRow(array($d['Employee']['id'],$d['Employee']['emp_name'],$d['Employee']['emp_dept'],$d['Employee']['emp_number'],$d['Employee']['emp_address'],$d['Employee']['emp_salary']));}// close table and output$this->PhpExcel->addTableFooter()->output();}
public function excel(){
// create new empty worksheet and set default font
$this->PhpExcel->createWorksheet()
->setDefaultFont('Calibri', 12);
// define table cells
$table = array(
array('label' => __('id')),
array('label' => __('name')),
array('label' => __('department')),
array('label' => __('number')),
array('label' => __('address')),
array('label' => __('salary')),
);
// print_r($table);die();
// add heading with different font and bold text
$this->PhpExcel->addTableHeader($table, array('name' => 'Cambria', 'bold' => true));
// add data
$data=$this->Employee->find('all');
// print_r($data);die();
foreach ($data as $d) {
$this->PhpExcel->addTableRow(array(
$d['Employee']['id'],
$d['Employee']['emp_name'],
$d['Employee']['emp_dept'],
$d['Employee']['emp_number'],
$d['Employee']['emp_address'],
$d['Employee']['emp_salary']
));
}
// close table and output
$this->PhpExcel->addTableFooter()
->output();
}
add these two lines in controller:
in AppController.php:
And at last create a view excel.ctp file. And add the following link in your display.ctp file:
0 Comment(s)