How to convert table to excel: first define an "excelData" method; then set the table data, head and header; finally generate it through "excelData($dataResult, $titlename...;)" Excel file is enough.
Recommendation: "PHP Video Tutorial"
php Generate excel file based on html table
\r\n\r\n\r\n
\r\n";
$str .= "
" . $titlename . "
";
$str .= $title;
foreach ($datas as $key => $rt) {
$str .= "";
foreach ($rt as $k => $v) {
$str .= "{$v} | ";
}
$str .= "
\n";
}
$str .= "
";
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保险公司 优惠券赠送记录";
$title = "优惠券记录";
$headtitle = "
{$headTitle} |
---|
";
$titlename = "
合作商户 |
会员卡号 |
车主姓名 |
手机号 |
车牌号 |
优惠券类型 |
优惠券名称 |
优惠券面值 |
优惠券数量 |
赠送时间 |
截至有效期 |
";
$filename = $title . ".xls";
excelData($dataResult, $titlename, $headtitle, $filename);
echo 'success';
Copy after login
The above is the detailed content of How to convert php table to excel. For more information, please follow other related articles on the PHP Chinese website!