Generate Excel Report with Php and Mysql using code

Step 1. Include phpexcel class file along with your config file and make its object with excel file name passed parameter in constructor. You can check for  error in next line as shown

1	require_once("excelwriter.class.php");

2

3	$excel=new ExcelWriter("report.xls");

4

5	if($excel==false)

6	echo $excel->error;

Step 2. Now time to fetch data from mysql database. Before fetch data, call excel header having columns as values of array.

01	// this will create heading of each column in excel file

02

03	$myArr=array("S.No.","Company Name","Email","City","Username","Reg. Date");

04	$excel->writeLine($myArr);

05

06	// now fetch data from database table, there is a new line create each time loop runs

07

08	$qry=mysql_query("select * from customer");

09	if($qry!=false)

10

{

11

$i=1;

12	while($res=mysql_fetch_array($qry))

13

{

14	$myArr=array($i,$res['company_name'],$res['email'],...);

15	$excel->writeLine($myArr);

16

$i++;

17

}

18

}

Step 3.  Create link to generate excel file.

1	<a href="javascript:void(0);" onClick="download();">Download Excel Reporta>

and here download function pointing to excel file

1

 Download Code Here