public function tableexcel()
{
$list = db(‘ecword’)->limit(10000)->select();
$strTable = ‘<table width=”1000″ border=”1″>’;
$strTable .= ‘<tr>’;
$strTable .= ‘<td style=”text-align:center;font-size:12px;width:40px;”>id</td>’;
$strTable .= ‘<td style=”text-align:center;font-size:12px;” width=”*”>唯一标识</td>’;
$strTable .= ‘<td style=”text-align:center;font-size:12px;” width=”*”>英文</td>’;
$strTable .= ‘<td style=”text-align:center;font-size:12px;” width=”*”>中文</td>’;
$strTable .= ‘<td style=”text-align:center;font-size:12px;” width=”*”>添加时间</td>’;
$strTable .= ‘<td style=”text-align:center;font-size:12px;” width=”*”>状态</td>’;
$strTable .= ‘</tr>’;
foreach ($list as $k => $val) {
$strTable .= ‘<tr>’;
$strTable .= ‘<td style=”text-align:center;font-size:12px;”> ’ . $val[‘id’] . ‘</td>’;
$strTable .= ‘<td style=”text-align:left;font-size:12px;”>’ . $val[‘apid’] . ‘ </td>’;
$strTable .= ‘<td style=”text-align:left;font-size:12px;”>’ . $val[‘english’] . ‘</td>’;
$strTable .= ‘<td style=”text-align:left;font-size:12px;”>’ . $val[‘chinese’] . ‘</td>’;
$strTable .= ‘<td style=”text-align:left;font-size:12px;”>’ . date(‘Y-m-d H:i:s’, $val[‘add_time’]) . ‘</td>’;
$strTable .= ‘<td style=”text-align:left;font-size:12px;”>’ . $val[‘status’] . ‘</td>’;
$strTable .= ‘</tr>’;
}
$strTable .= ‘</table>’;
$filename = ‘ecword’;
header(“Content-type: application/vnd.ms-excel”);
header(“Content-Type: application/force-download”);
header(“Content-Disposition: attachment; filename=” . $filename . “_” . date(‘Y-m-d’) . “.xls”);
header(‘Expires:0’);
header(‘Pragma:public’);
echo ‘<html><meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />’ . $strTable . ‘</html>’;
}
做tpshop商城后台数据导出的时候出现超时错误，然后找到源码，发现其没用PHPExcel等实现数据导出，
然后就根据他写的table格式自己写了一个方法测试，可实现excel文件导出。
发表回复