Home >Backend Development >PHP Tutorial >PHP completes the function of excel download through html-table form
PHP completes the function of excel download through html-table form
- 不言Original
- 2018-07-05 16:11:201993browse
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 = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\nxmlns:x=\"urn:schemas-microsoft-com:office:excel\"\r\nxmlns=\"http://www.w3.org/TR/REC-html40\">\r\n<head>\r\n<meta http-equiv=Content-Type content=\"text/html; charset=utf-8\">\r\n</head>\r\n<body>";
$str .= "<table border=1>";
//表头
$str .= "<tr>"; foreach ($titles as $title)
{
$str .= "<td style='width: 60px;'>{$title}</tdw>";
}
$str .= "</tr>\n";
//具体数据
foreach ($datas as $key => $rt)
{
$str .= "<tr>";
foreach ($rt as $k => $v)
{
$str .= "<td>{$v}</td>";
}
$str .= "</tr>\n";
}
//额外信息
if (!empty($extraMessage))
{
$str .= "<tr style='height:50px;border-style:none;'><th border=\"0\" style='height:60px;width:270px;font-size:22px;' colspan='19' >{$extraMessage}</th></tr>";
}
$str .= "</table></body></html>";
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!
Related recommendations:PHP implements special effects of Chinese circular seal
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!