PHP completes the function of excel download through html-table form

This article mainly introduces the function of php to complete excel downloading in the form of html-table. It has a certain reference value. Now I share it with everyone. Friends in need can refer to it

/** 
* @param $datas  具体数据 
* @param $titles 列名 
* @param $filename 文件名 
* @param $extraMessage 额外信息 
*/
public static function createExcel($datas, $titles, $filename, $extraMessage = ''){    
$str = "\r\n\r\n\r\n
\r\n";    
$str .= "";    
//表头    
$str .= "";    foreach ($titles as $title)
 {        
$str .= "\n";    
//具体数据    
foreach ($datas as $key => $rt)
 {        
$str .= "";        
foreach ($rt as $k => $v)
 {            
$str .= "";        
}        
$str .= "\n";    
}    
//额外信息    
if (!empty($extraMessage))
 {        
$str .= "";    
}    
$str .= "
{$title}";    
}    
$str .= "
{$v}
{$extraMessage}
";    
header("Content-Type: application/vnd.ms-excel; name='excel'");    
header("Content-type: application/octet-stream");    
header("Content-Disposition: attachment; filename=" . $filename);    
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");    
header("Content-Type:application/download");;    
header("Pragma: no-cache");    
header("Expires: 0");    
exit($str);
}

The total of the export at the bottom is additional information

##The above is the entire content of this article, I hope it will be helpful to everyone Learning will be helpful. For more related content, please pay attention to the PHP Chinese website!

PHP implements special effects of Chinese circular seal

PHP import progress bar class

How to download zip images using php

The above is the detailed content of PHP completes the function of excel download through html-table form. For more information, please follow other related articles on the PHP Chinese website!