站長資訊網(wǎng)php table轉(zhuǎn)excel的實現(xiàn)方法：首先定義一個“excelData”方法；然后設(shè)置表格數(shù)據(jù)、head以及表頭；最后通過“excelData($dataResult, $titlename, $headtitle…;”方式生成excel文件即可。
推薦：《PHP視頻教程》
php 根據(jù)html table生成excel文件
<?php /* *處理Excel導(dǎo)出 *@param $datas array 設(shè)置表格數(shù)據(jù) *@param $titlename string 設(shè)置head *@param $title string 設(shè)置表頭 */ function excelData($datas, $titlename, $title, $filename) { $str = "<html xmlns:o="urn:schemas-microsoft-com:office:office"rnxmlns:x="urn:schemas-microsoft-com:office:excel"rnxmlns="http://www.w3.org/TR/REC-html40">rn<head>rn<meta http-equiv=Content-Type content="text/html; charset=utf-8">rn</head>rn<body>"; $str .= "<table border=1><head>" . $titlename . "</head>"; $str .= $title; foreach ($datas as $key => $rt) { $str .= "<tr>"; foreach ($rt as $k => $v) { $str .= "<td>{$v}</td>"; } $str .= "</tr>n"; } $str .= "</table></body></html>"; echo $str; 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("Pragma: no-cache"); header("Expires: 0"); exit($str); } $dataResult = array(array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11), array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11)); $headTitle = "XX保險公司 優(yōu)惠券贈送記錄"; $title = "優(yōu)惠券記錄"; $headtitle = "<tr style='height:50px;border-style:none;><th border="0" style='height:60px;width:270px;font-size:22px;' colspan='11' >{$headTitle}</th></tr>"; $titlename = "<tr> <th style='width:70px;' >合作商戶</th> <th style='width:70px;' >會員卡號</th> <th style='width:70px;'>車主姓名</th> <th style='width:150px;'>手機號</th> <th style='width:70px;'>車牌號</th> <th style='width:100px;'>優(yōu)惠券類型</th> <th style='width:70px;'>優(yōu)惠券名稱</th> <th style='width:70px;'>優(yōu)惠券面值</th> <th style='width:70px;'>優(yōu)惠券數(shù)量</th> <th style='width:70px;'>贈送時間</th> <th style='width:90px;'>截至有效期</th> </tr>"; $filename = $title . ".xls"; excelData($dataResult, $titlename, $headtitle, $filename); echo 'success';
