自定义导出表格

最新推荐文章于 2024-05-14 13:48:56 发布

adf1256

最新推荐文章于 2024-05-14 13:48:56 发布

阅读量213

点赞数

文章标签： xhtml

原文链接：http://www.cnblogs.com/JdsyJ/p/9719314.html

版权

可参考: https://www.cnblogs.com/koxi/p/9703184.html

$filename = 'demo';
$title = array('序号','申请时间','申请人','备注名称','申请人手机号','提现金额','操作时间','操作人');
$data = array(array());
ob_end_clean();
Header('content-Type:application/vnd.ms-excel;charset=utf-8');

header("Content-Disposition:attachment;filename=".$filename.".xls");
//处理中文文件名
$ua = $_SERVER["HTTP_USER_AGENT"];

$encoded_filename = urlencode($filename);
$encoded_filename = str_replace("+", "%20", $encoded_filename);
if (preg_match("/MSIE/", $ua) || preg_match("/LCTE/", $ua) || $ua == 'Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko') {
header('Content-Disposition: attachment; filename="' . $encoded_filename . '.xls"');
}else {
header('Content-Disposition: attachment; filename="' . $filename . '.xls"');
}
header ( "Content-type:application/vnd.ms-excel" );

$html = "<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml'>
<meta http-equiv='Content-type' content='text/html;charset=UTF-8' />
<head>

<title>".$filename."</title>
<style>
td{
text-align:center;
font-size:12px;
font-family:Arial, Helvetica, sans-serif;
border:#1C7A80 1px solid;
color:#152122;
width:auto;
}
table,tr{
border-style:none;
}
.title{
background:#7DDCF0;
color:#FFFFFF;
font-weight:bold;
}
</style>
</head>
<body>
<table width='100%' border='1'>
<tr>";
foreach($title as $k=>$v){
$html .= " <td class='title' style='text-align:center;'>".$v."</td>";
}

$html .= "</tr>";

foreach ($data as $key => $value) {
$html .= "<tr>";
foreach($value as $aa){
$html .= "<td>".$aa."</td>";
}

$html .= "</tr>";

}
$html .= "</table></body></html>";
echo $html;
exit;

转载于:https://www.cnblogs.com/JdsyJ/p/9719314.html

adf1256

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
自定义导出表格

可参考:https://www.cnblogs.com/koxi/p/9703184.html$filename = 'demo'; $title = array('序号','申请时间','申请人','备注名称','申请人手机号','提现金额','操作时间','操作人'); $data = array(array()); ...
复制链接

扫一扫