PHP Export Data to Excel

Question

Need help! I'm just new in php and dont know how to export a data from database to excel.

The excel format must be like this:

Can you help me or suggest a function where this format can be make? The Headers like Hit Rate,Production Time, Service Time will be hard coded. The YC Alabang,and all the records under the headers will be coming from database. Thanks!

Does it have to be Excel or is csv ok? – v7d8dpo4 Dec 28 '16 at 01:20 — v7d8dpo4, Dec 28 '16 at 01:20
It must be a excel file sir – John Michael Rivera Dec 28 '16 at 01:24 — John Michael Rivera, Dec 28 '16 at 01:24

score 1 · Answer 1 · edited May 23 '17 at 10:29

1

You can use PHPExcel library. With this library, you can compose the excel file with any complex of header structure.

PHPExcel Library

Also please check this article on Stackoverflow

How to export data to an excel file using PHPExcel

This link will give you better look on coding style.

edited May 23 '17 at 10:29

Community

1
1

answered Dec 28 '16 at 01:27

Codemole

3,069
5
25
41

udated link for above library is https://github.com/PHPOffice/PHPExcel which is archieved and it's successors link is https://github.com/PHPOffice/PhpSpreadsheet – vikas etagi Apr 07 '20 at 07:22

score 0 · Answer 2 · answered Dec 29 '16 at 07:26

You can also use EasyXLS Excel library. The pic shows me that you need to export an Excel file from database, with the cell from headers merged, borders and gray background.

This link shows you how to export data from database to Excel in PHP. It has a special section on this matter only:
http://www.easyxls.com/manual/FAQ/export-to-excel-in-php-asp.html

This link shows how to set the borders and cell background: http://www.easyxls.com/manual/basics/format-excel-cells.html
like

$xlsStyleHeader->setBackground((int)$COLOR_GRAY);
$xlsStyleHeader->setBorderColors ((int)$COLOR_GRAY, (int)$COLOR_GRAY, 
                                  (int)$COLOR_GRAY, (int)$COLOR_GRAY);
$xlsStyleHeader->setBorderStyles ($BORDER_BORDER_MEDIUM, $BORDER_BORDER_MEDIUM, 
                                  $BORDER_BORDER_MEDIUM, $BORDER_BORDER_MEDIUM);

This links shows you how to merge the cells: http://www.easyxls.com/manual/basics/excel-merge-cells.html like

$xlsTable = $workbook->easy_getSheet("Sheet1")->easy_getExcelTable();
$xlsTable->easy_mergeCells_2("A1:C3");

PHP Export Data to Excel

2 Answers2