One , The first condition

Need to download phpExcel library Put it into your own web page code , Calling function require_once(“phpExcel_path”)
You can edit the to be exported excel Format the table .

Two , Introduce objects

	$excel = new PHPExcel();
		// establish Excel Input object 
	$write = new PHPExcel_Writer_Excel5($excel);

one , Create header

Define an array
$letter= array(‘A’,‘B’,‘C’,‘D’…);
Or numbers
Define header array ：
$tableheader = array(‘ chinese ’,‘ chinese ’,‘ chinese ’,‘ chinese ’);

1, Write header

for($i = 0;$i < count($tableheader);$i++) 
{	
		$excel->getActiveSheet()->setCellValue("$letter[$i]1","$tableheader[$i]");
}

Ii. , Record table data

Define the table body array ：
$tablebody = array(‘ data ’,‘ data ’,‘ data ’,‘ data ’,‘ data ’);
$number The variable is the line sequence number , Change according to the demand .

for($i = 0;$i < count($tablebody);$i++) 
{
	$excel->getActiveSheet()->setCellValue("$letter[$i]$number","$tablebody[$i]");
}

3、 ... and , preservation

The basic data is recorded
Finally, save to local

header("Pragma: public");
header("Expires: 0");
ob_end_clean();		
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
//header('Cache-Control: max-age=0');
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header("Content-Disposition:attachment;filename=$project_code.$datetmp.xls");
header("Content-Transfer-Encoding:binary");
$write->save('php://output')

Four , Format table

The basic form is saved as mentioned above , You need to save a table with a certain format, and you need to set the cells .

one , establish sheet surface

$i Variables are equivalent to representing sheet Tabular id Number ,
$sheet_name The variable is the name of the table , It can also be set without , There is a default name .

$excel->createSheet();		// establish sheet
$excel->setactivesheetindex($i);	//sheet Indexes 
$excel->getActiveSheet()->setTitle($sheet_name);

Ii. , Cell settings

1, merge cell

2, Cell background color

3, font size

4, The font color

5, Font background color

6, Font settings

7, Cell width and height

Set up B The column width is 10

$excel->getActiveSheet()->getColumnDimension()->setAutoSize(true);
$excel->getActiveSheet()->getColumnDimension(\'B\')->setWidth(10);