浏览文章
文章信息
前端导出html表格到Excel表格显示科学计数法问题解决
1865
文本用法示例:
<td style=\"vnd.ms-excel.numberformat:@\">125467892</td>
还支持其他的:
完整示例:
/**导出UPC映射关系*/ public function export_excel() { # 提取所有产品的SEO URL $sql = <<<SQL SELECT p.product_id, p.sku, p.upc FROM oc_product p SQL; $result = $this->model->query($sql)->rows; # 下载产品Excel $search = ""; foreach ($result as $key => $val) { $upc = (string)$val['upc']; $search .= "<tr> <td>{$val['product_id']}</td> <td>{$val['sku']}</td> <td style=\"vnd.ms-excel.numberformat:@\">{$upc}</td> </tr>"; } $table = "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' /> <table border='1' width='100%'> <tr> <td>产品ID</td> <td>SKU</td> <td>UPC</td> </tr>" . $search . " </table>"; $file_name = 'UPC映射表' . date("Y-m-d H:i:s"); header("Pragma: public"); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition: inline;filename=$file_name.xls"); echo $table; exit; }